Pre-upgrade tasks
66 Adaptive Server Enterprise
Run sp_checkreswords in master and in each user database to display the names
and locations of conflicting identifiers.
For more information about
sp_rename and sp_checkreswords and methods for
avoiding reserved word conflicts, see the Reference Manual.
Using quoted identifiers
You can enclose the identifiers that are reserved words in double quotation
marks and invoke the
quoted_identifier option of the set command in
procedures and queries that include the reserved words. The
set
quoted_identifier
option tells Adaptive Server to treat any character string
enclosed in double quotation marks as an identifier.
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.
Preparing the database and devices for the upgrade
If you ran the pre-upgrade option in preupgrd.exe, the utility scanned the
system catalogs and calculated how much additional space you need to perform
the upgrade.
If you did not run the pre-upgrade check, you must manually calculate how
much free space you must add to your system catalogs and databases.As a
general rule, you must double the size of the largest catalog that you are going
to upgrade, and add approximately 10 percent more to calculate the free space
required for the upgrade to succeed. For example, if you have a large number
of stored procedures or compiled object in any database, the
syscomments and
sysprocedures catalogs will require additional space.
Note Sybase recommends that you use preupgrade to determine how much
free space is required for the upgrade.
v Increasing default database sizes
You can use sp_helpdb or Sybase Central to determine the current size of the
master, model, sybsystemprocs, and tempdb databases.
To enlarge the
master, tempdb, and model databases:
