APAR status
Closed as program error.
Error description
The customer reported: BFGDB0003E: A problem occurred with the database. The database driver reported the following details: SQL State: 57011, Error Code:-904, Message: jcc 50053 12311 3.67.49 T2zOS exception: jcc:T2zos:T2zosPreparedStatement.readOpenQueryInternal: nativeOpen:8 542: DB2 engine SQL error, SQLCODE = -904, SQLSTATE = 57011, error tokens = 00E70082;3002; NUMBER OF CURSORS ERRORCODE=-904, SQLSTATE =57011 ... 0E70082 : The user has reached the maximum number of outstanding storedprocedures or opened cursors for the current thread. . The MAX_NUM_CUR subsystem parameter specifies the maximum number of cursors, including allocated cursors, that can be open at a given DB2 site for each thread. . Additional Symptom(s) Search Keyword(s):
Local fix
Problem summary
**************************************************************** USERS AFFECTED: All users of the Database Logger component in: - IBM WebSphere MQ File Transfer Edition 7.0.4 - IBM WebSphere MQ 7.5 Platforms affected: MultiPlatform **************************************************************** PROBLEM DESCRIPTION: SQL Statement objects created during the normal processing of the Database Logger were not closed until the connection to the database was closed, either under controlled conditions via shutdown or temporary connection loss. This caused a resource leak in the database, which eventually caused the database to issue an error indicating the connection had tried to open more than the maximum number of statements.
Problem conclusion
The code has been altered to ensure that SQL Statement objects are periodically closed, thereby preventing the resource leak. --------------------------------------------------------------- The fix is targeted for delivery in the following PTFs: Version Maintenance Level v7.0 7.0.4.7 v7.5 7.5.0.8 The latest available FTE maintenance can be obtained from 'Fix List for WebSphere MQ File Transfer Edition 7.0' http://www-01.ibm.com/support/docview.wss?uid=swg27015313 The latest available MQ maintenance can be obtained from 'WebSphere MQ Recommended Fixes' http://www-1.ibm.com/support/docview.wss?rs=171&uid=swg27006037 If the maintenance level is not yet available information on its planned availability can be found in 'WebSphere MQ Planned Maintenance Release Dates' http://www-1.ibm.com/support/docview.wss?rs=171&uid=swg27006309 ---------------------------------------------------------------
Temporary fix
Comments
APAR Information
APAR number
PI67646
Reported component name
WMQ FTE Z/OS
Reported component ID
5655U8000
Reported release
704
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-08-16
Closed date
2016-10-21
Last modified date
2017-03-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WMQ FTE Z/OS
Fixed component ID
5655U8000
Applicable component levels
R704 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDEZSF","label":"IBM WebSphere MQ Managed File Transfer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"704","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"704","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
31 March 2023