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

[former_member287614]

Hello guys.

I'm Installing ERP EHP8 ASE 16.0 on Windows. I'm in the process of updating it to the last Support stack with SUM.

I am in the 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.

This is my first experience with ASE, what do you recommend me to do?

In the installation I defined the logs in 20 GB.

Regards.

Desiree C

[Former Member · Accepted solution]

Hello,

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

1. Log in on your server with user syb<sid>

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

> isql -Usapsa -P<password> -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 '<SID>'.

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

effect.

(return status = 0)

1> checkpoint

2> go

1>