LOAD (Build CXX or Data Area) › LOAD (Build a Data Area) › Example JCL

Example JCL

The following shows the command to load the DEM area in database 001 (writing to DEM001 data set), to estimate the number of keys to sort at 500, to allow no bytes of slack for record growth, to compute no compression stats, and to use the default buffer area. The data being read was created by a backup of the area DEM on tape or disk.

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.

 //jobname    See the previous note and JCL Requirements.
 //       EXEC PGM=DBUTLTY,REGION=2M
 //STEPLIB    See the previous note and JCL Requirements.
 //CXX      DD DSN=cxx.data.set,DISP=SHR           Directory data set
 //BACKDEM  DD DSN=input                           Input data set
 //*
 //* NOTE: The following sort work allocations are not  
 //*       required if your sort package can dynamically
 //*       allocate sort work areas.  Be sure to provide
 //*       sufficient space for all keys to be sorted.  
 //*
 //SORTWK01 DD UNIT=disk,SPACE=(alctyp,(prim,scnd))
 //SORTWK02 DD UNIT=disk,SPACE=(alctyp,(prim,scnd))
 //SORTWK03 DD UNIT=disk,SPACE=(alctyp,(prim,scnd))
 //SYSIN    DD *                                   Command Input
         LOAD  AREA=DEM,DBID=1,FORMAT=BACKUP,CLUSTER=DENSE,
               DDNAME=BACKDEM,LOADDUPS=NO,OPTIMIZE=YES,SORT=500
 /*

Sample Report

Following is a sample report page. For an example report header, see Sample Report Headers.