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 Adaptive Server.

The minimum/default sybsystemprocs size is 172MB for all page sizes when configuring a new server. 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.

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.
Increasing Device and Database Capacity for System Procedures
If you cannot fit the enlarged sybsystemprocs database on the system procedures device, increase the size of the device and create a new database.

Parent topic: Performing Tasks Before Upgrading