Installation guide

Procedure

1. In isql, use alter database to increase the size of the sybsystemprocs database. For example:

1> use master

2> go

1> alter database sybsystemprocs on sysprocsdev=40

2> go

In this example, "sysprocsdev" is the logical name of the existing system procedures device, and 40 is the

number of megabytes of space to add. If the system procedures device is too small, you may receive a

message when you try to increase the size of the sybsystemprocs database.

If there is space available on another device, expand sybsystemprocs to a second device, or initialize

another device that is large enough.

2. Verify that the SAP ASE server has allocated more space to sybsystemprocs:

1> sp_helpdb sybsystemprocs

2> go

Results

When the database is large enough to accommodate the increased size of sybsystemprocs, continue with the

other preupgrade tasks.

10.5.4.2 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. The minimum size of sybsystemprocs is 184MB; the recommended size

is 196MB.

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.

Context

This procedure involves dropping the database. For more information on drop database, see the Reference

Manual.

Installation Guide for Linux

SAP ASE Upgrades