IT01902: ENGINE CAN RETURN -259 ERROR ON FETCH OF CURSOR WITH HOLD IF AUTO_REPREPARE IS ENABLED AND STATEMENT GETS REPREPARED

APAR status

• Closed as fixed if next.

Error description

• In the client application, if you've declared a cursor with hold
  and AUTO_REPREPARE is enabled.  If the server reprepares the
  statement for that cursor, if the application then fetches rows,
  and begins and commits or rollback 1 or more transactions, when
  the application goes to fetch on that cursor again, it will
  return a -259 error, as when the statement is reprepared, the
  server is losing the with hold declaration of the cursor.  So
  when the transactions commit/rollback, the cursor is getting
  closed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * users using HOLD cursors with AUTO_REPREPARE                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.70.xC9 or earlier PID if available.            *
  ****************************************************************
  

Problem conclusion

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:

Fix information

Applicable component levels

• RB70 PSN

     UP

• RB70 PSY

     UP