Building partitioned secondary indexes using HPSRWFP as input

You can use IMS™ Index Builder to build partitioned secondary indexes (PSINDEXes) using the output from IMS High Performance Load as input. This feature improves performance by eliminating scanning of the entire target HALDB in the Index Builder job step.

About this task

When building PSINDEXes, IMS Index Builder reads data from the WFP files that were generated by IMS High Performance Load.

Procedure

To build partitioned secondary indexes by using HPSRWFP as input, define the JCL using the following example:

Figure 1. Example JCL for building PSINDEXes using HPSRWFP as input

//IIUBBLD JOB &SYSUID,MSGCLASS=H,  
// RESTART=*,CLASS=A,NOTIFY=&SYSUID  
//*********************************************************************  
//* BUILD PSINDEX USING HPSRWFP FILE                                  *  
//********************************************************************* 
//* Provide values for the following variables:  
// SET   SIIULMOD=  Index Builder load library  
// SET   RESLIB=    IMS RESLIB  
// SET   MDALIB=    IMS MDALIB                     
// SET   DBDLIB=    DBD library  
// SET   DDEFPDS=   IDCAMS commands library   
//* NOTE: The Index Builder load library and all other datasets  
//* concatenated to STEPLIB must be APF authorized.  
//********************************************************************* 
//IDXBUILD EXEC PGM=IIUSTART  
//STEPLIB  DD DISP=SHR,DSN=&SIIULMOD  
//         DD DISP=SHR,DSN=&RESLIB  
//IMS      DD DISP=SHR,DSN=&DBDLIB  
//IMSDALIB DD DISP=SHR,DSN=&MDALIB 
//DDEFPDS  DD DISP=SHR,DSN=&DDEFPDS 
//SYSUDUMP DD SYSOUT=A   
//IIUIN    DD *  
  PROC     BLD_SECONDARY,HMPORDP1,ALL  
  INPUT    HPSRWFP,DBRC=Y  
  WFPHLQ   IMSTOOLS.WORK.HMPORDP1
  WFPDEL   YES
  MAXTASKS 2,PSORT
/*  
//

Tips:

The DD statements for the WFP files are not needed. The data sets are allocated dynamically.
The optional WFPDEL YES statement specifies to delete the WFP files after the indexes are loaded successfully.
The optional MAXTASKS 2,PSORT statement improves the performance of index sort processing.
This example job requires WFP files for all HALDB partitions. If IMS High Performance Load processes some HALDB partitions and generates WFP files only for those partitions, you must add the UPDATE option for the PROC statement as follows:
```
PROC BLD_SECONDARY,HMPORDP1,ALL,UPDATE
```