If you have not already done so, add a threshold to the master log.
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 Adaptive Server Reference Manual for information about creating this system procedure.
Place thresholds on the master and sybsystemprocs log segments so they do not fill up:
sp_addthreshold "master", "logsegment", 250, sp_thresholdaction sp_addthreshold "sybsystemprocs", "logsegment", 250, sp_thresholdaction
Perform both steps on the primary and secondary servers, then restart both servers to allow the static configuration parameters to take effect.
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |