Add thresholds to the master log

If you have not already done so, you must add a threshold to the master log.

  1. Define and execute sp_thresholdaction on the master database’s log to set a threshold on the number of pages left before a dump transaction occurs. Sybase does not supply sp_thresholdaction. See the System Administration Guide and the Adaptive Server Reference Manual for information about creating this system procedure.

  2. Place thresholds on the master log segment so it does not fill up:

    sp_addthreshold "master", "logsegment", 250, sp_thresholdaction
    
  3. Restart Adaptive Server for this static parameter to take effect.