SQL Anywhere database - error "Database Page size too big"

Author

error "Database Page size too big"

abcd

2005-07-25, 8:25 pm

I have a DB file xyz.db. I want to connect thru ASA 9.01

I get error

could not connect to database
database page size too big"

Any clues

thanks

Raymond Kwong

2005-07-25, 8:25 pm

From documentation:

Adaptive Server Anywhere Error Messages
1. Database Error Messages
Alphabetic list of error messages

Database page size too big

You attempted to start a database or create a write file for a
database with a page size that exceeds the maximum page size of the
running server. Either restart the server with this database named on
the command line, or restart the server with a larger page size (i.e.,
please review the documentation on the -gp switch).

Raymond Kwong
iAnywhere Solutions

On 25 Jul 2005 16:13:59 -0700, "abcd" <abcd@abcd.com> wrote:

>I have a DB file xyz.db. I want to connect thru ASA 9.01
>
>I get error
>
>could not connect to database
>database page size too big"
>
>Any clues
>
>thanks
>
>

abcd

2005-07-25, 8:25 pm

I didnt understand this message. Yesterday I was ablt to connect the same db
file by clicking connect then entering my DBA login pass and selecting the
db file and today its giving me this error....Nothing has been modified on
the machine since the last successful connection....

any other detailed tips

thanks

Raymond Kwong wrote:[color=darkred
]
> From documentation:
>
> Adaptive Server Anywhere Error Messages
> 1. Database Error Messages
> Alphabetic list of error messages
>
> Database page size too big
>
>
> You attempted to start a database or create a write file for a
> database with a page size that exceeds the maximum page size of the
> running server. Either restart the server with this database named on
> the command line, or restart the server with a larger page size (i.e.,
> please review the documentation on the -gp switch).
>
>
>
>
> Raymond Kwong
> iAnywhere Solutions
>
> On 25 Jul 2005 16:13:59 -0700, "abcd" <abcd@abcd.com> wrote:
>

Chris Keating \(iAnywhere Solutions\)

2005-07-26, 3:23 am

You have a running engine that has a smaller page size than the database you
wish to start. You must start the engine with an equal (or larger) page size
as the largest database you want to run. Check to see if you have other
engines running on the system.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

********************
********************
********************
*****************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

********************
********************
********************
*****************

"abcd" <abcd@abcd.com> wrote in message news:42e582ea@forums
-2-dub...
>I didnt understand this message. Yesterday I was ablt to connect the same
>db file by clicking connect then entering my DBA login pass and selecting
>the db file and today its giving me this error....Nothing has been modified
>on the machine since the last successful connection....
>
> any other detailed tips
>
> thanks
>
>
>
> Raymond Kwong wrote:
>
>

Chris Keating \(iAnywhere Solutions\)

2005-07-26, 9:23 am

For clarification, "largest database" should read "largest database page
size".

"Chris Keating (iAnywhere Solutions)" < FightSpam_keating@iA
nywhere.com>
wrote in message news:42e5a52f@forums
-1-dub...
> You have a running engine that has a smaller page size than the database
> you wish to start. You must start the engine with an equal (or larger)
> page size as the largest database you want to run. Check to see if you
> have other engines running on the system.
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> ********************
********************
********************
*****************
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
> ********************
********************
********************
*****************
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
> ********************
********************
********************
*****************
>
> "abcd" <abcd@abcd.com> wrote in message news:42e582ea@forums
-2-dub...
>
>

Raymond Kwong

2005-07-26, 11:23 am

Your observation can be simply explained by the fact that you didn't
have an existing dbeng9/dbsrv9 session already running the previous
time. I can think of users autostarting engines and forgetting to shut
it down, leaving an engine session not capable of running with
database files with larger page sizes.

Perhaps I can elaborate in another manner:

For example if you have two database files, abc.db and xyz.db

abc.db is created with a page size of 2kb

xyz.db is created with a page size of 4kb

When you start a database engine to load abc.db first, by default
(i.e. no -gp switch used), the "database server page size" is the page
size of the first database file you load, in the case of abc.db, it
means the 2kb.

If your connection parameters is set up in such a manner that you
would be attempting to start xyz.db on the same server database
engine/server as well, since it has a page size of 4kb which is beyond
what the database server/engine can handle, that attempt will result
in the error message.

So, the questions are:

1. Do you intend to have two database files running on the same
machine?

2. Do you intend to have the two database files running on the same
database server/engine session?

If the answer to both questions above is yes, then be prepared to
tweak your process either by changing the ordering of .db file loading
(load the one with the largest page siz first), or by using this -gp
switch.

On 25 Jul 2005 17:25:17 -0700, "abcd" <abcd@abcd.com> wrote:

>I didnt understand this message. Yesterday I was ablt to connect the same db
>file by clicking connect then entering my DBA login pass and selecting the
>db file and today its giving me this error....Nothing has been modified on
>the machine since the last successful connection....
>
>any other detailed tips
>
>thanks
>
>
>
>Raymond Kwong wrote:
>

abcd

2005-07-28, 8:23 pm

Raymond. Thanks. You have explained very nicely. By using -gp switch I could
open the DB file...

Thanks again.

"Raymond Kwong" <raymond. kwong_RAY158324@syba
se.com> wrote in message
news:s7lce1hgjb2r8ps
robrpj05kv6so0nkgk7@
4ax.com...
> Your observation can be simply explained by the fact that you didn't
> have an existing dbeng9/dbsrv9 session already running the previous
> time. I can think of users autostarting engines and forgetting to shut
> it down, leaving an engine session not capable of running with
> database files with larger page sizes.
>
>
> Perhaps I can elaborate in another manner:
>
> For example if you have two database files, abc.db and xyz.db
>
> abc.db is created with a page size of 2kb
>
> xyz.db is created with a page size of 4kb
>
>
> When you start a database engine to load abc.db first, by default
> (i.e. no -gp switch used), the "database server page size" is the page
> size of the first database file you load, in the case of abc.db, it
> means the 2kb.
>
> If your connection parameters is set up in such a manner that you
> would be attempting to start xyz.db on the same server database
> engine/server as well, since it has a page size of 4kb which is beyond
> what the database server/engine can handle, that attempt will result
> in the error message.
>
>
> So, the questions are:
>
> 1. Do you intend to have two database files running on the same
> machine?
>
> 2. Do you intend to have the two database files running on the same
> database server/engine session?
>
> If the answer to both questions above is yes, then be prepared to
> tweak your process either by changing the ordering of .db file loading
> (load the one with the largest page siz first), or by using this -gp
> switch.
>
>
> On 25 Jul 2005 17:25:17 -0700, "abcd" <abcd@abcd.com> wrote:
>
>

Sponsored Links