PQ56849: SQLCODE519 CURSOR STILL OPEN AFTER JAVA.STMT.CLOSE ISSUED FOR FIRST QUERY, DSNXERT2 -330

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE-519 CURSOR STILL OPEN AFTER JAVA.STMT.CLOSE ISSUED
  FOR FIRST QUERY, DSNXERT2 -330 in error message.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Distributed applications that have a cursor  *
  *                 with the FETCH FIRST n ROWS clause.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE519. Application receives a      *
  *                      -519 from DSNXERT2:-330.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In a distributed environment when a cursor is declared with
  the FETCH FIRST n ROWS clause, the current state of that
  cursor is not always returned to the distributed
  component of DB2. Because of this lack of information on
  cursor state, incorrect processing can occur.
  

Problem conclusion

• DB2 code was changed to report the state of the cursor back
  to the distributed component.
  

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:

  UQ62821

Modules/Macros

•    DSNXERT
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R710 PSY UQ62821

     UP02/03/01 P F202

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.