System Output › Audit Report › Record Display Report Fields (Full Format) › Record Display Report Fields (Sparse Format)

Record Display Report Fields (Sparse Format)

The following is a description of the various fields that make up the Record Display (Sparse Format).

Display type, record ID, and record name.

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 and database key.

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

PREFIX CHANGES—Only pointers which were modified are displayed. The pointer position, relative to 1, appears to the left of the database key. If none of the pointers were modified, *** NONE *** appears.

DATA—Four display lines present the character/hexadecimal representation of each record position whose value has changed. Only those positions that have changed are displayed. 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 fourth line numbers character positions within the record. If a record position has been deleted (shortening of a variable-length record), a "D" appears on the ZONE line at the corresponding record position. If the data portion was not changed, *** NONE *** appears in place of the four display lines.

Note: The data portion of a database record will be decompressed if it can be uniquely determined that the record type is compressed by the IDMSCOMP program. NONUNIQ=Y may be required on the PROCESS parameter card.

The following example shows the Record Display (Sparse Format):

 ID                   RELEASE                         CA IDMS JOURNAL ANALYZER                 DATE             TIME         PAGE
                      Rnn.nn                               RECORD DISPLAY                    mm/dd/yy         hh:mm:ss          2
                                                SR0036 SR-036

 **    mm/dd/yy    RU =     1,706    PREFIX LEN =    76          IDMSDDDL             60,086:0010
       hh:mm:ss    BFOR              DATA   LEN =   188        MODIFY RECORD        SEQ # =                  621,934

   PREFIX CHANGES     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      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......

             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             60,086:0010
       hh:mm:ss    AFTR              DATA   LEN =   188        MODIFY RECORD        SEQ # =                  621,935

   PREFIX CHANGES  *** NONE ***

   DATA      CHAR                                          5 5245
             ZONE                                          F FFFF
             NUMR                                          5 5245
                 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                  60,086:0010
      hh:mm:ss     BFOR               DATA   LEN =   108       ERASE RECORD ALL          SEQ # =             621,952

   PREFIX CHANGES  *** NONE ***

 **   mm/dd yy     RU =      1,706    PREFIX LEN =    76         IDMSDDDL                  60,086:0010
      hh:mm:ss     AFTR               DATA   LEN =   108       ERASE RECORD ALL          SEQ # =             621,953

   PREFIX CHANGES    15        60,086:0010  16        60,086:0010

 **   mm/dd yy     RU =      1,706    PREFIX LEN =    76         IDMSDDL                   60,086:0010
      hh:mm:ss     BFOR               DATA   LEN =   108       STORE RECORD              SEQ # =             621,956

   PREFIX CHANGES *** NONE ***

 **   mm/dd yy     RU =      1,706    PREFIX LEN =    76         IDMSDDDL                  60,086:0010
      hh:mm:ss     AFTR               DATA   LEN =   108       STORE RECORD              SEQ # =             621,958

   PREFIX CHANGES    15        60,086:0012  16        60,086:0012

 **   mm/dd yy     RU =      1,706    PREFIX LEN =    76         IDMSDDL                   60,086:0010
      hh:mm:ss     BFOR               DATA   LEN =   188       MODIFY RECORD             SEQ # =             621,968