Support for Informix

Latest versions	fixlist
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Have problems? - contact us.
Register for free
Contact form

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 Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows 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
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)