Fixes are available
APAR status
Closed as program error.
Error description
The condition is that the CLOB in the row returned by the pipelined table function contains alternatively NULL and non NULL CLOB data. This can lead to either a SEGV (Trap) or to some memory 'corrupted block header' failures. Typical top of the stack would be: 0x090000000AE6C128 sqloCrashOnCriticalMemoryValidationFailure + 0x48 0x090000000AED7070 diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCcCb + 0x4F0 0x090000000AE6DF58 IPRA.$sqloDiagnoseFreeBlockFailure__FP8SMemFBlkCb + 0x758 0x090000000AE6C69C sqlofmblkEx + 0x11C 0x090000000D449B24 sqlvFreeLobMem__FP9sqllf_cso@AF14_5 + 0x24 0x090000000D44A688 sqlriRowDescCopy__FP8sqlrr_cbP18sqlriRowDescriptorT2 + 0x208 0x090000000D447840 sqlvSqlPLCopyRow__FP8sqlrr_cbP10sqlz_valueT2 + 0x40 0x090000000F634E64 copyData__3PVMFP10sqlz_valueT1Ulb + 0x3E4 0x090000000F62A39C copyVariable__3PVMFUiT1 + 0xDC 0x090000000F627E48 run__3PVMFv + 0x1348 0x090000000F61375C pvm_entry + 0x45C 0x090000000AE32A8C sqloInvokeFnArgs + 0x5D6C 0x090000000E7E0558 IPRA.$sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorInt fb + 0x2AF8 0x090000000E7D62A8 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x2008 0x0900000011E24E44 sqlri_tfftc__FP8sqlrr_cbP9sqlri_tao + 0x324 0x090000000DAF42BC sqlriFetch__FP8sqlrr_cbP9sqlri_taol + 0x21C
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Rowstore * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 V11.1.4.6 or higher * ****************************************************************
Problem conclusion
Upgrade to Db2 V11.1.4.6 or higher
Temporary fix
Comments
APAR Information
APAR number
IT32897
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-05-18
Closed date
2021-03-26
Last modified date
2021-03-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022