Prepare the database and devices for the upgrade

Make sure that master is the default database for the “sa” user. The upgrade cannot complete successfully with a different database as your default. For information about specifying the default database, see the System Administration Guide.

If you ran the pre-upgrade option in sqlupgrade, the utility scanned the system catalogs and calculated how much additional space you needed 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.

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

An installation of Adaptive Server 12.0, without any additional user-defined data creates the following:

tempdb with 2MB
model with 2MB
master database with 6MB

If you are upgrading an Adaptive Server installation that meets these minimum parameters, you must increase:

tempdb to 4MB
model to 4MB
master database to 8MB

Use sp_help to determine the size of your existing databases. If any database does not have the space requirements as reported by preupgrade, use alter database to increase the size.

Increasing default database sizes

To determine the size of each databases in the old installation, log in to Adaptive Server using isql:
isql -Usa -Ppassword -Sserver_name
Enter:
1> sp_helpdb database_name
2> go
where database_name is the name of the system database you are checking.

To enlarge the master, tempdb, and model databases:

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.
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
```
You must increase the size of tempdb before increasing the size of model.
Verify the size of each database. Enter:
```
1> sp_helpdb database_name
2> go
```
where database_name is the name of the system database you are checking.