A fix is available
APAR status
Closed as new function.
Error description
This APAR provides a new control statement SORTHIDAM for HP Load and the IPR Reload utility to sort HIDAM records before loading.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM IMS High Performance Load * * for z/OS Version 2 Release 1 (FMID=H1IM210) * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides a new control * * control statement to sort unload * * records before loading to HIDAM. * **************************************************************** * RECOMMENDATION: Apply the maintenance for this APAR. * **************************************************************** This APAR provides a new control SORTHIDAM control statement to sort unload records before loading to HIDAM. SORTHIDAM=YES can be specified in : - HP Load utility - IPR Reload utility - IPR Reload task under IPR Driver
Problem conclusion
Temporary fix
Comments
======================== = Documentation Change = ======================== IMS High Performance Load for z/OS Version 2 Release 1 User's Guide SC18-9222-03 ( SC18922203 ) should be changed as follows: ================================================================ 2.0 IMS High Performance Load 2.2.2 JCL requirements SORTWKnn DD These are intermediate storage data sets used by DFSORT. If SORT=YES or SORTHIDAM=YES is specified, you can define these data sets and adjust the size of work space that is used for the sort process. You can specify multiple data sets, 'nn' showing its serial number. This specification is optional | If you do not specify the SORTWKnn DD statements, | these data sets are dynamically allocated by DFSORT. | For a (P)HDAM database, the size is estimated on the basis of | the size of RAA. For a HIDAM database, the size is estimated | on the basis of the primary allocation size of the primary | data set group of the HIDAM database. If the number of | unloaded records is provided by the RECNUM statement, this | value supersedes other values and will be used for estimation. If the estimated size is extremely large or extremely small, specify SORTWKnn DD explicitly. For more information on how to code SORTWKnn DD statements, see DFSORT Application Programming Guide. : ---------------------------------------------------------------- 2.2.3 Control statements 2.2.3.2 Overview of IMS High Performance Load control statements RECNUM and SORTHIDAM are added. +-------------------------------------------------------------+ | Table 3. IMS High Performance Load control statements | | for process control | +------------+------------+-----------+-----------------------+ | Keyword | Accepted | Default | Description | | | values | | | +------------+----------- +-----------+-----------------------+ || RECNUM= | nnnnnnnnnn | (none) | Specifies the number | || | | |of unload records that | || | | |is to be reloaded. | +------------+----------- +-----------+-----------------------+ | SORT= | YES or NO | NO | Specifies whether to | | | | |run physical sequential| | | | |sort before loading | || | | |with (P)HDAM. | +------------+------------+-----------+-----------------------+ || SORTHIDAM= | YES or NO | NO | Specifies whether to | || | | |run the root key | || | | |sequential sort process| || | | |before loading HIDAM. | +------------+------------+-----------+-----------------------+ ---------------------------------------------------------------- |2.2.3.a1 RECNUM control statement | | Specifies the number of unloaded records to be reloaded. | It helps to optimize the DFSORT main storage and | the allocation of the intermediate storage data sets. | | This control statement is optional. | You can use this control statement only when you specify | SORT=YES/COND or SORTHIDAM=YES. | ____________________________________________________________ | | | | | | | | >>__RECNUM=__nnnnnnnnnn________________________________>< | | | | | |___________________________________________________________| | | nnnnnnnnnn : Specifies a left-justified decimal number | from 1 to 9,999,999,999. | This control statement does not have a default. ---------------------------------------------------------------- | 2.2.3.a2 SORTHIDAM control statement | | Specifies whether to run the sort processing before loading | a HIDAM. | Note: This control statement is not appicable to a PHIDAM. | | The HIDAM unloaded data must be in the order of root keys. | If it is not in that order because the root keys are changed | after unloading, you must specify SORTHIDAM=YES. | This control statement is optional. If you do not explicitly | specify this control statement, SORTHIDAM=NO is used. | | __________________________________________________________ | | | | | _NO___ | | | >>__SORTHIDAM=__|_YES__|______________________________>< | | | | | |__________________________________________________________| | | NO | Does not run the sort process for HIDAM. | YES | Runs the key sequential sort process before the reload | process. The sort is done in the order of the root keys. | | Restrictions: | - This control statement cannot be used for the Load API. | - This control statement is used exclusively with the | USERHDR= and the USERHDRX= control statements. | - The key value that is sorted by SORTHIDAM=YES cannot be | changed by the user exit routine that is specified | in the reload step. | - Compressed root keys cannot be sorted. | Specify DECOMPRESS=YES in the IMS High Performance Unload | utility to expand the compressed keys. | - HPSRSVX2 exit cannot run with SORTHIDAM=YES. | | Note: | DFSORT allocates intermediate storage data sets dynamically | for the sort process with sizes estimated on the basis | of the primary allocation size of DBDS. If you specify | the number of unloaded record in the RECNUM control | statement, this value supersedes other values and will | be used for estimation. If you need to adjust the size, | specify the SORTWKnn DD statements explicitly. ---------------------------------------------------------------- 4.0 Load API 4.1.3 Restrictions The following are the restrictions of the Load API function: : - The specification of USERHDR= and USERHDRX are ignored. | - You cannot specify SORTHIDAM=YES. : ---------------------------------------------------------------- APPENDIX1.3.3.1 IMS High Performance Load messages HPSR0100W "keyword" IS NOT APPLIED TO dbtype DB. SPECIFICATION IGNORED RAAFORMAT= SEARCH= FRSPC= RAPCHAIN= DBRECDIST= SORT= | SORTHIDAM= Explanation: keyword is not applied to the database to be reloaded, because the database organization of the database is dbtype . This parameter specification is ignored for this run. System Action: Processing continues; the parameter specification is ignored. Programmer Response: Correct the control statement in error, and rerun the job, if necessary. Problem Determination: Check the control statement and the database organization of the database to be reloaded. ---------------------------------------------------------------- | HPSR0125E SORTHIDAM=YES IS NOT APPLICABLE FOR dbtype DB | | Explanation: SORTHIDAM=YES is not applicable for the database | organization. | System Action: Processing stops. | Programmer Response: Correct the error and rerun the job. | Problem Determination: Check the control statement and | the database organization of the database that is to be | reloaded. ---------------------------------------------------------------- | HPSR0126E SORTHIDAM=YES CANNOT BE SPECIFIED FOR LOAD API | | Explanation: SORTHIDAM=YES is specified for the Load API. | However, the statement is not applicable for the Load API. | System Action: Processing stops. | Programmer Response: Correct the error and rerun the job. | Problem Determination: None. ---------------------------------------------------------------- | HPSR0127E USERHDR=, USERHDRX=, AND SORTHIDAM=YES KEYWORDS ARE | MUTUALLY EXCLUSIVE | | Explanation: All USERHDR, USERHDRX, and SORTHIDAM=YES keywords | are specified in the FRRIN or the HPSIN data set, | but these keywords are mutually exclusive. | System Action: Processing stops. | Programmer Response: Correct the error and rerun the job. | Problem Determination: None. ---------------------------------------------------------------- | HPSR0128E RECNUM IS NOT APPLICABLE, BECAUSE SORT PROCESS IS | NOT IN EFFECT | | Explanation: RECNUM is not applicable, because neither | SORT=YES nor SORTHIDAM=YES is specified. | System Action: Processing stops. | Programmer Response: Correct the control statement, and rerun | the job. | Problem Determination: None. ---------------------------------------------------------------- | HPSR3646E SORT CANNOT BE PROCESSD DUE TO COMPRESSED ROOT KEY | | Explanation: IMS High Performance Load cannot sort the unload | data, of which root key field is compressed. | System Action: IMS High Performance Load issues a user | 3646 abend and a dump. | Programmer Response: Specify DECOMPRESS=YES in the IMS High | Performance Unload utility to expand the compressed keys. | Problem Determination: None. ---------------------------------------------------------------- | HPSR3647E THE SIZE OF SORTWK CANNOT BE ESTIMATED, BECAUSE | THE BLKSIZE OF DBDS IS ZERO. | | Explanation: The size of intermediate storage data sets used | by DFSORT cannot be estimated, because the BLKSIZE of | the DBDS is zero. | System Action: IMS High Performance Load issues a user 3647 | abend and a dump. | Programmer Response: Correct the error and rerun the job. | Problem Determination: None. ---------------------------------------------------------------- | HPSR3648E HPSRSVX2 EXIT CANNOT RUN WITH SORTHIDAM=YES | | Explanation: The HPSRSVX2 exit cannot run with SORTHIDAM=YES. | System Action: IMS High Performance Load issues a user 3648 | abend and a dump. | Programmer Response: Correct the error and rerun the job. | Problem Determination: None. ---------------------------------------------------------------- ====================== END OF DOC-CHANGE ======================
APAR Information
APAR number
PK75509
Reported component name
IMS HIGH PERF L
Reported component ID
5655E0700
Reported release
210
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-11-12
Closed date
2008-11-28
Last modified date
2009-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK42008
Modules/Macros
HPSCIOIN HPSCIVSA HPSRCILA HPSRCILE HPSRCIL7 HPSRCIL8 HPSRCIL9 HPSRDSCT HPSRE15A HPSRFCA0 HPSRHALA HPSRHALM HPSRHAL7 HPSRHAL8 HPSRHAL9 HPSRHDBA HPSRHDBD HPSRHDB7 HPSRHDB8 HPSRHDB9 HPSRHDLA HPSRHDLD HPSRHDL7 HPSRHDL8 HPSRHDL9 HPSRHIDA HPSRHIDM HPSRHID7 HPSRHID8 HPSRHID9 HPSRHTBL HPSRIOIN HPSRIVSA HPSRMSGT HPSRPDBA HPSRPDBD HPSRPDB7 HPSRPDB8 HPSRPDB9 HPSRRLDA HPSRRLDM HPSRRLD7 HPSRRLD8 HPSRRLD9 HPSRRRIN HPSRRRI0 HPSRRRI9 HPSRRXRT HPSRSHDR HPSRSRT0 HPSRSTMT HPSRVCAT HPSRVSAM
| SC18922203 |
Fix information
Fixed component name
IMS HIGH PERF L
Fixed component ID
5655E0700
Applicable component levels
R210 PSY UK42008
UP08/12/02 P F812
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":"BU048","label":"IBM Software"},"Product":{"code":"SSCX89F","label":"IMS HP Load"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 January 2009