IBM Support

PI67646: BFGDB0003E: A PROBLEM OCCURRED WITH THE DATABASE. DB2 ENGINE SQLERROR, SQLCODE = -904, SQLSTATE = 57011

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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

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":"BU048","label":"IBM Software"},"Product":{"code":"SSCPQ63","label":"APAR \/ Maintenance"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"704","Edition":"","Line of Business":{"code":"","label":""}},{"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:
10 March 2017