-
Determine which device or devices you must remove.
Warning!
Do
not
remove any device
that is in use by a 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
and not exists (select vstart
from sysusages u2
where u2.dbid != u.dbid
and u2.vstart between d.low and d.high)
-
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 the following
steps.
-
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.
-
Remove the device or devices using sp_configure:
1> sp_configure "allow updates", 1
2> go
1> delete sysdevices
where name in ("devname1", "devname2", ...)
2> go
1> sp_configure "allow updates", 0
2> 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.
If any of the named devices are OS files rather than raw partitions,
use the appropriate OS commands to remove those files.
-
Remove all files for the list of d.phyname that were returned.
Note: File names cannot be complete path names. If you use
relative paths, they are relative to the directory from which your
server was started.
-
Find another existing device that meets the requirements for
additional free space, or use a disk init command
similar to the following to create an additional device for sybsystemprocs where /sybase/work/ is
the full, absolute path to your system procedures device:
1> use master
2> go
1> disk init
2> name = "sysprocsdev",
3> physname = "/sybase/work/sysproc.dat",
4> size = 51200
5> go
Note: Server versions 12.0.x and later accept, but do not
require "vdevno=number".
In versions earlier than 12.0.x, the number for vdevno must
be available. For information about determining whether vdevno is
available, see the System Administration Guide.
The size you provide should be the number of megabytes of
space needed for the device, multiplied by 512. disk init requires
the size to be specified in 2K pages. In this example, the size
is 112MB (112 x 512 = 57344). For more information on disk
init, see the Reference Manual.
-
Create a sybsystemprocs database
of the appropriate size on that device, for example:
1> create database sybsystemprocs on sysprocsdev =
112
2> go
-
Run the installmaster
script in the old server
installation directory. Enter:
isql -Usa -Ppassword -Sserver_name -i$SYBASE/ASE-15_0/scripts/installmaster