Using Thresholds to Automate dump transaction

Use thresholds to automate backup procedures. To take advantage of the SAP ASE last-chance threshold, create user databases with log segments on a separate device from data segments.

When space on the log segment falls below the last-chance threshold, the SAP ASE server executes the last-chance threshold procedure. Including a dump transaction command in your last-chance threshold procedure helps protect you from running out of log space. See sp_thresholdaction.

You can use sp_addthreshold to add a second threshold to monitor log space. For more information about thresholds, see the System Administration Guide.