Sybase Adaptive Server 15.0.2, Руководство по установке

Страница: 80 / 160

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: