POS Transaction Analyzer User and Installation Guide, SST Version 1.2

Troubleshooting HP NonStop POS Transaction Analyzer 133
7-6 ZTOFFSET Utility
The ZTOFFSET utility is used to display the closest offset in PTLFDB 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 POS/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 PTLFDB (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 ptlinfoo -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
---------------------------------------------------------------------------------
NOTE: You must define the –TIME parameter in order to run the ZTOFFSET Utility.
Troubleshooting HP NonStop POS Transaction Analyzer