Preparing the database and devices for the upgrade

If you ran preupgrade, the utility scans the system catalogs and calculates how much additional space you need to perform the upgrade.

If you did not run preupgrade, you must manually calculate how much free space to add to your system catalogs and databases.As a general rule, double the size of the largest catalog that you are going to upgrade, and add approximately 10 percent more. If you have a large number of stored procedures or compiled object in any database, the syscomments and sysprocedures catalogs will require additional space.

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:

1. In 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
   2> go
   

   The model database cannot be larger than the tempdb. First increase the size of tempdb, then increase the size of the model database.

3. Verify the size of each database. Enter the following, where database_name is the name of the system database you are checking:

   1> sp_helpdb database_name
   2> go