Fixes are available
APAR status
Closed as program error.
Error description
You may see the following error in db2diag.log. 2019-01-08-09.43.13.469383+540 I3905E3265 LEVEL: Error PID : 75484 TID : 17698574496096 PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 DB : BLUDB APPHDL : 0-58383 APPID: *N0.db2inst1.190108003109 UOWID : 2 ACTID: 1 AUTHID : ADMIN HOSTNAME: host EDUID : 2171 EDUNAME: db2agntcol (BLUDB) 1 FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:151 DATA #1 : String, 279 bytes AssertionFailedException: An assertion 'mSizeOfEncodedFKeyInBytes == mJoinHashTableInfo->getSizeOfEncodedKeyInBytes() || 0 == mJoinHashTableInfo->getSizeOfEncodedKeyInBytes()' failed. Additional info: encoded key size mismatch 272 56 Thrown at GetJoinPayloadEvaluator.cpp : 151 DATA #2 : Function name in Library, 23 bytes GetJoinPayloadEvaluator DATA #3 : File name, 27 bytes GetJoinPayloadEvaluator.cpp CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x0000100003638A38 pdLog + 0x648 [1] 0x00001000048BF084 _ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait + 0x974 [2] 0x0000100004815690 _ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo nentIDEPKc + 0x220 [3] 0x000010000480989C _ZN7ibm_cde8services24AssertionFailedException17constructAndThro wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0xFC [4] 0x000010000AA84080 _ZN7ibm_cde5query23GetJoinPayloadEvaluatorC1EPNS0_5QueueENS0_9Ev aluator9InputInfoES5_jPKNS0_10SyntaxTreeEP13SQLO_MEM_POOLPNS0_1 + 0x1D90 [5] 0x000010000692C5B0 _ZN7ibm_cde5query17EvaluationRoutine29formEvaluationRoutineInter nalEPKNS0_10SyntaxTreeERKNS0_14QueryResourcesERNS_4data22TableA + 0x255C0 [6] 0x0000100006904D20 _ZN7ibm_cde5query17EvaluationRoutine21formEvaluationRoutineEsRNS _4data22TableAccessorAllocatorERKNS0_19QueryResultInfoListERNS0 + 0xB50 [7] 0x00001000078DA9C0 _ZN7ibm_cde5query9Scheduler19genSingleTableQueryEPNS0_10SyntaxTr eeEPNS0_18NLJoinControlBlockE + 0x270 [8] 0x00001000078D4C00 _ZN7ibm_cde5query9Scheduler19runSingleTableQueryEv + 0x670 [9] 0x00001000078D4434 _ZN7ibm_cde5query9Scheduler17runCompositeQueryEv + 0x464 [10] 0x00001000078D7494 _ZN7ibm_cde5query9Scheduler15runMasterThreadEPvPi + 0x144 [11] 0x00001000078E7D2C _ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0xBC [12] 0x0000100008BF1D6C _ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0xEC [13] 0x000010000F598F14 _Z14sqlriInvokeCdeP8sqlrr_cb + 0x64 [14] 0x000010000F3BAB10 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x400 [15] 0x000010000EBC58A4 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x1B4 [16] 0x000010000EBC21C4 _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xF54 [17] 0x000010000B2A4780 /head/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xAF34780 [18] 0x000010000B29EF18 _Z21sqleProcessSubRequestP8sqeAgent + 0x22C8 [19] 0x000010000B31FE28 _ZN8sqeAgent6RunEDUEv + 0x9D8 [20] 0x000010001082686C _ZN9sqzEDUObj9EDUDriverEv + 0x25C [21] 0x00001000108265EC _Z10sqlzRunEDUPcj + 0x1C [22] 0x000010000E26CA08 sqloEDUEntry + 0x9C8 [23] 0x0000100000088AF4 /lib64/libpthread.so.0 + 0x8AF4 [24] 0x0000100016CC8814 clone + 0xE4 2019-01-08-09.43.13.485044+540 I7171E3037 LEVEL: Severe (Origin) PID : 75484 TID : 17698574496096 PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 DB : BLUDB APPHDL : 0-58383 APPID: *N0.db2inst1.190108003109 UOWID : 2 ACTID: 1 AUTHID : ADMIN HOSTNAME: host EDUID : 2171 EDUNAME: db2agntcol (BLUDB) 1 FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:151 MESSAGE : SQL0901N The SQL statement or command failed because of a database system error. (Reason "".) DATA #1 : <preformatted> 'mSizeOfEncodedFKeyInBytes == mJoinHashTableInfo->getSizeOfEncodedKeyInBytes() || 0 == mJoinHashTableInfo->getSizeOfEncodedKeyInBytes()' failed. Info: encoded key size mismatch 272 56 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x000010000363D5BC pdLogVPrintf + 0x5CC [1] 0x000010000363D91C pdLogPrintf + 0x3C [2] 0x0000100004808AB0 _ZN7ibm_cde8services24AssertionFailedException4doneEv + 0x4C0 [3] 0x00001000048098A8 _ZN7ibm_cde8services24AssertionFailedException17constructAndThro wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0x108 [4] 0x000010000AA84080 _ZN7ibm_cde5query23GetJoinPayloadEvaluatorC1EPNS0_5QueueENS0_9Ev aluator9InputInfoES5_jPKNS0_10SyntaxTreeEP13SQLO_MEM_POOLPNS0_1 + 0x1D90 [5] 0x000010000692C5B0 _ZN7ibm_cde5query17EvaluationRoutine29formEvaluationRoutineInter nalEPKNS0_10SyntaxTreeERKNS0_14QueryResourcesERNS_4data22TableA + 0x255C0 [6] 0x0000100006904D20 _ZN7ibm_cde5query17EvaluationRoutine21formEvaluationRoutineEsRNS _4data22TableAccessorAllocatorERKNS0_19QueryResultInfoListERNS0 + 0xB50 [7] 0x00001000078DA9C0 _ZN7ibm_cde5query9Scheduler19genSingleTableQueryEPNS0_10SyntaxTr eeEPNS0_18NLJoinControlBlockE + 0x270 [8] 0x00001000078D4C00 _ZN7ibm_cde5query9Scheduler19runSingleTableQueryEv + 0x670 [9] 0x00001000078D4434 _ZN7ibm_cde5query9Scheduler17runCompositeQueryEv + 0x464 [10] 0x00001000078D7494 _ZN7ibm_cde5query9Scheduler15runMasterThreadEPvPi + 0x144 [11] 0x00001000078E7D2C _ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0xBC [12] 0x0000100008BF1D6C _ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0xEC [13] 0x000010000F598F14 _Z14sqlriInvokeCdeP8sqlrr_cb + 0x64 [14] 0x000010000F3BAB10 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x400 [15] 0x000010000EBC58A4 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x1B4 [16] 0x000010000EBC21C4 _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xF54 [17] 0x000010000B2A4780 /head/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xAF34780 [18] 0x000010000B29EF18 _Z21sqleProcessSubRequestP8sqeAgent + 0x22C8 [19] 0x000010000B31FE28 _ZN8sqeAgent6RunEDUEv + 0x9D8 [20] 0x000010001082686C _ZN9sqzEDUObj9EDUDriverEv + 0x25C [21] 0x00001000108265EC _Z10sqlzRunEDUPcj + 0x1C [22] 0x000010000E26CA08 sqloEDUEntry + 0x9C8 [23] 0x0000100000088AF4 /lib64/libpthread.so.0 + 0x8AF4 [24] 0x0000100016CC8814 clone + 0xE4
Local fix
explicitly cast the output of the TO_CHAR function.
Problem summary
**************************************************************** * USERS AFFECTED: * * Users who use TO_CHAR function * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to Db2 v11.1 m4fp6 or later. * ****************************************************************
Problem conclusion
This problem is first fixed in Db2 v11.1 m4fp6.
Temporary fix
Comments
APAR Information
APAR number
IT31970
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-02-25
Closed date
2021-03-31
Last modified date
2021-03-31
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