Fixes are available
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
Calling HASH function on an empty blob returns SQL0083C error: $ db2 "values hash( blob(''), 2 )" SQL0083C A memory allocation error has occurred. The following is logged in db2diag.log: 2017-07-17-21.05.23.674784-240 I1553866A2599 LEVEL: Warning PID : 36634966 TID : 2332 PROC : db2sysc INSTANCE: DB2INST1 NODE : 000 DB : MYDB1 APPHDL : 0-28 APPID: *X.X.X.X.0000 AUTHID : DB2INST1 HOSTNAME: MYHOST1 EDUID : 2332 EDUNAME: db2agent (MYDB1) FUNCTION: DB2 UDB, SQO Memory Management, sqlogmblkEx, probe:1000 MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt invalid size" DIA8563C An invalid memory size was requested. DATA #1 : String, 43 bytes Memory management block allocation failure. DATA #2 : Codepath, 8 bytes 2 DATA #3 : Memory pool handle pointer, PD_TYPE_MEM_POOL_HANDLE_PTR, 8 bytes 0x0a00020000003398 DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes 0 DATA #5 : Adjusted block size, PD_TYPE_MEM_ADJUSTED_SIZE, 8 bytes 0 DATA #6 : Options for requested block, PD_TYPE_GET_MEM_OPTIONS, 4 bytes 0x00000000 DATA #7 : File name, PD_TYPE_OSS_MEM_FILE_NAME, 17 bytes sqlri_hash_sclr.C DATA #8 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes 652 DATA #9 : Resource binding pointer, PD_TYPE_RESOURCE_BINDING_PTR, 8 bytes 0x0000000000000000 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x090000008D988C9C sqloGetMemoryBlockExtended + 0x41C [1] 0x0900000093FC1250 sqlriHashLong__FP8sqlrr_cb + 0x350 [2] 0x09000000905C53B8 sqlriComputeOnce__FP8sqlrr_cb + 0xB8 [3] 0x090000008F878878 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x5F8 [4] 0x090000008F32D628 sqlrr_process_fetch_request__FP14db2UCinterface + 0xD08 [5] 0x090000008F3309A8 sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x10C8 [6] 0x0900000094721140 sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0x4C0 [7] 0x09000000946BFB78 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface + 0x298 [8] 0x09000000946C2BD0 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x2250 [9] 0x090000009468F04C IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xEAC [10] 0x0900000094697B14 sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4 [11] 0x090000009468D0F0 IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0 [12] 0x090000009468A534 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x334 [13] 0x090000008DA95CA0 RunEDU__8sqeAgentFv + 0xB60 [14] 0x090000008DA787A0 EDUDriver__9sqzEDUObjFv + 0x2E0 [15] 0x090000008D968714 sqloEDUEntry + 0x374 [16] 0x0900000000573FE8 _pthread_body + 0xE8 [17] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher * ****************************************************************
Problem conclusion
First fixed in Db2 11.1 Mod 3 Fix Pack 3
Temporary fix
Comments
APAR Information
APAR number
IT21509
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
2017-07-18
Closed date
2018-03-19
Last modified date
2022-03-29
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 PSN
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:
03 May 2022