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*