APAR status
Closed as fixed if next.
Error description
Queries that include a CASE statement with an IN predicate, and the column used in the IN predicate is also used in a local predicate (ie WHERE clause) may fail with a memory allocation error during precompilation. For example: CREATE TABLE BIGSQL.TAB1( C01 VARCHAR(10) , C02 VARCHAR(10) , C03 VARCHAR(10) ); SELECT CASE WHEN (C02 IN ('xxx','yyy') AND SUBSTRING(C03,1,1)!='0') OR (C02 IN ('zzz','qqq')) THEN 'www' ELSE C03 END AS C03 FROM BIGSQL.TAB1 WHERE C02 = 'xxx'; If the value in the WHERE clause is changed from 'xxx' to another value that is not in the first IN clause, then the query runs successfully. The following message is seen in the db2diag log: 2018-11-30-18.05.40.543828-480 I577942E5196 LEVEL: Warning PID : 8754 TID : 140082119960320 PROC : db2sysc 0 INSTANCE: bigsql NODE : 000 DB : BIGSQL APPHDL : 0-187 APPID: *N0.bigsql.xxxxxxxxxxxx AUTHID : BIGSQL HOSTNAME: xxxxxxx.fyre.ibm.com EDUID : 99 EDUNAME: db2agent (BIGSQL) 0 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 0x00007f6726570030 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, 11 bytes sqlng_opr.C DATA #8 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes 25072 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] 0x00007F67888BEEB1 sqloGetMemoryBlockExtended + 0x3E1 [1] 0x00007F6787693A04 _Z23sqlngBuildInSetBinaryOpP9sqlng_blkPP12sqlri_opparmP9sqlnq_pi db + 0x174 [2] 0x00007F678768D629 _Z16sqlngBuildInListP9sqlng_blkPP12sqlri_opparmP9sqlnq_pid + 0x99 [3] 0x00007F67876B27C9 _Z29sqlng_process_parse_tree_nodeP9sqlng_blkP9sqlnq_pid + 0x659 [4] 0x00007F67876B1C7B _Z21sqlng_process_BF_nodeP9sqlng_blkP9sqlnq_pid + 0x16B [5] 0x00007F67876B37C4 _Z29sqlng_process_parse_tree_nodeP9sqlng_blkP9sqlnq_pid + 0x1654 [6] 0x00007F67876B1C7B _Z21sqlng_process_BF_nodeP9sqlng_blkP9sqlnq_pid + 0x16B [7] 0x00007F67876B14AB _Z19sqlng_walk_BF_chainP9sqlng_blk + 0x92B [8] 0x00007F678762C0AB _Z18sqlng_build_threadP9sqlng_blkP14sqlng_thd_ctrl + 0x125B [9] 0x00007F678767F2E2 _Z19sqlng_build_CASE_opP9sqlng_blkP9sqlnq_pid + 0x442 [10] 0x00007F67876B27F9 _Z29sqlng_process_parse_tree_nodeP9sqlng_blkP9sqlnq_pid + 0x689 [11] 0x00007F67876B1C7B _Z21sqlng_process_BF_nodeP9sqlng_blkP9sqlnq_pid + 0x16B [12] 0x00007F67877B5047 _ZN28sqlngScalarExpressionBuilder15buildExpressionEP9sqlnq_hxp + 0x1A7 [13] 0x00007F67877B46BA _ZN22sqlngExpressionBuilder15buildExpressionEP9sqlnq_exp + 0x3A [14] 0x00007F67876B5B09 _Z21sqlng_walk_EXPR_chainP9sqlng_blk + 0x2B9 [15] 0x00007F678762B377 _Z18sqlng_build_threadP9sqlng_blkP14sqlng_thd_ctrl + 0x527 [16] 0x00007F678769B54D _Z21sqlng_process_mate_opP9sqlng_blkP19sqlno_plan_operator + 0x59D [17] 0x00007F678763DFFD _Z19sqlngProcessLolepopP9sqlng_blkP19sqlno_plan_operator + 0xBD [18] 0x00007F678769AAF1 _Z21sqlng_process_pipe_opP9sqlng_blkP19sqlno_plan_operator + 0x381 [19] 0x00007F678763DFFD _Z19sqlngProcessLolepopP9sqlng_blkP19sqlno_plan_operator + 0xBD [20] 0x00007F678762B2B2 _Z18sqlng_build_threadP9sqlng_blkP14sqlng_thd_ctrl + 0x462 [21] 0x00007F678772B444 _Z22sqlng_process_smptq_opP9sqlng_blkP19sqlno_plan_operator + 0x424 [22] 0x00007F678772CCE8 _Z19sqlng_process_tq_opP9sqlng_blkP19sqlno_plan_operator + 0x8D8 [23] 0x00007F678763DFFD _Z19sqlngProcessLolepopP9sqlng_blkP19sqlno_plan_operator + 0xBD [24] 0x00007F678779FEC0 _Z23sqlng_process_return_opP9sqlng_blkP19sqlno_plan_operator + 0xAF0 [25] 0x00007F678763DFFD _Z19sqlngProcessLolepopP9sqlng_blkP19sqlno_plan_operator + 0xBD [26] 0x00007F678762B5DF _Z18sqlng_build_threadP9sqlng_blkP14sqlng_thd_ctrl + 0x78F [27] 0x00007F6787641558 _Z10sqlng_mainP9sqlnq_qur + 0x32F8 [28] 0x00007F67877D9159 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_enviiPP9sqlnq_qur + 0x5B09 [29] 0x00007F67877D3641 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_env + 0x21 [30] 0x00007F67891E16C4 _Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP _LOCK_INFOP16sqlra_cached_varPiS5_Pb + 0x10F4 [31] 0x00007F67891FDECE _Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idj jPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOC + 0x96E [32] 0x00007F678929F2D1 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0xF11 [33] 0x00007F6788F2E922 _Z13sqlrr_prepareP14db2UCinterfaceP16db2UCprepareInfo + 0x452 [34] 0x00007F6787104807 _Z19sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x407 [35] 0x00007F67870F459B _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0xEB [36] 0x00007F67870F5666 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x546 [37] 0x00007F67870E84CA /home/bigsql/sqllib/lib64/libdb2e.so.1 + 0x563A4CA [38] 0x00007F67870EEA93 /home/bigsql/sqllib/lib64/libdb2e.so.1 + 0x5640A93 [39] 0x00007F67870EF74F _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x11F [40] 0x00007F6786B2C814 _ZN8sqeAgent6RunEDUEv + 0xDE4 [41] 0x00007F678A33CD66 _ZN9sqzEDUObj9EDUDriverEv + 0x116 [42] 0x00007F678890BB18 sqloEDUEntry + 0x578 [43] 0x00007F67901D9DD5 /lib64/libpthread.so.0 + 0x7DD5 [44] 0x00007F6780574EAD clone + 0x6D
Local fix
Problem summary
Please see problem description.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH06245
Reported component name
IBM BIG SQL
Reported component ID
5737E7400
Reported release
503
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-12-06
Closed date
2020-09-09
Last modified date
2020-09-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"503"}]
Document Information
Modified date:
10 September 2020