REPORT (Generate Reports) › Recovery File (RXX) Report › Example JCL › TSNPRINT=DETAIL Sample

TSNPRINT=DETAIL Sample

Using the TSNPRINT=DETAIL option in an RXX Analysis Report generates the TSN DETAIL REPORT as shown in the following sample.

                      (CONTINUED)                                      Date: mm/dd/ccyy   Time: hh.mm.ss    Page:     43
 
                                                   TSN DETAIL REPORT
TSN      JOB      FIRST RECORD        LAST RECORD            REQUESTS STAT TBL DBID         ADD      DELETE      UPDATE  
 
00001A18 DLV1C131 mm/dd/ccyy hh.mm.ss mm/dd/ccyy hh.mm.ss          90 NN   MSG   15          45          45           0
00001A19 DLV1C131 mm/dd/ccyy hh.mm.ss mm/dd/ccyy hh.mm.ss          90 NN   MSG   15          45          45           0
00001A1A DLV1C131 mm/dd/ccyy hh.mm.ss mm/dd/ccyy hh.mm.ss          90 NN   MSG   15          45          45           0
00002252 DLV1C131 mm/dd/ccyy hh.mm.ss mm/dd/ccyy hh.mm.ss         124 NN   MSG   15          62          62           0
00002253 DLV1C131 mm/dd/ccyy hh.mm.ss mm/dd/ccyy hh.mm.ss         322 NN   MSG   15         161         161           0
00002280 DLV1C131 mm/dd/ccyy hh.mm.ss mm/dd/ccyy hh.mm.ss         304 NN   MSG   15         152         152           0

This portion of the report displays TSN Detail Report section.

TSN

Displays the transaction sequence number.

JOB

Displays the name of the job.

FIRST RECORD

Displays the date and time the first record in a transaction was processed.

LAST RECORD

Displays the date and time the last record in a transaction was processed.

REQUESTS

Displays the total number of requests for the transaction, that is, the sum of the number of ADD, DELETE, and UPDATE requests.

STAT

The first character under the STAT heading is a 1 (a numeral one) if the first record of the transaction was found among the selected input, or the first character is an N (NO) if the first record was not found. The second character in the STAT field is a Y (YES) if the transaction completion record was found among the selected input, else an N.

An indication that a transaction completed does not necessarily mean that it completed successfully. Some or all of the counts of adds, deletes, and updates may have been reversed and thereby nullified. The reversal can be done inline to the original log record or it can be done with an additional reversal log record. For example, an add could be reversed with a delete. Deletes are usually reversed as an update, but an add is possible. If these are concerns, then the detail log records would have to be reviewed to see more detail about each specific log record.

TBL

Displays the name of the table associated with the transaction.

DBID

Displays the database ID associated with the transaction.

ADD

Displays the total number of add requests for a transaction.

DELETE

Displays the total number of delete requests for a transaction.

UPDATE

Displays the total number of update requests for a transaction.