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, SAP recommends that you leave the old
database and device alone and add a new device that is large enough to hold the
additional memory, and alter the
sybsystemprocs onto
the new device.
- 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.
- 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 preparatory
tasks before ugprading.