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:

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.


If the db_size setting is less than the required minimum, increase the size of sysprocdev.