Database option 'trunc log on chkpt' to 'true' for the SUM process

Issue:

During Upgrade step to start "Execution" and the process tells me: WARNING: 'Database log mode' will not be changed automatically. If you want to disable archiving now, set database option 'trunc log on' to 'true' for the XXX database.
Error occured in Sybase ASE.


Resolution:

To modify the log mode on Sybase ASE, you have to follow further steps :

1. Log in on your server with user syb

2. Launch with a command line tool to connect to ASE database

> isql -Usapsa -P< password > -S< SID > -X

3. On the SQL interface, enter the statements to change log mode

1> use master

2> go

1> sp_dboption <SID>, 'trunc',true

2> go

Database option 'trunc. log on chkpt.' turned OFF for database ''.

Running CHECKPOINT on database '' for option 'trunc. log on chkpt.' to take

effect.

(return status = 0)

1> checkpoint

2> go

After finish the Upgrade change the Setting "true" to "false".

1. Log in on your server with user syb

2. Launch with a command-line tool to connect to ASE database

> isql -Usapsa -P< password > -S< SID > -X
3. On the SQL interface, enter the statements to change log mode

1> use master

2> go

1> sp_dboption <SID> , 'trunc',false

2> go

Database option 'trunc. log on chkpt.' turned OFF for database ''.

Running CHECKPOINT on database '' for option 'trunc. log on chkpt.' to take

effect.

(return status = 0)

1> checkpoint

2> go

This command will ensure that everytime a checkpoint comes along, the Sybase dataserver engine will truncate the transaction log. You should not do this on a production server, as the transaction log is used for performing a complete restoration of data.  You may want to do this when you don't have enough space for keeping transaction data, like on a quality server or development server.