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 number
IT01902
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B70
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-05-20
Closed date
2017-06-10
Last modified date
2017-06-10
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
10 June 2017