The Makers of FDR®


FDREPORT Technical Detail

FDREPORT Examples

This section contains some examples to illustrate the wide range of reports that you can produce with FDREPORT. We’ve kept the examples simple in order to demonstrate how easy it is to create your reports with FDREPORT.

As you can see, FDREPORT is a batch-driven process, with text-based reports as output. If you’re looking for a solution that offers graphical reporting, and fronted by a GUI interface, then please take a look at FDRViEWS, which offers “question and answer” reporting that is attractive to experienced and inexperienced users alike.

Example 1: High-Level Qualifier

In this example, we’re reporting on all the datasets with the HLQ of “ABC” across all the current online DASD volumes.

                //REPORT EXEC PGM=FDREPORT,REGION=0M
                //SYSPRINT DD SYSOUT=*
                //SYSIN DD *
                TITLE LINE='ABC DATASETS ON VOLUME '
                XSELECT XDSN=ABC.**
                PRINT ENABLE=ONLINE

                ABC DATASETS ON VOLUME ABC123
                       D/S
DATASET  NAME     VOLSER ORG RECFM BLKSZ LRECL ALLOC FREE %FR
----------------- ------ --- ----- ----- ----- ----- ---- ---
ABC.FINDMAC.LIST  ABC123 PS  FB     3120    80     1    0   0
ABC.JCL.CNTL      ABC123 PO  FB     6160    80     5    2  40

Example 2: VSAM Report

In this example, we are reporting on ICF VSAM clusters on all online volumes whose serial number starts with 'PROD’. A variety of VSAM fields will be reported. All selected clusters will be combined into one report, sorted on cluster name and component name within cluster.

                //REPORT EXEC PGM=FDREPORT,REGION=0M
                //SYSPRINT DD SYSOUT=*
                //SYSIN DD *
                TITLE LINE='VSAM INFO FOR SELECTED CLUSTERS’
                SELECT DSORG=EF,VOL=PROD*
                REPORT FIELD=(CLUSTER,DSN,VOL,RECORDS, INSERTS,DELETES,EXCPS,%CI,%CA,
                BUFSIZE,CISIZE,CICA)
                SORT FIELD=(CLUSTER,DSN)
                PRINT ENABLE=ONLINE,SORTALLOC=YES

                     VSAM INFO FOR SELECTED CLUSTERS
                                 RECORDS
                                 INSERTS
CLUSTER NAME                     DELETES  %CI BUFSI  CI
DATASET NAME             VOLSER    EXCPS  %CA CISIZ  CA
-------------------      ------ --------- --- ------ ---
USER1.KSDS               PROD23       290  10   9216 150
USER1.KSDS.DATA                       340  20   4096
                                       25
                                      267
USER1.KSDS               PROD56         1   0      0  31
USER1.KSDS.INDEX                        0   0   1024
                                        0
                                       20

Example 3: Multi-Volume Datasets

In this example, we’re identifying all datasets that are cataloged to more than one volume. Because of the way that FDREPORT reads the catalogs, the report is naturally sorted by dataset name.

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

   MULTI-VOLUME DATASETS
DATASET NAME    VOLSER CVC
--------------- ------ ---
PROD.MV.FILE    PROD11   2
PROD.MV.FILE    PROD22   2

Example 4: SMS Management Class

In this example, we are reporting on all online SMS-managed datasets whose SMS management class is TSO1.

                //REPORT EXEC PGM=FDREPORT,REGION=0M
                //SYSPRINT DD SYSOUT=*
                //SYSIN DD *
                TITLE LINE='MANAGEMENT CLASS TSO1’
                XSELECT MGMTCLAS=TSO1
                REPORT FIELD=(DSN,VOL,SMSCLASS)
                PRINT ENABLE=ONLINE

                      MANAGEMENT CLASS TSO1
DATASET NAME     VOLSER STORCLAS DATACLAS MGMTCLAS
---------------- ------ -------- -------- --------
USER1.TEST.JCL   SMS002 TEST              TSO1
USER3.ISPF.PROF  TSO123 TSO      PROFILE  TSO1

Example 5: SMS Storage Group

In this example, we are reporting on all datasets in two specific SMS storage groups. For PDS (PO) and PDSE (POE) datasets, member counts are displayed.

                //REPORT EXEC PGM=FDREPORT,REGION=0M
                //SYSPRINT DD SYSOUT=*
                //SYSIN DD *
                TITLE LINE='SMS STORAGE GROUPS PROD AND TEST’
                XSELECT STORGRP=(PROD,TEST)
                SORT FIELD=(STORGRP,DSN)
                REPORT FIELD=(SPLDSN,STORGRP,VOL,DSORG,LRDATE,SIZE,MEMBERS)
                PRINT SORTALLOC=YES

              SMS STORAGE GROUPS PROD AND TEST
                                 D/S
DATASET NAME     STORGRP  VOLSER ORG LRDATE   ALLOC MEMBER
---------------- -------- ------ --- -------- ----- ------
PAYROLL.MASTER   PROD     PROD02 PS  1996.305   750      0
PROD.CARD.CNTL   PROD     PROD12 POE 1996.301    30     27

Example 6: Disabled VTOC Indexes

In this example, we are reporting on volumes which have an Indexed VTOC (VTOCIX) which has been disabled. A status of YES indicates that the VTOCIX exists but is not active.

                //REPORT EXEC PGM=FDREPORT,REGION=0M
                //SYSPRINT DD SYSOUT=*
                //SYSIN DD *
                TITLE LINE='DISABLED VTOC INDEXES’
                XSELECT VLINDSTA=YES
                REPORT FIELD=(VLVOLSER,VLINDSTA)
                PRINT ENABLE=ONLINE,DATATYPE=VOLDATA

DISABLED  VTOC INDEXES
VOLSER   VTOCIX
------   ------
TSO123   YES
DBLRG1   YES

return to top