Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 08, 2017 at 09:00 AM

    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>

    Add comment
    10|10000 characters needed characters exceeded