Verifying configuration parameters  Creating a new default device other than master

Chapter 9: Configuring Adaptive Server for Failover on HP Tru64 TruCluster Server 5.x

Adding thresholds 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 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
    
  3. Perform these steps on both the primary and secondary servers. After you have completed these tasks, restart both servers to allow the static configuration parameters to take effect.





Copyright © 2005. Sybase Inc. All rights reserved. Creating a new default device other than master

View this book as PDF