Installation guide

10.5.4 The sybprocsdev device

Sybase system procedures are stored in the sybsystemprocs database, which is stored in the sysprocsdev

device. You may need to increase the size of sysprocsdev before upgrading SAP ASE.

Regardless of page size, when configuring a new server, the size of sybsystemprocs is:

● Minimum – 184 MB

● Default – 196 MB

For upgrades, you need an additional 10 percent of this.

You may need more space if you are adding user-defined stored procedures.

If your sybsystemprocs database does not meet these requirements and you have enough room on the device

to expand the database to the required size, use the alter database command to increase the database size.

Use:

● sp_helpdb to determine the size of the sybsystemprocs database:

1> sp_helpdb sybsystemprocs

2> go

● 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.

10.5.4.1 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. The minimum size of sybsystemprocs is 184MB; the recommended

size is 196MB.

Prerequisites

Create a current backup of your old database.

Context

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 and add a new device that is large enough to hold the additional

memory, and alter the

sybsystemprocs onto the new device.

Installation Guide for Linux

SAP ASE Upgrades