database option

[Former Member]

Dear All, As per sap recommendations for sap ase database it is told

[Former Member · Accepted solution]

Dear All, Sorry above post is incomplete Dear All, As per sap recommendations for sap ase database it is told One or more database options are not set correctly. We strongly recommend that you set the following database options for SAP ASE database. The current settings can be checked using the stored procedure sp_helpdb 'SID' 1. enforce dump tran sequence = 1 2. trunk log on chkpt = 0 as per which we logged into isql and executed command as 1> use master 2> go 1> sp_dboption GXD,'enforce dump tran sequence','true' 2> go Msg 17957, Level 16, State 1: Server 'GXD', Procedure 'sp_dboption', Line 1091: You cannot set the 'enforce dump tran sequence' database option because the database 'GXD' is either marked as needing a database dump, an unlogged operation was performed or the transaction log was truncated. Dump the database, kindly advice

oss.txt.zip

[hans-juergen_schwindke · Accepted solution]

Hi,

you should

• first set "trunc log on chkpt" to false
• then perform a full database dump, and
• then set "enforce dump tran sequence" to true

You can set "enforce dump tran sequence" only if there are no truncated transactions since your last full backup.

Best regards,

Juergen

[Former Member · Accepted solution]

Hi Juergen,

We performed the command ''trunk log on chkpt" to false successfully. Then we performed a full system backup using an external backup tool commvault.

And then we execute the command "enforce dump tran sequence" to true we get below message. Kindly advice

[hans-juergen_schwindke · Accepted solution]

Hi,

for me the sequence

• trunc log on checkpoint --> false
• full database dump
• enforce dump tran sequence --> true

works (see attached screenshot).

Which output gives the stored procedure: sp_tran_dumpable_status <dbname>

This might give a hint of the cause.

I don't know your tool but maybe ASE does not recognize it as a full dump. Is it possible for you to do a full dump without the tool (dump database <dbname> to 'path_and_file').

Best regards,

Juergen

[tilman_model-bosch · Accepted solution]

The messages says 'enforce dump tran sequence'  cannot be set as eithger

- database needs a dump

- an an logged operation was performed

- or log was truncated

All three conditions must match.
Did someone run 'DUMP TRANSACTION <DBNAME> WITH TUNRCATE_ONLY' - to clear up the log ?

was an unlogged operation performed (e.g. SELECT INTO command was run manually)

With kind regards

Tilman Model-Bosch