FDREPORT Catalog Examples

This section shows examples that read the system catalogs. FDREPORT can be directed to gather more information about the cataloged data sets from the VTOCs of the volumes in the catalog (DATATYPE=CATVTOC) or from the Archive Control File (DATATYPE=CATARCH). All examples in this section are found in the JCL library installed with FDR. The member names are EX5442x.

You may also report strictly on the catalog information (DATATYPE=CATALOG) but in this case a limited set of fields are available.

A sample of the generated report is shown after each example; because of space limitations, it may be condensed. In examples where sorting is required, SORTALLOC=YES has been specified to dynamically allocate required SORT files; in your installation you may have to provide SORT JCL.

Identify Multi-Volume data sets example

Identify all data sets that are cataloged to more than one volume. Because of the way that FDREPORT reads the catalogs, the report is naturally sorted by data set name.

//REPORT   EXEC PGM=FDREPORT,REGION=0M
//SYSPRINT DD SYSOUT=*
//ABRMAP   DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN    DD *
 TITLE LINE='MULTI-VOLUME DATA SETS'
 XSELECT CATVOLCT>1
 REPORT FIELDS=(DSN,VOL,CATVOLCT)
 PRINT DATATYPE=CATALOG
/*

The generated report looks like:

MULTI-VOLUME DATA SETS
DATA SET NAME                    VOLSER CVC
-------------                    ------ ---
PROD.MV.FILE                     PROD11   2
PROD.MV.FILE                     PROD22   2

Report recent test data sets example

Report on the size of the non-VSAM data sets that have the character string “TEST” anywhere within their data set name, and that were created within the last two weeks. The data set names are selected from the system catalogs, and then the volumes from the catalog are accessed to get the rest of the information. The tracks allocated, %FREE, data set name, and volume serial are be printed, sorted by size in descending sequence.

//REPORT   EXEC PGM=FDREPORT,REGION=0M
//SYSPRINT DD SYSOUT=*
//ABRMAP   DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN    DD *
 TITLE    LINE='RECENTLY CREATED TEST DATA SETS'
 REPORT   FIELDS=(SIZE,%FREE,DSN,VOL)
 SORT     FIELDS=(SIZE),SEQUENCE=(D)
 XSELECT  XDSN=**TEST**,CRDAYS.LE.14,DSORG.NE.EF,CATALOG=YES
 PRINT    SORTALLOC=YES,DATATYPE=CATVTOC
/*

The generated report looks like:

RECENTLY CREATED TEST DATA SETS
   ALLOC %FR DATA SET NAME                        VOLSER
-------- --- -------------                        ------
     450  95 USER1.TEST.JCL                       TSO001
    295  12 TEST.GL.MASTER1                      TEST12


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*