Skip to Content
0

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

Feb 05, 2017 at 01:24 PM

607

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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>

Share
10 |10000 characters needed characters left characters exceeded