Filter
Top Products
Pre-upgrade tasks
64 Adaptive Server Enterprise
2> go
Note The model database cannot be larger than the tempdb. If your
changes cause the
model database to be larger than the tempdb, then you
must first increase the size of
tempdb, before increasing the size of the
model database.
3 Verify the size of each database. Enter the following, where
database_name is the name of the system database you are checking:
1> sp_helpdb database_name
2> go
Create a sybsystemdb database
In version 11.9.x, the sybsystemdb database was required only for servers using
two-phase commit transactions. Beginning with version 12.0, all servers must
have a
sybsystemdb database. Adaptive Server uses this database for tracking
transactions and during recovery. In addition, it is used for applications using
two-phase commit and Distributed Transaction Management (DTM).
If you have a sybsystemdb database
If you have a sybsystemdb and the database is at least 4MB, you do not need to
make any changes. If the database is smaller than 4MB, increase the size with
alter database.
If you do not have a sybsystemdb database
If you do not have a sybsystemdb, and will not be using two-phase commit or
DTM applications, create a
sybsystemdb with a minimum of 4MB.
If you will be using two-phase commit or DTM, you can either:
• Create a minimum-sized
sybsystemdb for upgrade and expand it later, or
• Create a
sybsystemdb of 5 to 20MB, depending on your expected usage.
Approximately 25 percent of the database should be data storage, and 75
percent should be log storage.