Standard Dictionary Reports—DREPORTS › Cross-Reference Reports › IDMS Area Activity Report (DREPORT 029)

IDMS Area Activity Report (DREPORT 029)

Contents

The IDMS Area Activity report provides information about how programs use areas. These area/program relationships are defined through the AREA clause of the DDDL PROGRAM statement or through the DML processors if the activity log is on and the dictionary is in UPDATE mode at run time.

Sample DREPORT 029:

 REPORT NO. 29                                   DATA DICTIONARY REPORTER  REL nn.n                       mm/dd/yy        PAGE   1
 DREPORT 029                                          IDMS AREA ACTIVITY REPORT


 *********************************************************************************************************************************
                                                                                                      ---- D A T E ----
 SCHEMA   VER   SUBSCHEMA  AREA                             PROGRAM  VER   ACTIVITY            TIMES  COMPILED  CREATED
 *********************************************************************************************************************************

 EMPSCHM    1   AD99SLR    EMP-DEMO-REGION                  LRDA01D    1   RETRIEVAL                3 mm/dd/yy mm/dd/yy
 EMPSCHM    1   AD99SLR    INS-DEMO-REGION                  LRDA01D    1   RETRIEVAL                3 mm/dd/yy mm/dd/yy
 EMPSCHM    1   AD99SLR    ORG-DEMO-REGION                  LRDA01D    1   RETRIEVAL                3 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    EMP-DEMO-REGION                  LRTD01D    1   RETRIEVAL                2 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    EMP-DEMO-REGION                  LRTD01D    1   UPDATE                   1 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    EMP-DEMO-REGION                  OTFT03D    1   RETRIEVAL                1 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    EMP-DEMO-REGION                  RENO01D    1   OBTAIN                   2 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    EMP-DEMO-REGION                  RENO01D    1   RETRIEVAL                2 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    EMP-DEMO-REGION                  RENO02D    1   OBTAIN                   2 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    EMP-DEMO-REGION                  RENO02D    1   RETRIEVAL                2 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    EMP-DEMO-REGION                  RENO03D    1   OBTAIN                   2 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    EMP-DEMO-REGION                  RENO03D    1   RETRIEVAL                2 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    ORG-DEMO-REGION                  LRTD01D    1   RETRIEVAL                2 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    ORG-DEMO-REGION                  LRTD01D    1   UPDATE                   1 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    ORG-DEMO-REGION                  OTFT03D    1   RETRIEVAL                1 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    ORG-DEMO-REGION                  RENO01D    1   RETRIEVAL                2 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    ORG-DEMO-REGION                  RENO02D    1   RETRIEVAL                2 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR    ORG-DEMO-REGION                  RENO03D    1   RETRIEVAL                2 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR1   EMP-DEMO-REGION                  LRFC01D    1   RETRIEVAL                1 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR1   EMP-DEMO-REGION                  LRFC02D    1   RETRIEVAL                1 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR1   ORG-DEMO-REGION                  LRFC01D    1   RETRIEVAL                1 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSSLR1   ORG-DEMO-REGION                  LRFC02D    1   RETRIEVAL                1 mm/dd/yy mm/dd/yy
 EMPSCHM    1   EMPSS01    EMP-DEMO-REGION                  ADMI01D    1   OBTAIN                   2 mm/dd/yy mm/dd/yy

Field Descriptions

A description of the fields in the sample report follows:

SCHEMA/VER

Identifies the name and version number of the schema that contains the area referenced by the program.

SUBSCHEMA

Identifies the subschema in which the area exists.

AREA

Identifies the area associated with the named program.

PROGRAM/VER

Identifies the name and version number of the program using this area.

ACTIVITY

Identifies the DML command issued against this area by the named program.

TIMES

Indicates the number of times the DML command is issued against the area within the named program.

DATE COMPILED/CREATED

Identifies the date this program was last compiled and the date the program occurrence was defined to the dictionary.