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

LOGPRINT=DETAIL Sample

Specifying LOGPRINT=DETAIL in an RXX Analysis Report generates the following information, which continues for as many pages as necessary (not all pages are shown in this sample).

                      (CONTINUED)                                      Date: mm/dd/ccyy   Time: hh.mm.ss    Page:      2
                                                   LOGPRINT DETAIL REPORT
CMD   TBL DBID URI      BLOCK    L# TSN      JOB NAME R-UNIT MP USER ID AREA MONITOR INFO     INPUT RECORD FPR    RXX   
      DATE       TIME     CLOCK            SEC.USER MOVE TO  LRID     PREV     LRSN     LBSN     TASK STATUS RECL DATA 
 
ADDIT MSG   15 00000401 00000003 00 00001A18 DLV1C131 17,003    SQLDG001 MSG SCFDG001JVM00037           38
      mm/dd/ccyy hh.mm.ss B6F7A1DA0D189903 username 00000000 00000608 00000607 00000008 00000006    1 B      0175 6C3B
ADDIT MSG   15 00000402 00000003 00 00001A18 DLV1C131 17,003    SQLDG001 MSG SCFDG001JVM00037           39
      mm/dd/ccyy hh.mm.ss B6F7A1DA0D1D7363 username 00000000 00000609 00000608 00000009 00000006    1 B      0175 6C3B
ADDIT MSG   15 00000403 00000003 00 00001A18 DLV1C131 17,003    SQLDG001 MSG SCFDG001JVM00037           40
      mm/dd/ccyy hh.mm.ss B6F7A1DA0D2152A3 username 00000000 0000060A 00000609 0000000A 00000006    1 B      0175 6C3B
         .
         .
         .
DELET MSG   15 00000401 00000003 00 00001A18 DLV1C131 17,003    SQLDG001 MSG SCFDG001JVM00037           83
      mm/dd/ccyy hh.mm.ss B6F7A1DB93E43B61 username 00000000 00000635 00000634 00000035 00000006    1 B      015E 6C3B
DELET MSG   15 00000402 00000003 00 00001A18 DLV1C131 17,003    SQLDG001 MSG SCFDG001JVM00037           84
      mm/dd/ccyy hh.mm.ss B6F7A1DB93E7C541 username 00000000 00000636 00000635 00000036 00000006    1 B      015E 6C3B
         .
         .
         .

This portion of the report displays the following information:

CMD

Displays the CA Datacom/DB record-at-a-time command. In addition to record-at-a-time commands such as ADDIT, UPDAT, DELET, and COMIT, commands used internally can also appear in the report. Internal commands that support restart and recovery requirements are not typically documented, but because they might be seen in this report, a summary description follows.

• Commands that start with the letter Y, for example YYCTC, and DELAL are used to support CA Datacom Datadictionary or SQL.
• Commands that start with LOGP relate to two-phase commit.
• Commands that start with LOG (not LOGP) exist when needed for request or transaction control.
• The CYCLE command is used to note the start and end of a spill.
• The MOVER command relates to the movement of records, both during compressed record maintenance and execution of the DBUTLTY OLREORG function. For more information about the MOVER command, see Request Summary Report.
• Other commands that exist and could also appear in the report are not under the control of users.
• We reserve the right to add new internal commands and modify or delete existing commands as needed.

TBL

Displays the CA Datacom/DB table name in the Request Area. Blank for records without table names. For 'CYCLE' (the internal command), the table name contains 'STA' (for start of a cycle) and 'END' (for end of a cycle). A cycle refers to a sequential group of log blocks copied from the LXX to the RXX during one spill.

DBID

Displays the Database ID. Blank for records without database ID's. Printed as a decimal number.

URI

Displays the Unique Row Identifier. Blank for records without a URI number. Printed in hexadecimal format. Contains the literal 'NON-URI ' for areas not loaded as URI.

BLOCK

Displays the data area block number. Blank for records without a data block. Printed in hexadecimal format.

L#

Displays the data area block record number. Blank for records without a data block number. Contains '00' for records with a data block, if the area is loaded with the URI option. Printed in hexadecimal format.

TSN

Displays the Transaction Sequence Number. Blank for records not part of a transaction. Printed in hexadecimal format.

JOB NAME

Displays the job name.

R-UNIT

Displays the run unit number.

MP

Blank if not running r10 or later as a MUFplex. Otherwise, contains a MUFplex number of which MUF logged this log record.

USER ID

Displays the User ID. First 8 characters of the 32-byte user ID passed on the request.

AREA

Displays the data area name containing row.

MONITOR INFO

Displays the monitor information, if this request was made through the CA Datacom CICS Services or the CA Datacom Server.

INPUT RECORD

Displays the number of this input log record.

FPR

Displays the Full Parent name, if this table is partitioned, or a partition.

RXX

To indicate this is a recovery file. In z/OS, can contain LXX.

DATE

Displays the date the log record was added. Printed in the form mm/dd/ccyy.

TIME

Displays the time the log record was added. Printed in the form HH.MM.SS.

CLOCK

Displays the result of a hardware STCK (store clock) instruction at the time the log record was added.

SEC.USER

Displays the security user requesting maintenance.

MOVE TO

Displays the block number to where an update moved a record. Printed in hexadecimal format.

LRID

Displays the log record ID. The physical block number within the LXX where the log record was added in the first three bytes. The last byte is a sequential number within this log block, such that the first record is 1, and so forth. This field is provided to assist CA Support, should the need arise. Printed in hexadecimal format.

PREV

Displays the previous log record ID. Log records for a transaction are chained in reverse back to a previous one of low values.

LRSN

Displays the log record sequence number. An internal number used by CA Datacom/DB in support of the logging features. Incremented by one as log records are added, can restart at 1, based upon internal DB requirements. This field is provided to assist CA Support, should the need arise. The number is printed in hexadecimal.

LBSN

Displays the log block sequence number. An internal number used by CA Support of the logging features. Incremented by one as log blocks are used. Can start at many numbers and can restart as required internally by CA Datacom/DB. This field is provided to assist CA Support, should the need arise. The number is printed in hexadecimal.

TASK

Displays the number of the task area which was used when this log record was generated.

STATUS

Displays the status of log record. Can contain one or more letters. A blank ends the status. The possible letters are:

• A - Specifies that the transaction was aborted and is to roll back.
• B - Specifies that this record is subject to transaction backout.
• C - Specifies a log record subject to Change Data Capture.
• F - Specifies that the first log record after transaction was force spilled.
• M - Specifies an update command caused the record to move.
• T - Specifies a log record that is part of a transaction that has at least one record subject to Change Data Capture.
• U - Specifies that this request was rolled back.
• V - Specifies a virtual table.
• 1 - Specifies the first logged record for this transaction.
• X - Specifies this log record is part of an ADDIT/DELET set, done in support of a partitioned table update that changed the partition in which the row is stored.

These letters may be in any order. They are present only when required/desired to support the CA Datacom/DB facilities. They are provided for CA Support and are not always present even though the description would indicate that it should be present.

RECL

Displays the size of the log record. It is printed in hexadecimal. This field is provided to assist CA Support, should the need arise.

DATA

Displays the size of the log data in this log block. It is printed in hexadecimal. This field is provided to assist CA Support, should the need arise.