Installation guide

1> sp_helpdb sybsystemprocs
2> go
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, increase the size of sysprocdev.
Increasing the Size of the sybsystemprocs Database
Create a new database with sufficient space if your current sybsystemprocs database
does not have the minimum space required for an upgrade.
Prerequisites
If you do not have a current backup of your old database, create one now.
Task
Although you can drop the old database and device and create a new sysprocsdev device,
Sybase recommends that you leave the old database and device alone and add a new device
large enough to hold the additional memory, and alter the sybsystemprocs onto the new
device.
1.
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 when you try to increase the size of the
sybsystemprocs database.
If there is space available on another device, expand sybsystemprocs to a second
device, or initialize another device that is large enough.
2.
Verify that Adaptive Server has allocated more space to sybsystemprocs:
1> sp_helpdb sybsystemprocs
2> go
When the database is large enough to accommodate the increased size of
sybsystemprocs, continue with the other preupgrade tasks.
CHAPTER 10: Adaptive Server Upgrades
80 Adaptive Server Enterprise