Installation guide

Remove the device:

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 that were returned in the

d.phyname

list.

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 = 200M

5> go

Note: Server versions 12.0.x and later accept, but do not require "vdevno=number".

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: Commands

Create a sybsystemprocs database of the appropriate size on that device, for

example:

1> create database sybsystemprocs on sysprocsdev = 180

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

CHAPTER 10: Adaptive Server Upgrades

82 Adaptive Server Enterprise