Sybase 15.0.2 - Manual (Page 81)

CHAPTER 5 Upgrading Adaptive Server
Installation Guide 67
1 In 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 .