Displaying X-Ref Transaction State

This document covers the following topics:

Function Description

Checking cross-references, or "X-refing", for transactions displays the state of the transactions contained in the selected log file or files. The resulting information shows which transactions have been applied to which replicate database files and, if applicable, special replicate file states ("in use", "error", etc.).

X-Ref Transaction State Screen

By either entering the Xref TRansactions direct command or selecting the X option on the main menu, the "X-Ref Transaction State" screen appears.

The X-Ref Transaction State Screen

 23:59:59          ***** ENTIRE TRANSACTION PROPAGATOR *****          2000-12-24
                            X-Ref transaction state





                      DBID      FNR
 Log file ..........* ______   ______


 Information level .. 1 (1=short, 3=extended)


 Printer name ....... ________ (' ' = terminal)






 Command ===>
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Menu  Exit  Last        Flip              Tech              Canc

To cross-reference check a log file, enter the information in the fields as described below. To display a master file's definition without log or replicate file information, enter the Display Master direct command DI MA on the command line at the bottom of the current screen.

Screen Field Description

Log File DBID/FNR Enter the database ID and file number of the log file you want cross-reference checked. If you enter a wild card in either the database ID or file number field, a window appears from which you can select one or more log file definitions to check.
Information Level specifies the amount of information to be displayed for every selected log file. The higher the level, the more information is displayed and the more database calls and processor time is required to provide the requested information:
1 Display the date/time of the last transaction applied to the replicate databases.
2 Same as 1, but additionally displays date/time of the generation of the last transaction in the log file.
3 Same as 2, but additionally displays the number of transactions that are still unreplicated.
Printer Name To print out the information for the selected master files, enter a valid printer ID here. Leaving this field blank causes the resulting information to be displayed on your terminal.

X-Ref Transaction State User Application Programming Interface

With correction ET15205 applied to ETP Version 1.5.2, the user application programming interface (API) WADUSR4N is available which provides information similar to the Xref TRansactions direct command described above. Instead of displaying the available information on the screen, WADUSR4N returns the information in output parameters.

In addition to the subprogram WADUSR4N, the following Natural objects are also delivered:

  • parameter data area WADUSR4A, which describes the input and output parameters of subprogram WADUSR4N,

  • program WADUSR4P, which contains a sample call to WADUSR4N.

WADUSR4A and WADUSR4P are delivered in source form in library SYSETP, whereas WADUSR4N is delivered as a cataloged object in library SYSETP.

Because WADUSR4N uses ETP service routines, it must either be called from library SYSETP or have library SYSETP as a steplib library.