Verifying configuration parameters  Configuring companion servers for failover

Chapter 14: Configuring Adaptive Server for Failover on SGI IRIX

Adding a threshold to the master log

If you have not already done so, 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 Adaptive Server Reference Manual for information about creating this system procedure.

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

    sp_addthreshold "master", "logsegment", 250, sp_thresholdaction
    
  3. Restart the primary companion for this static parameter to take effect.





Copyright © 2005. Sybase Inc. All rights reserved. Configuring companion servers for failover

View this book as PDF