Installation guide

Procedure

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.

Caution

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 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.

3. 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.

Installation Guide for Linux

SAP ASE Upgrades