CHAPTER 5 Upgrading Adaptive Server
Installation Guide 67
1In
isql, use alter database to increase the size of the master database. For
example:
1> use master
2> go
1> alter database master on master=x
2> go
This example increases the size of the master database; x is the number of
megabytes of space added to the existing database size.
2 Repeat this step to increase the size of each of the
tempdb and the model
databases. For example:
1> alter database tempdb on master=x
2> go
1> alter database model on master=x
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.
