Increasing the size of the sybsystemprocs database – Sybase ADAPTIVE 15.0.2 User Manual
Page 152

Increasing the size of the sybsystemprocs database
136
Adaptive Server Enterprise
Use
sp_helpdevice
to determine the size of the
sysprocsdev
device:
1> sp_helpdevice sysprocdev
2> go
If the
db_size
setting is less than the required minimum, you must increase the
size of
sysprocdev
.
Increasing the size of the sybsystemprocs database
If your current
sybsystemprocs
database does not have the minimum space
required, there are two options for creating a new database with sufficient
space for the upgrade:
•
You can drop the old database and the device and create a new
sysprocsdev
device, or
•
You can leave the database and old device alone and add a new device
large enough to hold the additional megabytes, and alter the
sybsystemprocs
onto the new device. Sybase recommends that you expand
the current device.
v
Enlarging the sybsystemprocs database
1
If you do not have a current backup, create one.
2
In
isql
, use
alter database
to increase the size of the
sybsystemprocs
database. For example:
1> use master
2> go
1> alter database sybsystemprocs on sysprocsdev=40
2> go
In this example, “sysprocsdev” is the logical name of the existing system
procedures device and “40” is the number of megabytes of space to add.
If the system procedures device is too small, you may receive a message
similar to the following when you try to increase the size of the
sybsystemprocs
database:
Could not find enough space on disks to extend
database sybsystemprocs