A fix is available
APAR status
Closed as program error.
Error description
When unloading a LOB, if the TRIM option is in effect (TRIME YES specified in SYSIN or ULTRIM is set in PARMLIB), an abend 0C4 is obtained with the following traceback: 4 _inzctrlhFindAuxRel +0000017C 2980 INZUTILK 5 _inzctrlhCheckEcsLobParam +0000063A 8292 INZUTILK 6 _inzctrlhCheckEcsCommonPost +00000444 9014 INZUTILK Another symptom can be obtained : return code 8 with the following message : INZU499E ERROR: INFORMATION WAS NOT FOUND IN THE SYSIBM.SYSAUXRELS TABLE FOR THE FOLLOWING LOB COLUMN: COL_LOB. Example of SYSIN : UNLOAD TABLESPACE QUIESCE YES SELECT COL_LOB1 FROM MZLFRD.TBDZAAFRD30601 OUTDDN (FOUT01) TRIM YES OTHER KEYWORDS: PB44652 ABENDS0C4 ABEND0C4 S0C4 0C4 INZU499E MSGINZU499E INZU499 MSGINZU499
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload * **************************************************************** * PROBLEM DESCRIPTION: ABENDS0C4 OR INZU499E * **************************************************************** * RECOMMENDATION: * **************************************************************** When unloading a LOB, if the TRIM option is in effect (TRIME YES specified in SYSIN or ULTRIM is set in PARMLIB), an abend 0C4 is obtained with the following traceback: 4 _inzctrlhFindAuxRel +0000017C 2980 INZUTILK 5 _inzctrlhCheckEcsLobParam +0000063A 8292 INZUTILK 6 _inzctrlhCheckEcsCommonPost +00000444 9014 INZUTILK Another symptom can be obtained : return code 8 with the following message : INZU499E ERROR: INFORMATION WAS NOT FOUND IN THE SYSIBM.SYSAUXRELS TABLE FOR THE FOLLOWING LOB COLUMN: COL_LOB. Example of SYSIN : UNLOAD TABLESPACE QUIESCE YES SELECT COL_LOB1 FROM MZLFRD.TBDZAAFRD30601 OUTDDN (FOUT01) TRIM YES or if ULTRIM is set to YES in PARMLIB
Problem conclusion
The inzctrlh was changed.
Temporary fix
Comments
APAR Information
APAR number
PI64634
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
430
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-06-21
Closed date
2016-07-01
Last modified date
2016-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI39125 UI39126
Modules/Macros
INZUTILK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUUV","label":"IBM Db2 High Performance Unload for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 August 2016