If Lack of Space Prevents an Upgrade

During the upgrade process, the transaction log may fill due to system table changes. A full transaction log may prevent a successful Adaptive Server upgrade.

If you cannot continue with the upgrade process because the transaction log becomes full, log in to the new server and in isql, issue:

dump tran dbname with no_log

This frees the log space, and allows the upgrade process to continue.

In some cases, preupgrade space estimations are insufficient for the data copy phase of the upgrade process. In this case, an error is generated letting you know there is insufficient space in the system segment for the upgrade. The upgrade process stops and waits for space to be provided. Log in to the new server using isql, and increase the size of the database:

alter database dbname on device_name = "2m"

Note: Specify the size to alter the database with the unit specifier "m", or "M".