Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as program error.
Error description
if SQL procedure is defined with a result set cursor as "RETURN TO CLIENT", and if the size of the non-lob data being returned in a column is bigger than aslheapsz defined in dbm cfg, the db2agent that executes the SQL procedure will trap with sig #11 with the following stack: . <StackTrace> ---FUNC-ADDR---- ------FUNCTION + OFFSET------ 0000002A9B1A85D8 ossDumpStackTrace + 0x0080 0000002A9B1A629C _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x00aa 0000002A98202FC3 sqlo_trce + 0x033b 0000002A96E4C7A4 sqloEDUCodeTrapHandler + 0x0074 0000002A957D34F0 address: 0x0000002A957D34F0 ; dladdress: 0x0000002A957C7000 ; offset in lib: 0x000000000000C4F0 ; 0000002A96E5DC3A sqloCrashOnCriticalMemoryValidationFailure + 0x001a 0000002A96E6E3FC _ZN8SMemPool32diagnoseMemoryCorruptionAndCrashEmPKc + 0x01f4 0000002A96E6C2CD _ZN8SMemPool10MemTreeGetEmmPPvPP17SqloChunkSubgroupPP12SMemLostN ode + 0x00bd 0000002A96E6E681 _ZN8SMemPool19allocateMemoryBlockEmmmjmPPvPP17SqloChunkSubgroupP P12SMemLostNodeP12SMemLogEvent + 0x00c9 0000002A96E5E3C7 sqlogmblkEx + 0x077f 0000002A968CDB25 _Z11sqlddCopyDDP8SMemPoolPP14dataDescriptorS2_jmPmPKcm + 0x04a7 0000002A97FF7B78 _Z17sqlerAnchorCursorP14db2UCinterface + 0x04a0 0000002A9829BD27 _Z16csmCursorBlasterP14db2UCinterfacejjPjjj + 0x06ff 0000002A97A3A644 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntf + 0x1f3c 0000002A97A37CB2 _Z18sqlriInvokeInvokerP10sqlri_ufob
Local fix
The workaroun dis to increase aslheapsz in the dbm cfg
Problem summary
if SQL procedure is defined with a result set cursor as "RETURN TO CLIENT", and if the size of the non-lob data being returned in a column is bigger than aslheapsz defined in dbm cfg, the db2agent that executes the SQL procedure will trap with sig #11 with the following stack: . <StackTrace> ---FUNC-ADDR---- ------FUNCTION + OFFSET------ 0000002A9B1A85D8 ossDumpStackTrace + 0x0080 0000002A9B1A629C _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x00aa 0000002A98202FC3 sqlo_trce + 0x033b 0000002A96E4C7A4 sqloEDUCodeTrapHandler + 0x0074 0000002A957D34F0 address: 0x0000002A957D34F0 ; dladdress: 0x0000002A957C7000 ; offset in lib: 0x000000000000C4F0 ; 0000002A96E5DC3A sqloCrashOnCriticalMemoryValidationFailure + 0x001a 0000002A96E6E3FC _ZN8SMemPool32diagnoseMemoryCorruptionAndCrashEmPKc + 0x01f4 0000002A96E6C2CD _ZN8SMemPool10MemTreeGetEmmPPvPP17SqloChunkSubgroupPP12SMemLostN ode + 0x00bd 0000002A96E6E681 _ZN8SMemPool19allocateMemoryBlockEmmmjmPPvPP17SqloChunkSubgroupP P12SMemLostNodeP12SMemLogEvent + 0x00c9 0000002A96E5E3C7 sqlogmblkEx + 0x077f 0000002A968CDB25 _Z11sqlddCopyDDP8SMemPoolPP14dataDescriptorS2_jmPmPKcm + 0x04a7 0000002A97FF7B78 _Z17sqlerAnchorCursorP14db2UCinterface + 0x04a0 0000002A9829BD27 _Z16csmCursorBlasterP14db2UCinterfacejjPjjj + 0x06ff 0000002A97A3A644 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntf + 0x1f3c 0000002A97A37CB2 _Z18sqlriInvokeInvokerP10sqlri_ufob
Problem conclusion
fixed in v91 fixpack 6 and above..
Temporary fix
The workaround is to increase aslheapsz in the dbm cfg
Comments
APAR Information
APAR number
IZ28655
Reported component name
DB2 DPF
Reported component ID
5724N7400
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-07-30
Closed date
2008-11-03
Last modified date
2008-11-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ENG_SQDD
Fix information
Fixed component name
DB2 DPF
Fixed component ID
5724N7400
Applicable component levels
R910 PSN
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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":"910"}]
Document Information
Modified date:
03 October 2021