Installation guide

create table [table] ( [int] int, [another int] int )

Run sp_checkreswords in master and in each user database to display the names and

locations of conflicting identifiers.

See

Reference Manual: Procedures

for information about sp_dboption, sp_rename, and

sp_checkreswords.

Quoted Identifiers

To avoid reserved word conflicts, all users on the server must invoke the quoted_identifier

option in all stored procedures and queries that include the reserved words.

To invoke the quoted_identifier option of the set command in procedures and queries that

include the reserved words, enclose the reserved words that are identifiers in double quotation

marks. The set quoted_identifier option tells Adaptive Server to treat any character string

enclosed in double quotation marks as an identifier.

See

Reference Manual: Commands

for more information on set quoted_identifier.

Preparing the Database and Devices

Before starting the upgrade process, confirm that you have enough space for the upgrade to

succeed.

Double the size of the largest catalog that you are going to upgrade, then add

approximately 10 percent to calculate the free space required for the upgrade to succeed.

For example, if you have a large number of stored procedures or compiled objects in any

database, the syscomments and sysprocedures system tables require additional space.

Sybase recommends that you use the preupgrade utility, since it scans the system catalogs

and performs this calculation automatically.

If you are:

• Not using two-phase commit or distributed transaction management (DTM)

applications – create a sybsystemdb with a minimum of 4MB if it does not already

exist.

• Using two-phase commit or DTM, either:

• Create a minimum-sized sybsystemdb for upgrade and expand it later, or

• Create a sybsystemdb of 5 to 20MB, depending on your expected usage.

Approximately 25 percent of the database should be data storage, and 75 percent

should be log storage.

If it does not already exist, create the sybsystemdb database. Servers that use a 2K

logical page size require a sybsystemdb that is at least 4MB. Servers that use a larger

logical page size require a sybsystemdb that is at least as large as the model database:

1> create database sybsystemdb on default = '4M'

2> go

1> use sybsystemdb

2> go

CHAPTER 10: Adaptive Server Upgrades

78 Adaptive Server Enterprise