Preparing the database and devices for the upgrade

If you ran the pre-upgrade option in sqlupgrade, 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.

NoteSybase recommends that you use preupgrade to determine how much free space is required for the upgrade.

StepsIncreasing default database sizes

sp_helpdb or Sybase Central can be used 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
    

    NoteYou must increase the size of tempdb before increasing the size of model.

  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