Sybase 15.0.2 - Manual (Page 151)

Installation Guide 137
A P P E N D I X C
Using sybsystemprocs
Introduction
Note sysprocsdev is the default system name for this device. However, it
is frequently referred to as the sybsystemprocs device, as in the Adaptive
Server attribute window, since it stores the sybsystemprocs database.
Verify that the sybsystemprocs database is large enough. For an upgrade,
the recommended minimum size for sybsystemprocs is the larger of
120MB, or enough free space to accommodate the existing
sybsystemprocs database, and the largest catalog that is to be upgraded,
plus an additional 10 percent of the largest catalog’s size. The additional
10 percent is for logging upgrade changes.
You may need more space if you are adding user-defined stored
procedures. 120MBs accommodate additional internal data structures, but
does not account for the possibility of a large number of user-defined
system 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
Topic Page
Introduction 137
Increasing the size of the sybsystemprocs database 138
Increasing device and database capacity for system procedures 139