DBTEST (Execute Test/Analysis Programs) › DBTEST DBIDPPR (Index Population Analysis Program) › Example DBIDPPR JCL

Example DBIDPPR JCL

This example produces an Index Population Analysis for table PMF in database 1.

Note: Use the following as a guide to prepare your JCL. The JCL statements are for example only. Lowercase letters in a statement indicate a value you must supply. Code all statements to your site and installation standards.

 * $$ JOB ...           See the previous note and JCL Requirements.
 * $$ LST ...
 // JOB name
 // EXEC PROC=procname  Whether you use PROCs or LIBDEFs, see JCL Requirements.
 // ASSGN SYSnnn,device type,VOL=volser,SHR
 // DLBL CXX,'cxx',,DA                             Directory data set
 // EXTENT SYSnnn,volser
 // DLBL IXX001,'db001.index',,DA                  Index Area for DBID 001
 // EXTENT SYSnnn,volser
 // DLBL PMF001,'db001.pmf',,DA                    Data area PMF in DBID 001
 // EXTENT SYSnnn,volser
 // EXEC DBUTLTY,SIZE=750K
          DBURSTR  MULTUSE=NO
          DBURTBL  DBID=1,TBLNAM=PMF
          DBUREND  SYSTEM=DOS
          DBTEST   PGM=DBIDPPR
 /*
 /&
 * $$ EOJ