IDMSRPTS

The IDMSRPTS data dictionary reports utility reports on information stored in a data dictionary. The utility is a useful tool for database administrators, application programmers, operations personnel, and managers. IDMSRPTS generates reports in four categories.

Non-database reports

Non-database reports provide information on occurrences of data dictionary entities that are not related to database processing.

You do not need to specify a schema, subschema, DMCL, database name table, or segment to get these reports.

Full Report Name	Syntax Name	Description
Global Report Listing	GLBLRPT	Produces all non-database reports
Module/Process/Table Description Listings	MODLST	Produces all module, process, and table reports
Module Description Listing	MODULE	Reports on modules in the dictionary
ADS Process Description Listing	PROCESS	Reports on processes
Protocol Listing	PRTLST	Reports on protocols defined in the data dictionary
Record Copy Description Listing	RECCOPY	Reports on IDD-built records, reports, and transactions
OLQ Qfile Description Listing	QFILE	Reports on q-files defined in the data dictionary
Table Description Listing	TABLE	Reports on edit and code tables
User Listing	USER	Reports on users defined in the data dictionary

Schema Reports

Schema reports provide information on specified schemas defined in the data dictionary.

Full Report Name	Syntax Name	Description
Schema Report Listing	SCHRPT	Produces all schema reports
Area Listing	AREALST	Reports on areas defined in a specified schema
Program Cross-Reference Listing	PGMLST	Reports on subschemas compiled under a specified schema
Schema Record Description Listing	RECDES	Reports on record types defined in a specified schema
Schema Set Description Listing	SETDES	Reports on sets defined in a specified schema

Subschema reports

Subschema reports provide information on specified subschemas defined in the data dictionary.

Full Report Name	Syntax Name	Description
Subschema Report Listing	SSCRPT	Produces all subschema reports
Subschema Data Directory Listing	DATDIR	Provides general information on record types copied into a specified subschema
Logical Record Activity Descriptions	LRACT	Reports on program activity for logical records defined in a specified subschema
Subschema Logical Record Descriptions	LRDEFS	Reports on logical records defined in a specified subschema
Logical Record Path Descriptions	LRPATH	Reports on the paths defined for logical records in a specified subschema
Subschema Area Description Listing	SUBAREA	Reports on areas copied into a specified subschema
Subschema Record Description Listing	SUBREC	Provides comprehensive information on records copied into a specified subschema
Subschema Set Description Listing	SUBSET	Reports on sets copied into a specified subschema

Physical Database Definition reports

Physical database definition reports provide information on specified DMCLs, SEGMENTS, and DBTABLES defined in the dictionary.

Full Report Name	Syntax Name	Description
Physical Database Report Listing	PDBRPT	Produces all physical database definition reports
DBTABLE Listing	DBTLST	Reports on the database names defined in the specified database names table
DMCL Listing	DMCLST	Reports on files, segments, and areas defined in the specified DMCL
Segment Listing	SEGLST	Reports on files, areas, and symbolics defined in the specified segment

Authorization

Physical database definition reports

To	You Need This Privilege or Authority
Run DMCLST report	DBADMIN on the dictionary being processed or DISPLAY on each DMCL on which you want to report
Run SEGLST reports	DBADMIN on the dictionary being processed or DISPLAY on each segment on which you want to report
DBTLST	DBADMIN on the dictionary being processed or DISPLAY on each DBTABLE on which you want to report

Non-database, schema, and subschema reports

To	You Need This Privilege	On
Run any reports except physical database definition reports	SIGNON authority	Dictionary being processed if SECURITY FOR IDD SIGNON IS ON
Run all global reports except physical database definition reports	DISPLAY or higher	Basic entity type on which you want to report if SECURITY FOR IDD SIGNON IS ON
Run schema and subschema reports	DISPLAY or higher	Database entity on which you want to report if SECURITY FOR IDMS IS ON
Run all reports except User Listing and physical database definition reports	DISPLAY or higher	Entity occurrence on which you want to report if the PUBLIC ACCESS IS NONE