Filter
Top Products
CHAPTER 5 Upgrading Adaptive Server
Installation Guide 63
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 preupgrade, 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:
1In
isql, use alter database to increase the size of the master database. For
example:
1> use master
2> go
1> alter database master on master=x
2> go
This example increases the size of the master database; x is the number of
megabytes of space added to the existing database size.
2 Repeat this step to increase the size of each of the
tempdb and the model
databases. For example:
1> alter database tempdb on master=x
2> go
1> alter database model on master=x