Sybase ADAPTIVE 15.0.2 - 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