Sybase Adaptive Server 15.0.2, Installation Manual

Page: 153 / 160

APPENDIX C Using sybsystemprocs
Installation Guide
139
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
139.
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