Previous Topic: Subschema Display Report Fields (Full Format)Next Topic: Audit Report


Subschema Display Report Fields (Sparse Format)

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

Display type and program name.

RECORD IDENT—Record name.

Record ID.

DATABASE KEY—Database key of the record.

RUN UNIT—Run unit numeric ID.

Starting date/time of the run unit.

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

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

Image Type—Image types affected by DML VERB: AFTER-ONLY; BEFORE-AFTER; BEFORE-ONLY.

PREFIX—The first 64 pointers are processed, and only those that were modified are displayed. The following information is formatted for each pointer: the position (relative to 1); Owner or member relationship; set name; pointer type (NEXT, PRIOR, OWNER); and the before and after values of the database key.

DATA—Only those fields which were modified are displayed. All pertinent group level fields are included for completeness. The following information is formatted for each field: COBOL level number; field name; before/after field values (for elementary items) converted to printable characters.

The following example shows the Subschema Display (Full Format):

ID RELEASE CA IDMS JOURNAL ANALYZER DATE TIME PAGE Rnn.nn PROGRAM DISPLAY mm/dd/yy hh:mm:ss 2 IDMSDDDL *--------------------IDENTIFICATION-----------------------* *------------BEFORE------------* *-----------AFTER-----------* **RECORD IDENT: SR-036 SR0036 SEQ # = 621,261 SEQ # = 621,262 DATABASE KEY: 60,196:0025 RUN UNIT : 1,706 mm/dd/yy hh:mm:ss DML VERB : MODIFY RECORD BEFORE-AFTER PREFIX 1 MEMBER IN CALC NEXT 60,196:0026 60,196:0026 2 MEMBER IN CALC PRIOR 60,196:0024 60,196:0024 3 OWNER OF SR-USERRCD NEXT 60,196:0025 60,196:0025 4 OWNER OF SR-USERRCD PRIOR 60,196:0025 60,196:0025 5 OWNER OF SR-EXPL NEXT 60,196:0025 60,196:0025 6 OWNER OF SR-EXPL PRIOR 60,196:0025 60,196:0025 7 OWNER OF SR-IMPL NEXT 60,196:0025 60,196:0025 8 OWNER OF SR-IMPL PRIOR 60,196:0025 60,196:0025 9 OWNER OF SR-RCDATTR NEXT 60,196:0025 60,196:0025 10 OWNER OF SR-RCDATTR PRIOR 60,196:0025 60,196:0025 11 OWNER OF SR-RCDCMT NEXT 60,196:0025 60,196:0025 12 OWNER OF SR-RCDCMT PRIOR 60,196:0025 60,196:0025 13 OWNER OF SR-RCDSYN NEXT 60,196:0026 60,196:0026 14 OWNER OF SR-RCDSYN PRIOR 60,196:0026 60,196:0026 15 OWNER OF SR-SDR NEXT 60,196:0027 60,196:0027 16 OWNER OF SR-SDR PRIOR 60,196:0027 60,196:0027 17 MEMBER IN OOAK-SR NEXT 61,479:0003 61,479:0003 18 MEMBER IN OOAK-SR PRIOR 60,196:0018 60,196:0018 19 VARIABLE FRAGMENT POINTER NEXT 60,196:0025 60,196:0025 DATA 02 SR-NAM-036 MESSAGE-77 MESSAGE-77 02 OCCURS-036 0 0 02 RCD-VERS-036 228 228 02 DLGTH-036 60 60 02 BUILDER-036 D D 02 DESCR-036 02 DATE-LU-036 mm/dd/yy mm/dd/yy 02 RECTYPE-036 02 REC-FORMAT-036 F F 02 ALT-PIC-TYPE-036 0 0 02 DATE-CREATED-036 mm/dd/yy mm/dd/yy 02 PREP-BY-036 FULJO02 FULJO02 02 REV-BY-036 FULJO02 FULJO02 02 ENT-TYPE-036 02 ERR-036 0 0 02 TIME-LU-036 10322213 10524988 02 PUB-ACCESS-FLAG-036 02 FLAG-036 02 USER-COUNT-036 0 0 02 FILLER 02 LOGICAL-RECORD-USE-COUNT-036 0 0 02 FILLER **RECORD IDENT: NAMESYN-083 SR0083 SEQ # = 621,263 DATABASE KEY: 60,196:0028 RUN UNIT : 1,706 mm/dd/yy hh:mm:ss DML VERB : ERASE RECORD ALL BEFORE-ONLY

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

ID RELEASE CA IDMS JOURNAL ANALYZER DATE TIME PAGE Rnn.nn PROGRAM DISPLAY mm/dd/yy hh:mm:ss 2 IDMSDDDL *--------------------IDENTIFICATION-----------------------* *------------BEFORE------------* *-----------AFTER-----------* **RECORD IDENT: SR-036 SR0036 SEQ # = 621,261 SEQ # = 621,262 DATABASE KEY: 60,196:0025 RUN UNIT : 1,706 mm/dd/yy hh:mm:ss DML VERB : MODIFY RECORD BEFORE-AFTER PREFIX *** NO CHANGES *** DATA 02 TIME-LU-036 10322213 10524988 **RECORD IDENT: NAMESYN-083 SR0083 SEQ # = 621,263 DATABASE KEY: 60,196:0028 RUN UNIT : 1,706 mm/dd/yy hh:mm:ss DML VERB : ERASE RECORD ALL BEFORE-ONLY PREFIX 1 MEMBER IN RCDSYN-NAMESYN NEXT 60,196:0026 2 MEMBER IN RCDSYN-NAMESYN PRIOR 60,196:0026 3 MEMBER IN RCDSYN-NAMESYN OWNER 60,196:0026 4 MEMBER IN SDR-NAMESYN NEXT 60,196:0027 5 MEMBER IN SDR-NAMESYN PRIOR 60,196:0027 6 MEMBER IN SDR-NAMESYN OWNER 60,196:0027 7 MEMBER IN ELEMSYN-NAMESYN NEXT 60,196:0024 8 MEMBER IN ELEMSYN-NAMESYN PRIOR 60,196:0022 9 MEMBER IN ELEMSYN-NAMESYN OWNER 60,196:0024 10 OWNER OF NAMESYN-MAPFLD NEXT 60,196:0028 11 OWNER OF NAMESYN-MAPFLD PRIOR 60,196:0028 12 OWNER OF NAMESYN-NAMEDES NEXT 60,196:0028 13 OWNER OF NAMESYN-NAMEDES PRIOR 60,196:0028 14 VARIABLE FRAGMENT POINTER NEXT 60,196:0028 DATA 02 SYN-NAME-083 MESSAGE-77 02 RDF-NAM-083 02 DEPEND-ON-083 02 NAMESYN-FLAG-083 02 FILLER 02 DR-LPOS-083 1 02 BUILDER-083 D 02 FILLER **RECORD IDENT: ELEMSYN-085 SR0085 SEQ # = 621,264 SEQ # = 621,265 DATABASE KEY: 60,196:0024 RUN UNIT : 1,706 mm/dd/yy hh:mm:ss DML VERB : ERASE RECORD ALL BEFORE-AFTER PREFIX 4 OWNER OF ELEMSYN-NAMESYN PRIOR 60,196:0028 60,196:0022 **RECORD IDENT: NAMESYN-083 SR0083 SEQ # = 621,266 SEQ # = 621,267 DATABASE KEY: 60,196:0022 RUN UNIT : 1,706 mm/dd/yy hh:mm:ss DML VERB : ERASE RECORD ALL BEFORE-AFTER