Filter
Top Products
Increasing device and database capacity for system procedures
138 Adaptive Server Enterprise
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 any devices that are used
both by
sybsystemprocs and other databases.
Note the names of the devices; you will need them in the steps.
2 Drop
sybsystemprocs:
use master
go
drop database sybsystemprocs
go
Note In versions of Adaptive Server Enterprise prior to 15.0, you use
sysdevices to determine which device has a low through high virtual page
range that includes the vstart from Step 2. The device fragment whose
vstart you used is on that device
In the 15.0 version of Adaptive Server Enterprise select the
vdevno from
sysusages matching the dbid retrieved in Step 1.
3 Remove the device or devices using
sp_configure:
sp_configure "allow updates", 1
go
delete sysdevices
where name in ("devname1", "devname2", ...)
go
sp_configure "allow updates", 0
go
The where clause contains the list of device names returned by the query
in step 1.
Note Each device name must have quotes. For example, “devname1”,
“devname2”, and so on.