Installation guide

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.
Prerequisites
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 .
Task
This procedure involves dropping the database. For more information on drop database, see
the
Reference Manual .
1.
Determine which device you must remove:
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
and not exists (select vstart
from sysusages u2
where u2.dbid != u.dbid
and u2.vstart between d.low and d.high)
where:
•
d.name – is the list of devices to remove from sysdevices.
• d.phyname – is the list of files to remove from your computer.
The not exists clause in this query excludes devices that are used by sybsystemprocs
and other databases.
Make a note of the names of the devices to use in subsequent steps.
Warning! Do not remove any device that is in use by a database other than
sybsystemprocs, or you will destroy that database.
2.
Drop sybsystemprocs:
1> use master
2> go
1> drop database sybsystemprocs
2> go
Note: In versions of Adaptive Server Enterprise earlier than 15.x, use sysdevices to
determine which device has a low through high virtual page range that includes the
vstart from step 2.
In version 15.x, select the
vdevno from sysusages matching the dbid retrieved in step
1.
CHAPTER 10: Adaptive Server Upgrades
Installation Guide 81