Sybase ADAPTIVE 15.0.2 User Manual

Page 104

Advertising
background image

Recovering from a failed upgrade

88

Adaptive Server Enterprise

isql> dump tran dbname with no_log

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

In some cases, the pre-upgrade space estimations might be insufficient for
the data copy phase of upgrade. In this case, you may get an error that there
is insufficient space in the

system

segment for the upgrade. The upgrade

process hangs, waiting for space to be provided. You can log in to the new
server using

isql

, and use

alter database

to increase the size of the database.

isql> alter database dbname on device_name = "2m"

Note

In 15.0.2 Adaptive Server,

alter database

allows you to specify the

size to alter the database with the unit-specifier ‘m’, or ‘M’.

Advertising