Real-time HDR replication monitor for Informix database servers. NOTE 1: You WILL need to change the infxEnvCmd sub at the bottom to generate the correct command-line to set up your Informix environment for your installation based on a DBSERVRNAME. See the existing sub for explanation. NOTE 2: At TransWorks all our DBSERVERNAME names also work as hostnames of the database server machines. If this is not true in your environment, you will also need to change the infxHost sub at the bottom of the script (above infxEnvCommand -- see NOTE 1). NOTE 3: This script relies on the /usr/bin/rsh command and rsh connectivity from the current host to the primary and/or secondary host. It will not be able to monitor replication synchronization otherwise. Tested with IDS 10.00.FC6, perl v5.8.2, and AIX 5.3. Works by executing the onstat -g dri command to determine the primary and secondary server names, then using onstat -l to check for the current logical log number and position on each (using rsh to run that command on whichever is the remote server). Continually displays the log numbers and positions, moving down a line each time the "number of logs behind" changes. Here is an example of the output: logs: primary=finp1n, secondary=fins1n logs: behind 0 log(s) at Sun May 20 09:47:12 EDT 2007: primary=530657, secondary=530657 logs: primary=530657 (39.72%), secondary=530657 (39.64%) In the above example, the first line shows the DBSERVERNAME of both the primary and secondary servers. The second line shows that the secondary is in synch with the primary, and that both are on logical log number 530657. The last line, which continually updates, shows that the primary is 39.72% through its current logical log, and that the secondary is 39.64% through its log. We use this script when we suspect we're having an issue with replication keeping up, and it has served us well. Please let me know if you have any questions, comments, or suggestions. Author: Chris Kelch Readme Version: $Id: logs.readme,v 1.1 2007/05/20 14:13:20 ckelc Exp $