IBM Support

IC76559: BFGDB0003E EXCEPTION OCCURS WHEN RUNNING WMQ FTE 7.0.3 DATABASE LOGGER AGAINST DB2 ON Z/OS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • BFGDB0003E exception is seen when running the WMQ FTE database
    logger against DB2 z/OS when using DB2 Connect:
    
    BFGDB0003E: A problem occurred with the database. The database
    driver reported the following details: SQL State ■42704, Error
    Code ■-204,
    Message ■DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704,
    SQLERRMC=FTELOG.CALL, DRIVER=3.61.75
    ■com.ibm.wmqfte.databaselogger.exceptions.DataStoreException
    

Local fix

Problem summary

  • When the IBM WebSphere MQ File Transfer Edition standalone
    database logger uses DB2 Connect to connect to DB2 on z/OS, the
    currentSchema is not flown to the DB2 server due to a limitation
    of DB2 Connect when WebSphere MQ Server is used as the
    transaction coordinator.
    
    USERS AFFECTED:
    All users of the standalone database logger connecting to DB2 on
    z/OS.
    
    PLATFORMS AFFECTED:
    All except z/OS
    

Problem conclusion

  • The code has been modified to flow the currentSchema setting on
    each transaction when the database logger is running on a
    non z/OS platform and the database being used is DB2 z/OS.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76559

  • Reported component name

    WMQ FILE TRANSF

  • Reported component ID

    5724R1000

  • Reported release

    703

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-23

  • Closed date

    2011-06-30

  • Last modified date

    2011-06-30

  • 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 FILE TRANSF

  • Fixed component ID

    5724R1000

Applicable component levels

  • R703 PSY

       UP

  • R704 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEP7X","label":"WebSphere MQ File Transfer Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0.2","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
30 June 2011