Sybase Adaptive Server 15.0.2, Руководство по установке

Страница: 81 / 160

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
.