A fix is available
APAR status
Closed as program error.
Error description
In DB2 version 10 and later versions, an ABENDU1132 with reason 8 occurs when attempting to unload a very big LOB in native mode. A very big LOB is a LOB that requires more than 1 LOB MAP page in the LOB table space, i.e. which is greater than - 26 MB when the page size on LOB TS is 4K. - 52 MB when the page size on LOB TS is 4K. - 104 MB when the page size on LOB TS is 4K. - 208 MB when the page size on LOB TS is 4K. PB51005 Z631
Local fix
Run the unload in SQL mode.
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 High Performance Unload * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: In DB2 version 10 and later versions, * * an ABENDU1132 with reason 8 occurs * * when attempting to unload a very big * * LOB in native mode. * * A very big LOB is a LOB that requires * * more than 1 LOB MAP page in the LOB * * table space, i.e. which is greater * * than * * * * - 26 MB when the page size on LOB TS * * is 4K. * * - 52 MB when the page size on LOB TS * * is 4K. * * - 104 MB when the page size on LOB TS * * is 4K. * * - 208 MB when the page size on LOB TS * * is 4K. * * pb51005 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** The inzmsgs and inzctrlh modules were changed.The inzlobr module was changed.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI93187
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
2018-01-31
Closed date
2018-02-19
Last modified date
2018-03-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZUTILX
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R430 PSY UI53962
UP18/02/23 P F802
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":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.3.0"}]
Document Information
Modified date:
31 March 2021