System Output › Audit Report › DATABASE KEY Display › DATABASE KEY Display Report Fields (Full Format)

DATABASE KEY Display Report Fields (Full Format)

The following is a description of the various fields which make up the Database Key Display (Full Format).

Display type, page and line of database record.

Starting date/time of the run unit.

RU—Run unit numeric ID.

IMAGE TYPE—Indicates either a before image (BFOR), or an after image (AFTR).

Abort Flag—If run unit (or recovery unit) terminates abnormally, "ABORTED" is displayed following image type.

PREFIX LEN—Length (in bytes) of the prefix portion (pointers) of the database record.

DATA LEN—Length (in bytes) of the data portion of the database record.

Program name, record ID, and record name.

DML VERB—Verb that caused the creation of the before or after image.

PREFIX —All pointers are displayed. The pointer position, relative to 1, appears to the left of the database key. If the pointer was modified, an asterisk (*) appears between the pointer position and the database key.

DATA—Five display lines present the character/hexadecimal representation of each record position and any change flags. The CHGS line flags any data change as "A" (added character), "D" (deleted character), or "*" (modified character). The CHAR line presents the EBCDIC character value of each record position. The ZONE line presents the hex equivalent of the zone bits of each record position. The NUMR line presents the hex equivalent of the numeric bits of each record position. The fifth line numbers the character positions within the record.

The following example shows the DATABASE KEY Display (Full Format):

 ID                   RELEASE                         CA IDMS JOURNAL ANALYZER                 DATE             TIME         PAGE
                      Rnn.nn                            DATABASE KEY DISPLAY                 mm/dd/yy         hh:mm:ss          2
                                                                 60,086:0010

 **    mm/dd/yy    RU =     1,706    PREFIX LEN =    76          IDMSDDDL             SR0036 SR-036
       hh:mm:ss    BFOR              DATA   LEN =   188        MODIFY RECORD               SEQ # =                  621,934

   PREFIX             1       60,086:0011   2        60,086:0009   3        60,086:0010   4     60,086:0010    5        60,086:0010
                      6       60,086:0010   7        60,086:0010   8        60,086:0010   9     60,086:0010   10        60,086:0010
                     11       60,086:0010  12        60,086:0010  13        60,086:0011  14     60,086:0011   15        60,086:0012
                     16       60,086:0012  17        61,948:0012  18        60,945:0023  19     60,086:0010

   DATA      CHGS
             CHAR     LITERAL-100                           U  D                                    mm/dd/yy
             ZONE  0B00DCECDCD6FFF44444444444444444444400000E06C4444444444444444444444444444444444444444FF6FF6FF4444444
             NUMR  0C00393591301000000000000000000000000000040440000000000000000000000000000000000000000101251940000000
                   1...5...10...15...20...25...30...35...40...45...50...55...60...65...70...75...80...85...90...95.....

             CHGS
             CHAR           F  mm/dd/yyFULJO02 FULJO02  010322431
             ZONE  444444444C00FF6FF6FFCEDDDFF4CEDDDFF44FFFFFFFFFF00044000044444444444444444444444444444444
             NUMR  0000000006001011319464316020643160200010322431F00000000000000000000000000000000000000000
                 101...5...10...15...20...25...30...35...40...45...50...55...60...65...70...75...80...85...

 **    mm/dd/yy    RU =     1,706    PREFIX LEN =    76          IDMSDDDL             SR0036 SR-036
       hh:mm:ss    AFTR              DATA   LEN =   188        MODIFY RECORD               SEQ # =                  621,935

   PREFIX             1       60,086:0011   2        60,086:0009   3        60,086:0010   4     60,086:0010    5        60,086:0010
                      6       60,086:0010   7        60,086:0010   8        60,086:0010   9     60,086:0010   10        60,086:0010
                     11       60,086:0010  12        60,086:0010  13        60,086:0011  14     60,086:0011   15        60,086:0012
                     16       60,086:0012  17        61,948:0012  18        60,945:0023  19     60,086:0010

   DATA      CHGS
             CHAR     LITERAL-100                           U  D                                    mm/dd/yy
             ZONE  0B00DCECDCD6FFF44444444444444444444400000E06C4444444444444444444444444444444444444444FF6FF6FF4444444
             NUMR  0C00393591301000000000000000000000000000040440000000000000000000000000000000000000000101251940000000
                   1...5...10...15...20...25...30...35...40...45...50...55...60...65...70...75...80...85...90...95.....

             CHGS                                         *  ****
             CHAR           F  mm/dd/yyFULJO02 FULJO02  010525245
             ZONE  444444444C00FF6FF6FFCEDDDFF4CEDDDFF44FFFFFFFFFF00044000044444444444444444444444444444444
             NUMR  0000000006001011319464316020643160200010525245F00000000000000000000000000000000000000000
                 101...5...10...15...20...25...30...35...40...45...50...55...60...65...70...75...80...85...

 **    mm/dd/yy    RU =     1,706    PREFIX LEN =    76          IDMSDDDL             SR0036 SR-036
       hh:mm:ss    BFOR              DATA   LEN =   108        ERASE RECORD ALL            SEQ # =                  621,952

   PREFIX             1       60,086:0011   2        60,086:0009   3        60,086:0010   4     60,086:0010    5        60,086:0010
                      6       60,086:0010   7        60,086:0010   8        60,086:0010   9     60,086:0010   10        60,086:0010
                     11       60,086:0010  12        60,086:0010  13        60,086:0011  14     60,086:0011   15        60,086:0012
                     16       60,086:0012  17        61,948:0012  18        60,945:0023  19     60,086:0010

 **    mm/dd/yy    RU =     1,706    PREFIX LEN =    76          IDMSDDDL             SR0036 SR-036
       hh:mm:ss    AFTR              DATA   LEN =   108        ERASE RECORD ALL            SEQ # =                  621,953