Discussion:
error "Database Page size too big"
(too old to reply)
abcd
2005-07-25 23:13:59 UTC
Permalink
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-26 00:03:52 UTC
Permalink
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
Post by abcd
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-26 00:25:17 UTC
Permalink
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
Post by Raymond Kwong
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
Post by abcd
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
Chris Keating (iAnywhere Solutions)
2005-07-26 02:51:27 UTC
Permalink
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

*****************************************************************************
Post by abcd
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
Post by Raymond Kwong
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
Post by abcd
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
Chris Keating (iAnywhere Solutions)
2005-07-26 13:15:14 UTC
Permalink
For clarification, "largest database" should read "largest database page
size".
Post by Chris Keating (iAnywhere Solutions)
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
*****************************************************************************
Post by abcd
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
Post by Raymond Kwong
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
Post by abcd
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-26 15:35:27 UTC
Permalink
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.
Post by abcd
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
Post by Raymond Kwong
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
Post by abcd
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-28 19:59:33 UTC
Permalink
Raymond. Thanks. You have explained very nicely. By using -gp switch I could
open the DB file...

Thanks again.
Post by Raymond Kwong
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.
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.
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.
Post by abcd
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
Post by Raymond Kwong
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
Post by abcd
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
Loading...