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: hbwang NODE : 000 DB : DB11
APPHDL : 0-28 APPID: *LOCAL.hbwang.170717232912
AUTHID : HBWANG HOSTNAME: panipuri
EDUID : 2332 EDUNAME: db2agent (DB11)
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 |
