DB2 - Problem description
Problem IT19753 | Status: Closed |
ISSUE IS WITH DATA ENCRYPT WITH NULL LOB VALUE THERE IS EXCEPTION IN JCC TRACE WITH EMPTY DATA. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Issue is with data encrypt with NULL lob value. There is exception in jcc trace with empty data when AUTHENTICATION is set to DATA_ENCRYPT db2diag.log entries 2017-02-02-12.30.20.990491+240 E1829A742 LEVEL: Error PID : 13172756 TID : 30699 PROC : db2sysc INSTANCE: db2inst3 NODE : 000 DB : JCRDB APPHDL : 0-2735 APPID: 10.15.13.75.60142.170202082241 AUTHID : DB2INST3 EDUID : 30699 EDUNAME: db2agent (JCRDB) FUNCTION: DB2 UDB, Common Trace API, sqljsParseInstVar, probe:2 MESSAGE : DIA5000C A DRDA AS token "RECOVERABLE" was detected. The diagnostic data returned is (SRVDGN): "FUNCTION ID = 0043 , PROBE POINT = 0002 , TRACE POINT = 0010 , SUBCODE1 = FFFFFFFF87360009, SUBCODE2 = 0000000000000000, SUBCODE3 = 0000000000000000, ERROR MSG = AGENT: CMNMGR Read Failure". 2017-02-02-12.30.20.990766+240 I2572A630 LEVEL: Error PID : 13172756 TID : 30699 PROC : db2sysc INSTANCE: db2inst3 NODE : 000 DB : JCRDB APPHDL : 0-2735 APPID: 10.15.13.75.60142.170202082241 AUTHID : DB2INST3 EDUID : 30699 EDUNAME: db2agent (JCRDB) FUNCTION: DB2 UDB, Common Trace API, sqljsParseInstVar, probe:10 MESSAGE : ZRC=0x804B009D=-2142568291=SQLJS_DTAMCH "Error during reading of FDOCA data" DATA #1 : DDM Object, PD_TYPE_DDM_OBJECT, 16 bytes data length : 0 codepoint : 0x146c ( EXTDTA ) length : 4 ( EXTENDED ) 2017-02-02-12.30.20.990940+240 I3203A192 LEVEL: Error PID:13172756 TID:30699 NODE:000 Title: **** DRDA ASCB **** Dump File: /db2db/db2inst3/sqllib/db2dump/13172756.30699.000.dump.bin .. ================ DRDA trace - 81667 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177) pid 22544582 tid 31182 cpid 23003296 node 0 sec 218 nsec 290511941 probe 1177 bytes 258 SEND BUFFER(AS): DTAMCHRM RPYDSS (ASCII) (EBCDIC) 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 00F1D002000100EB 220E000611490008 ........"....I.. .1}............. 0010 00162110D1C3D9C4 C240404040404040 ..!......@@@@@@@ ....JCRDB 0020 40404040404000CB 1153C6E4D5C3E3C9 @@@@@@...S...... ....FUNCTI 0030 D6D540C9C4407E40 F0F2F8F0406B40D7 ..@..@.@....@k@. ON ID = 0280 , P 0040 D9D6C2C540D7D6C9 D5E3407E40F0F4F0 ....@.....@.@... ROBE POINT = 040 0050 F6406B40E3D9C1C3 C540D7D6C9D5E340 .@k@.....@.....@ 6 , TRACE POINT 0060 7E40F0F0F2F5406B 40E2E4C2C3D6C4C5 .@....@k@....... = 0025 , SUBCODE 0070 F1407E40C6C6C6C6 C6C6C6C6F8F7F3F6 .@.@............ 1 = FFFFFFFF8736 0080 F0F0F0F96B40E2E4 C2C3D6C4C5F2407E ....k@........@. 0009, SUBCODE2 = 0090 40F0F0F0F0F0F0F0 F0F0F0F0F0F0F0F0 @............... 000000000000000 00A0 F06B40E2E4C2C3D6 C4C5F3407E40F0F0 .k@........@.@.. 0, SUBCODE3 = 00 00B0 F0F0F0F0F0F0F0F0 F0F0F0F0F0F06B40 ..............k@ 00000000000000, 00C0 C5D9D9D6D940D4E2 C7407E40D78199A2 .....@...@.@.... ERROR MSG = Pars 00D0 85997A40D98598A4 8999858440978199 ..z@........@... er: Required par 00E0 819485A385994DA2 5D409489A2A28995 ......M.]@...... ameter(s) missin 00F0 87 . g 81668 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.30) pid 22544582 tid 31182 cpid 23003296 node 0 sec 218 nsec 306076937 probe 30 bytes 445 Data1 (PD_DB2_TYPE_SQLCA,136) SQLCA: sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30081 sqlerrml: 27 sqlerrmc: * * 0 TCP/IP SOCKETS recv sqlerrp : SQLJCMN sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: Data2 (PD_TYPE_COMCONDITION,284) Communication Failure Condition: Communication Condition SEVERITY = 8 NUMBER TOKENS = 7 MSG TOKEN[0] = * MSG TOKEN[1] = * MSG TOKEN[2] = 0 MSG TOKEN[3] = TCP/IP MSG TOKEN[4] = SOCKETS MSG TOKEN[5] = MSG TOKEN[6] = recv Data3 (PD_TYPE_UINT,1) unsigned integer: 9 81669 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.30) pid 22544582 tid 30154 cpid 23003296 node 0 sec 218 nsec 526786375 probe 30 bytes 445 ================== JDBCtrace [jcc][t4] [time:2017-02-14-15:59:28.749][Thread:WebContainer : 1][tracepoint:101]Request flushed. [jcc][t4] [time:2017-02-14-15:59:28.749][Thread:WebContainer : 1][tracepoint:102]Reply to be filled. [jcc][t4][time:2017-02-14-15:59:28.752][Thread:WebContainer : 1][tracepoint:2][Reply.fill] [jcc][t4] RECEIVE BUFFER: DTAMCHRM (ASCII) (EBCDIC) [jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF [jcc][t4] 0000 00F1D002000100EB 220E000611490008 ........"....I.. .1}............. [jcc][t4] 0010 00162110D1C3D9C4 C240404040404040 ..!......@@@@@@@ ....JCRDB [jcc][t4] 0020 40404040404000CB 1153C6E4D5C3E3C9 @@@@@@...S...... ....FUNCTI [jcc][t4] 0030 D6D540C9C4407E40 F0F2F8F0406B40D7 ..@..@?@....@k@. ON ID = 0280 , P [jcc][t4] 0040 D9D6C2C540D7D6C9 D5E3407E40F0F4F0 ....@.....@?@... ROBE POINT = 040 [jcc][t4] 0050 F6406B40E3D9C1C3 C540D7D6C9D5E340 .@k@.....@.....@ 6 , TRACE POINT [jcc][t4] 0060 7E40F0F0F2F5406B 40E2E4C2C3D6C4C5 ?@....@k@....... = 0025 , SUBCODE [jcc][t4] 0070 F1407E40C6C6C6C6 C6C6C6C6F8F7F3F6 .@?@............ 1 = FFFFFFFF8736 [jcc][t4] 0080 F0F0F0F96B40E2E4 C2C3D6C4C5F2407E ....k@........@? 0009, SUBCODE2 = [jcc][t4] 0090 40F0F0F0F0F0F0F0 F0F0F0F0F0F0F0F0 @............... 000000000000000 [jcc][t4] 00A0 F06B40E2E4C2C3D6 C4C5F3407E40F0F0 .k@........@?@.. 0, SUBCODE3 = 00 [jcc][t4] 00B0 F0F0F0F0F0F0F0F0 F0F0F0F0F0F06B40 ..............k@ 00000000000000, [jcc][t4] 00C0 C5D9D9D6D940D4E2 C7407E40D78199A2 .....@...@?@.... ERROR MSG = Pars [jcc][t4] 00D0 85997A40D98598A4 8999858440978199 ..z@........@... er: Required par [jcc][t4] 00E0 819485A385994DA2 5D409489A2A28995 ......M.]@...... ameter(s) missin [jcc][t4] 00F0 87 . g [jcc][t4] [jcc][t4] [time:2017-02-14-15:59:28.767][Thread:WebContainer : 1][tracepoint:202] closing non-pooled Transport: [jcc][Connection@9e720cbe] DB2 LUWID: 10.15.13.75.57000.170214113225.0911 [jcc] BEGIN TRACE_DIAGNOSTICS [jcc][Thread:WebContainer : 1][SQLException@ae397c80] java.sql.SQLException [jcc][Thread:WebContainer : 1][SQLException@ae397c80] SQL state = 58009 [jcc][Thread:WebContainer : 1][SQLException@ae397c80] Error code = -4499 [jcc][Thread:WebContainer : 1][SQLException@ae397c80] Message = [jcc][t4][2052][11278][4.19.66] Execution failed due to a distribution protocol error that caused deallocation of the conversation. A Data Descriptor Mismatch Error was detected. ERRORCODE=-4499, SQLSTATE=58009 [jcc][Thread:WebContainer : 1][SQLException@ae397c80] Stack trace follows com.ibm.db2.jcc.am.DisconnectRecoverableException: [jcc][t4][2052][11278][4.19.66] Execution failed due to a distribution protocol error that caused deallocation of the conversation. A Data Descriptor Mismatch Error was detected. ERRORCODE=-4499, SQLSTATE=58009 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all db2 LUW users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * * * * Issue is with data encrypt with NULL lob value. There is * * exception in jcc trace with empty data when AUTHENTICATION * * is set to DATA_ENCRYPT * * 2017-02-02-12.30.20.990491+240 E1829A742 LEVEL: * * Error * * PID : 13172756 TID : 30699 PROC : * * db2sysc * * INSTANCE: db2inst3 NODE : 000 DB : * * JCRDB * * APPHDL : 0-2735 APPID: * * 10.15.13.75.60142.170202082241 * * AUTHID : DB2INST3 * * EDUID : 30699 EDUNAME: db2agent (JCRDB) * * FUNCTION: DB2 UDB, Common Trace API, sqljsParseInstVar, * * probe:2 * * MESSAGE : DIA5000C A DRDA AS token "RECOVERABLE" was * * detected. The diagnostic * * data returned is (SRVDGN): "FUNCTION ID = 0043 , * * PROBE POINT = 0002 , * * TRACE POINT = 0010 , SUBCODE1 = FFFFFFFF87360009, * * SUBCODE2 = * * 0000000000000000, SUBCODE3 = 0000000000000000, * * ERROR MSG = AGENT: * * CMNMGR Read Failure". * * * * 2017-02-02-12.30.20.990766+240 I2572A630 LEVEL: * * Error * * PID : 13172756 TID : 30699 PROC : * * db2sysc * * INSTANCE: db2inst3 NODE : 000 DB : * * JCRDB * * APPHDL : 0-2735 APPID: * * 10.15.13.75.60142.170202082241 * * AUTHID : DB2INST3 * * EDUID : 30699 EDUNAME: db2agent (JCRDB) * * FUNCTION: DB2 UDB, Common Trace API, sqljsParseInstVar, * * probe:10 * * MESSAGE : ZRC=0x804B009D=-2142568291=SQLJS_DTAMCH * * "Error during reading of FDOCA data" * * DATA #1 : DDM Object, PD_TYPE_DDM_OBJECT, 16 bytes * * * * data length : 0 * * codepoint : 0x146c ( EXTDTA ) * * length : 4 ( EXTENDED ) * * * * JCC Trace: * * [jcc][t4] RECEIVE BUFFER: DTAMCHRM (ASCII) * * (EBCDIC) * * [jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F * * 0123456789ABCDEF 0123456789ABCDEF * * [jcc][t4] 0000 00F1D002000100EB 220E000611490008 * * ........"....I.. .1}............. * * [jcc][t4] 0010 00162110D1C3D9C4 C240404040404040 * * ..!......@@@@@@@ ....JCRDB * * [jcc][t4] 0020 40404040404000CB 1153C6E4D5C3E3C9 * * @@@@@@...S...... ....FUNCTI * * [jcc][t4] 0030 D6D540C9C4407E40 F0F2F8F0406B40D7 * * ..@..@?@....@k@. ON ID = 0280 , P * * [jcc][t4] 0040 D9D6C2C540D7D6C9 D5E3407E40F0F4F0 * * ....@.....@?@... ROBE POINT = 040 * * [jcc][t4] 0050 F6406B40E3D9C1C3 C540D7D6C9D5E340 * * .@k@.....@.....@ 6 , TRACE POINT * * [jcc][t4] 0060 7E40F0F0F2F5406B 40E2E4C2C3D6C4C5 * * ?@....@k@....... = 0025 , SUBCODE * * [jcc][t4] 0070 F1407E40C6C6C6C6 C6C6C6C6F8F7F3F6 * * .@?@............ 1 = FFFFFFFF8736 * * [jcc][t4] 0080 F0F0F0F96B40E2E4 C2C3D6C4C5F2407E * * ....k@........@? 0009, SUBCODE2 = * * [jcc][t4] 0090 40F0F0F0F0F0F0F0 F0F0F0F0F0F0F0F0 * * @............... 000000000000000 * * [jcc][t4] 00A0 F06B40E2E4C2C3D6 C4C5F3407E40F0F0 * * .k@........@?@.. 0, SUBCODE3 = 00 * * [jcc][t4] 00B0 F0F0F0F0F0F0F0F0 F0F0F0F0F0F06B40 * * ..............k@ 00000000000000, * * [jcc][t4] 00C0 C5D9D9D6D940D4E2 C7407E40D78199A2 * * .....@...@?@.... ERROR MSG = Pars * * [jcc][t4] 00D0 85997A40D98598A4 8999858440978199 * * ..z@........@... er: Required par * * [jcc][t4] 00E0 819485A385994DA2 5D409489A2A28995 * * ......M.]@...... ameter(s) missin * * [jcc][t4] 00F0 87 . * * g * **************************************************************** * RECOMMENDATION: * * Upgrade to db2 11.1 latest fix * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
Workaround | |
NA | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.03.2017 16.03.2018 16.03.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |