A fix is available
APAR status
Closed as new function.
Error description
Support work files generated by IMS High Performance Load for PSINDEX.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of IMS Index Builder for z/OS, * * Version 3 Release 1 (FMID=H22O310) * **************************************************************** * PROBLEM DESCRIPTION: This APAR enables Index Builder to * * support work files generated by * * IMS High Performance Load * * (FMID=H1IM210) for PSINDEX. * **************************************************************** * RECOMMENDATION: * **************************************************************** This APAR fixes the problems listed in the Problem Description field.
Problem conclusion
Temporary fix
Comments
For the details of this new feature, see the documentation change. To generate WFP files, IMS High Performance Load for z/OS, Version 2 Release 1 (FMID=H1IM210) with APAR PM62216 is required. ======================== = Documentation Change = ======================== IBM IMS Index Builder for z/OS, V3R1, User's Guide (SC18-9101-03) should be changed as follows: ================================================================ 2.1 IMS Index Builder functions 2.1.1 Creating secondary indexes | 2.1.3.2 Building partitioned secondary indexes using HPSRWFP | as input | | You can use IMS Index Builder to build partitioned secondary | indexes (PSINDEX) using the output from IMS High Performance | Load as input. This feature is provided to improve performance | by eliminating scanning whole the target HALDB in the Index | Builder job step. | | About this task | When building PSINDEX, IMS Index Builder reads in data from | the WFP files generated by IMS High Performance Load. | | Procedure | To build partitioned secondary indexes by using HPSRWFP as | input, define the JCL using the following figure as an | example: |//************************************************************ |//* BUILD PSINDEX USING HPSRWFP FILE * |//************************************************************ |//IDXBUILD EXEC PGM=IIUSTART |//STEPLIB DD DISP=SHR,DSN=&SIIULMOD <--Index Builder library |// DD DISP=SHR,DSN=&RESLIB <--IMS RESLIB |//DFSRESLB 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 |/* | |Notes: | 1. The WFP files must be generated for all partitions of | the target HALDB by IMS High Performance Load in advance. | 2. The DD statements for the WFP files are not needed. | The data sets will be allocated dynamically. | 3. The 'WFPDEL YES' statement is optional to delete the WFP | files after loading indexes successfully. | 4. The 'MAXTASKS 2,PSORT' statement is optional to improve | performance of the index sort. ================================================================ 2.2 JCL and input control statements 2.2.2 IMS Index Builder input control statements 2.2.2.1 Required control statements 2.2.2.1.2 INPUT control statement The INPUT control statement specifies the type of input that is used by IMS Index Builder to build indexes. The following diagram shows the format of the INPUT statement. _________________________________________________________ | _IBSCAN___ | | >>__INPUT__|__________|__ _________________ _________>< | | |_DFSURWF1_| |_,DBRC=(_ _Y_ _)_| | | |_HPSRSIDX_| |_N_| | | |_DFSURIDX_| | | | |_HPSRWFP__| | |_________________________________________________________| | HPSRWFP | Specifies that data generated by IMS High Performance Load | is used as input for building partitioned secondary indexes | (PSINDEX). | If you specify HPSRWFP, you must also specify the PROC | BLD_SECONDARY statement and the WFPHLQ control statement. ================================================================ 2.2.2.2 Optional control statements | 2.2.2.2.a WFPDEL control statement | | The WFPDEL control statement specifies whether IMS Index | Builder deletes the HPSWFP data sets after loading indexes. | | This statement is effective when the INPUT HPSRWFP statement | is specified. | ________________________________________________________ | | _NO ____ | | | >>__WFPDEL___|_YES ___|__________________________>< | | | |_FORCE _| | | |________________________________________________________| | | WFPDEL | Specifies that this is a WFPDEL statement. | | NO | Specifies that IMS Index Builder does not delete the | WFP data sets. | | YES | Specifies that IMS Index Builder deletes the WFP data sets | after indexes are built successfully. | | FORCE | Specifies that IMS Index Builder deletes the WFP data sets | whether indexes are built successfully or not. | | If the WFPDEL statement is not specified, NO is used as | default. | | Note: You can override the default value in the runtime | parameters module. See the explanation of the IIURDFLT WFPDEL | entry in "Defining runtime parameters". ---------------------------------------------------------------- | 2.2.2.2.b WFPHLQ control statement | | The WFPHLQ control statement specifies a high level qualifier | of the WFP data sets generated by IMS High Performance Load. | | This control statement is required when the INPUT HPSRWFP | statement is specified. | __________________________________________________________ | | | | | >>__WFPHLQ__hlq ________________________________>< | | |__________________________________________________________| | | WFPHLQ | Specifies that this is a WFPHLQ statement. | | hlq | Specifies a high-level qualifier of the WFP data sets for | input. The maximum length is 32 characters. | | The data set 'hlq.partname.WFP' for each HALDB partition | must be generated by IMS High Performance Load in advance. | Index Builder allocates each data set dynamically. | | Note: You can override the default value in the runtime | parameters module. See the explanation of the IIURDFLT WFPHLQ | entry in "Defining runtime parameters". ================================================================ 2.4 Defining runtime parameters *************************************************************** IIURPRMS CSECT IIURPRMS RMODE 31 DC CL52'IIURPRMS' module start * alternate sort procedure name * DC CL52'IIURSORT IIUBSRT ' * run time default parameters * DC CL52'IIURDFLT VIC YES,IIU.UIC.UDATA' |* DC CL52'IIURDFLT WFPDEL YES' |* DC CL52'IIURDFLT WFPHLQ IMSTOOLS.WFPFILE0' END IIURPRMS Figure 21. Example of an IMS Index Builder runtime parameters module (Part 2 of 2) ================================================================ 3.3 IMS Index Builder reason codes 3.3.2 IMS Index Builder initialization phase primary reason cod ---------------------------------------------------------------- | 114 UNABLE TO ALLOCATE HPSRWFP DATA SET | Explanation: Allocating a HPSRWFP data set failed. | User Response: See the explanation of the IIUB062I message. ---------------------------------------------------------------- | 123 UNABLE TO OPEN HPSRWFP DATA SET | Explanation: Opening a HPSRWFP data set failed. | User Response: Check the data set was generated correctly. ---------------------------------------------------------------- | 127 HPSRWFP DATA SET PROCESS FAILURE | Explanation: Reading a HPSRWFP data set failed. | User Response: Check the data set was generated correctly. ================================================================ 3.3.4 IMS Index Builder control flow event codes ---------------------------------------------------------------- | 640 HPSRWFP MAS READER ACTIVATED | Explanation: Scan object of above type is up. | User Response: None ================================================================ 3.3.5 IMS Index Builder processing phase failure reason codes ---------------------------------------------------------------- | 777 UNABLE TO ALLOCATE HPSRWFP DATA SET | Explanation: Allocating a HPSRWFP data set failed. | User Response: See the explanation of the IIUB062I message. ---------------------------------------------------------------- | 778 UNABLE TO OPEN HPSRWFP DATA SET | Explanation: Opening a HPSRWFP data set failed. | User Response: Check the data set was generated correctly. ---------------------------------------------------------------- | 779 HPSRWFP DATA SET PROCESS FAILURE | Explanation: Reading a HPSRWFP data set failed. | User Response: Check the data set was generated correctly. ---------------------------------------------------------------- | 786: HPSRWFP READER TASK FAILURE | Explanation: A task for reading HPSRWFP files failed. | User Response: See the prior message. ================================================================ 3.4 IMS Index Builder messages ---------------------------------------------------------------- | IIUB083E HPSRWFP FILE IS NOT FOUND | Explanation: No HPSWFP file is found. | System action: Processing stops. | User response: Make sure whether the HPSRWFP data sets was | generated correctly by IMS High Performance Load. ---------------------------------------------------------------- | IIUB084I HPSRWFP FILE IS NOT FOUND: PART=xxxxxxxx | Explanation: A HPSWFP file is not found for the indicated | HALDB partition. | System action: Processing continues. | User response: If this partition is empty and it is not | processed by IMS High Performance Load, there is no problem. | If not, run the job of IMS High Performance Load again to | generate HPSRWFP data sets correctly. ---------------------------------------------------------------- | IIUB085E INCORRECT HPSRWFP FILE: RSN=xx PART=yyyyyyy | PSINDEX=zzzzzzzz | Explanation: The HPSWFP file is not correct. xx shows one of | the following reason codes: | 01: The partition's data set name is not found in RECON | 02: The partition's reorganization number is not found | in RECON | 03: The records for the indicated PSINDEX are missing | 04: The header record is incorrect | 05: The HPSPWFP format level is unrecognized | System action: Processing stops. | User response: Make sure whether the HPSRWFP data sets are | generated correctly by IMS High Performance Load. ---------------------------------------------------------------- | IIUB086E 'INPUT' STATEMENT OPTION HPSRWFP IS NOT APPLICABLE | FOR NON-HALDB | Explanation: The 'INPUT HPSRWFP' statement is specified. | However, the database specified on the PROC statement is not | a HALDB. | System Action: Processing stops. | User Response: Correct the error and rerun the job. ---------------------------------------------------------------- | IIUB087E 'ILDS INITONLY' IS REQUIRED FOR HPSRWFP INPUT | Explanation: The 'ILDS INITONLY' statement is required for | the 'PROC BLD_ILDS' statement or the 'PROC BLD_ALL' statement | when the 'INPUT HPSRWFP' statement is specified. | System Action: Processing stops. | User Response: Correct the error and rerun the job. ---------------------------------------------------------------- | IIUB088E 'WFPHLQ' IS REQUIRED FOR HPSRWFP INPUT | Explanation: The 'INPUT HPSRWFP' statement is specified, but | the WFPHLQ statement is not specified. | System Action: Processing stops. | User Response: Correct the error and rerun the job. ================= End of Documentation Change ==================
APAR Information
APAR number
PM64823
Reported component name
IMS INDEX BUILD
Reported component ID
5655E2400
Reported release
310
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2012-05-16
Closed date
2012-07-12
Last modified date
2012-08-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK80269
Modules/Macros
H22O310J IIUBDBD IIUBIBCD IIUBINIT IIUBMSGS IIUBSTMS IIUDPLNR IIUDRVRX IIUDYN00 IIUDYN10 IIUIFS2A IIUIFS2B IIUIFS22 IIUIFS29 IIUMMSGR IIUSCA31 IIUSCB31 IIUSIBCD IIUSMP10 IIUSTART IIUTXT00
| SC18910103 |
Fix information
Fixed component name
IMS INDEX BUILD
Fixed component ID
5655E2400
Applicable component levels
R310 PSY UK80269
UP12/07/14 P F207
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCX89M","label":"IMS Index Builder"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
09 August 2012