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).
cdatvse
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 . . .
- Œ
- Log Detail Report Headings
- CMD
- Datacom/DBrecord-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 normally 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 supportDatacom/DBor 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
- Datacom/DBtable 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
- Database ID. Blank for records without database ID's. Printed as a decimal number.
- URI
- Unique Row Indentifier. Blank for records without a URI number. Printed in hexadecimal format. Contains the literal 'NON-URI ' for areas not loaded as URI.
- BLOCK
- Data area block number. Blank for records without a data block. Printed in hexadecimal format.
- L#
- 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
- Transaction Sequence Number. Blank for records not part of a transaction. Printed in hexadecimal format.
- JOB NAME
- Job name.
- R-UNIT
- Run unit number.
- MP
- Blank if not running r10 or later as a MUFplex. Otherwise contains a MUFplex number of which Multi-User Facility logged this log record.
- USER ID
- User ID. First 8 characters of the 32-byte user ID passed on the request.
- AREA
- Data area name containing row.
- MONITOR INFO
- Monitor information, if this request was made through theDatacom CICS Servicesor theDatacom Server.
- INPUT RECORD
- Number of this input log record.
- FPR
- 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
- Date the log record was added. Printed in the form mm/dd/ccyy.
- TIME
- Time the log record was added. Printed in the form HH.MM.SS.
- CLOCK
- Result of a hardware STCK (store clock) instruction at the time the log record was added.
- SEC.USER
- Security user requesting maintenance.
- MOVE TO
- Block number to where an update moved a record. Printed in hexadecimal format.
- LRID
- 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 Broadcom Support, should the need arise. Printed in hexadecimal format.
- PREV
- Previous log record ID. Log records for a transaction are chained in reverse back to a previous one of low values.
- LRSN
- Log record sequence number. An internal number used byDatacom/DBin 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 Broadcom Support, should the need arise. The number is printed in hexadecimal.
- LBSN
- Log block sequence number. An internal number used by Broadcom Support of the logging features. Incremented by one as log blocks are used. Can start at many numbers and can restart as required internally byDatacom/DB. This field is provided to assist C Support, should the need arise. The number is printed in hexadecimal.
- TASK
- Number of the task area which was used when this log record was generated.
- STATUS
- 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 be rolled back.
- B - Specifies that this record is subject to transaction backout.
- F - Specifies that the first log record after transaction was force spilled.
- M - Specifies an update command caused the record to move.
- 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 theDatacom/DBfacilities. They are provided for Broadcom Support and are not always present even though the description would indicate that it should be present.
- RECL
- Size of the log record. It is printed in hexadecimal. This field is provided to assist Broadcom Support, should the need arise.
- DATA
- Size of the log data in this log block. It is printed in hexadecimal. This field is provided to assist Broadcom Support, should the need arise.