ATM Transaction Anayzer User and Installation Guide

Troubleshooting HP NonStop ATM Transaction Analyzer 136
7-6 ZTOFFSET Utility
The ZTOFFSET utility is used to display the closest offset in TLFDB file for a given transaction time stamp. This
Utility is used where transactions are occurring on two nodes: Primary Node and Disaster Recovery (DR) Node.
In this scenario, the transactions stored on Primary Node get replicated on Disaster Recovery Node. When the
Primary Node is down due to any failure, the data gets simultaneously stored on the Disaster Recovery node.
The ATM/TA backend environment will be installed on both the nodes, thereby duplicating the transaction data
on the DR Node. The front-end application is configured in such a way that it will receive transactions only from
the Primary Node (using the elink.cfg file).
When the primary node is down the transactions for that interval will occur only on the DR node. The ZTOFFSET
utility extracts the offset of the transaction closest to the failure timestamp (when primary node went down) from
the TLFDB (available on DR node) file. This offset will be updated in the nodeinfo table of the DR node on
Database server. Restart the front end application on DR node to recover all the missing transactions.
Syntax:
RUN ZTOFFSET [-TIME] [YYYY:MM:DD:HH:MM:SS] [-BEGINTRANS <num>] [-ENDTRANS <num>]
A sample output has been provided for your reference.
RUN ZTOFFSET -TIME 2009-06-05:01:30:41
***Started: 2009-06-05:01:30:41
Run tlinfoo -Time 2009-06-05:01:30:41
Closest offset: 82729420
Closest Time: 2009-06-05:01:30:40 (GMT: 2009-06-05:08:30:40)
Offset in MASTDB = 87199468
#Transactions: = 451807
Transactions:
From: 2009-05-31:13:12:17 (GMT: 2009-05-31:20:12:17)
To: 2009-06-05:05:08:49 (GMT: 2009-06-05:12:08:49)
***Stopped: 2009-06-05:01:30:41
---------------------------------------------------------------------------------