Sybase ADAPTIVE 15.0.2 - Manual (Page 153)

APPENDIX C Using sybsystemprocs
Installation Guide 137
If there is space available on another device, you can expand
sybsystemprocs to a second device, or initialize another device that is large
enough. For instructions on creating a larger sybsystemprocs device, see
“Increasing device and database capacity for system procedures” on page
137.
3 To verify that Adaptive Server has allocated more space to
sybsystemprocs , issue:
1> sp_helpdb sybsystemprocs
2> go
When the system procedures database is large enough to accommodate the
increased size of the
sybsystemprocs database, continue with the other
pre-upgrade tasks.
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.
This procedure involves dropping the database. For more information on drop
database , see the Reference Manual.
Warning! This procedure removes all stored procedures you have created at
your site. Before you begin, save your local stored procedures using the
defncopy utility. See the Utility Guide for more information.
v Creating a larger system procedures device (sysprocsdev)
1 Determine which device or devices you need to remove.
Warning! Do not remove any device that is in use by database other than
sybsystemprocs , or you will destroy that database.
select d.name, d.phyname
from sysdevices d, sysusages u
where u.vstart between d.low and d.high
and u.dbid = db_id("sybsystemprocs")
and d.status & 2 = 2