SAP ASE: Create Log Threshold Action

[jens_guntenhoener]

Hi,

in the dba cockpit, it is possible to create a "log threshold action"

Now I want to write a isql script to do this.
How can I do this and what is the command to create this logsegmant theshold on the database "XXX" with "2000" Size remaining, Action Type "Dump transaction log using dum configuration" with the dump configuration "LOG"?

Kind regards
Jens

[madhvi_pai]

Hi Jens,

Please see whether the sp included in SAP Note

1801984 - SYB: Automated management of long running transactions

helps in this case.

Thanks,

Madhvi Pai

SAP Product Support