A fix is available
APAR status
Closed as program error.
Error description
This is a PE-FIX APAR for DBSP2.1 APAR PI58475. ORF job fails with error "HPSR3633E A SEQUENCE FIELD IS NOT UNIQUE" when all of the following conditions are met: - DBSP2.1 APAR PI58475 is applied - HSSROPT DD is specified in the ORF job step - Database has compressed segments
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM IMS Database Solution Pack * * V2.1 IMS Online Reorganization Facility * **************************************************************** * PROBLEM DESCRIPTION: Reload can fail with HPSR3633E when * * HSSROPT DD is specified * **************************************************************** * RECOMMENDATION: * **************************************************************** Reload can fail with HPSR3633E when HSSROPT DD is specified.
Problem conclusion
This is a PE-FIX APAR for DBSP2.1 APAR PI58475 (PTF UI36175). After APAR PI58475 (PTF UI36175) is applied, ORF job can fail in the Reorganization phase with the following error: HPSR3633E A SEQUENCE FIELD IS NOT UNIQUE This error occurs when both of the following conditions are met: - HSSROPT DD is specified in the ORF job step - Database has compressed segments This APAR corrects the program to work as expected even when the HSSROPT DD statement is specified in the ORF job step.
Temporary fix
Comments
APAR Information
APAR number
PI59967
Reported component name
IM DB SOLUTION
Reported component ID
5655S7700
Reported release
210
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-03-30
Closed date
2016-04-06
Last modified date
2016-05-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI36807
Modules/Macros
HRFOLEV0 HRFOREO0 HRFOUNL2
Fix information
Fixed component name
IM DB SOLUTION
Fixed component ID
5655S7700
Applicable component levels
R210 PSY UI36807
UP16/04/08 P F604 Ø
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.
[{"Line of Business":{"code":null,"label":null},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCV358","label":"IMS Database Solution Pack"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0"}]
Document Information
Modified date:
23 October 2020