IBM Support

IT19753: ISSUE IS WITH DATA ENCRYPT WITH NULL LOB VALUE THERE IS EXCEPTION IN JCC TRACE WITH EMPTY DATA.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

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
    
    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
    

Local fix

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                               *
    ****************************************************************
    

Problem conclusion

Temporary fix

  • NA
    

Comments

APAR Information

  • APAR number

    IT19753

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-17

  • Closed date

    2018-03-16

  • Last modified date

    2018-03-16

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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:
29 June 2020