PM33761: A JAVA EXCEPTION WAS REPORTED WHEN CALLING A STORED PROCEDURE IN V9 AND V10 COEXSITENCE ENVIRONMENT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF DB2SP DB2DRDA
  ArrayIndexOutOfBoundsException was issued by a JAVA application
  with enable SysplexWLB=TRUE and useCachedCursor=TRUE when
  CALLing a stored procedure which was declared in a sysplex
  coexistence environment ( V9 and V10 ) due to a combination of
  client and server behaviors regarding stored procedure output
  parameters.
  ********************************************************
  Additional symptoms and keywords:
    SQLSP SQLSTOREDPROC SQLINCORR INCORROUT SQLINCORROUT
    DB2INCORR/K DB2COEXIST/K
  

Local fix

• turn off the useCachedCursor property
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users    *
  *                 using IBM Data Server Driver for JDBC and    *
  *                 SQLJ Type 4 Connectivity to access a DB2 for *
  *                 z/OS data sharing group.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Infrastructure for future               *
  *                      enhancements to DB2.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR provides infrastructure changes that are necessary
  in order to correct a reported problem. Follow on APAR changes
  will be implemented in order to provide an actual solution.
  

Problem conclusion

• This APAR provides infrastructure for future DB2 enhancements
  and will not affect current DB2 functionality.
  

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:

  UK69053

Modules/Macros

• DSNDDDG2 DSNDDDXB DSNDRDSI DSNLDDG2 DSNLXXSS
  DSNLZD00 DSNLZS02 DSNLZVDA DSNXIEPL DSNXRENT DSNXROE9 DSNXROHE
  DSNXROHX DSNXROX9 DSNXRRTN HDBAA10J
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK69053

     UP11/07/08 P F107

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.