PM81632: ERRORCODE=-4499 WHEN ACCESSING AN IDAA SERVER.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF IDAAV2R1/K IDAAV3R1/K defect 164827 d164827
  Connection fails with (jcc) -4499 SQLSTATE=58009 Reason 0x12
  when accessing an IDAA server.
  When a remote query offload from a java client is prepared,
  executed (OPENed), fetched from, closed, and then executed
  (OPENed) again, the second open fails with a DRDA exception
  detected by the java driver.
  The OPEN repsonse from DB2 for the offloaded query incorrectly
  contains a duplicated instance variable (QRYINSID) and the
  java driver correctly flags this as an error.
  The second open fails as follows:
    com.ibm.db2.jcc.am.DisconnectRecoverableException:
      [jcc][t4][2034][11148][3.61.75] Execution failed due to a
      distribution protocol error that caused deallocation of the
      conversation.
    A DRDA Data Stream Syntax Error was detected.  Reason: 0x12.
    ERRORCODE=-4499, SQLSTATE=58009
  ************************************************************
  Additional Symptoms and Keywords:
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
  *                 Specifically IBM DB2 Analytics Accelerator   *
  *                 (IDAA) users.                                *
  *                 DB2 10 for z/OS only.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Connection fails with (jcc) -4499       *
  *                      SQLSTATE=58009 Reason 0x12 when         *
  *                      accessing an IDAA server.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A remote java client based application connects to a DB2 10 for
  z/OS server and executes a query that is  off-loaded to the
  accelerator.  The same query is executed again but the Java
  driver detects a DRDA exception during Open processing.
  The second Open fails, for example, as follows:
    com.ibm.db2.jcc.am.DisconnectRecoverableException:
       jcc  t4  2034  11148  3.61.75  Execution failed due to a
      distribution protocol error that caused deallocation of the
      conversation.
    A DRDA Data Stream Syntax Error was detected.  Reason: 0x12.
    ERRORCODE=-4499, SQLSTATE=58009
  The exception occurs because the DRDA Open response (OPNQRYRM)
  from DB2 incorrectly contains a duplicated instance variable
  (QRYINSID), and the condition only occurs if the java driver
  functions at a DRDA SQLAM level that is lower than the current
  SQLAM level of DB2 10 for z/OS.
  The problem occurs because DB2 10 for z/OS loses state
  information about the accelerator server.
  

Problem conclusion

• DB2 10 for z/OS is changed to maintain state information
  related to the accelerator.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK92099

Modules/Macros

• DSNLTCCN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK92099

     UP13/03/15 P F303

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.