IBM Support

IC86215: WMQFTE 7.0.4: DATABASE LOGGER REPORTS BFGDB0003E: A PROBLEM OCCURRED WITH THE DATABASE. SQL STATE 42815 AND ERRORCODE -4

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Using WebSphere MQ File Transfer Edition version 7.0.4 the
    Database Logger reports the following error coming from the
    JDBC driver:
    
    BFGDB0003E: A problem occurred with the database. The database
    driver reported the following details: SQL State [42815], Error
    Code [-4461], Message [[jcc][10177][11618][3.64.82] Invalid
    data conversion: Requested conversion would result in a loss of
    precision of 14315410149. ERRORCODE=-4461, SQLSTATE=42815]
    
    The DB2 SQL errorcode -4461 means "the specified value
    is invalid or out of range."
    

Local fix

  • None <br/>
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users of WebSphere MQ File Transfer Edition Version 7.0.4
    database logger with DB2 database on z/OS.
    
    
    Platforms affected:
    MultiPlatform
    
    ****************************************************************
    PROBLEM SUMMARY:
    BIGINT support is not available on DB2 8.1 on z/OS so the DB2 on
    z/OS schema uses INT in place of BIGINT. Some columns might need
    to hold integers larger than INT.
    
    For example, when attempting to transfer a file larger than 2
    Gigabytes, the TRANSFER_ITEM.SOURCE_FILE_SIZE column entry
    cannot contain the file size.
    

Problem conclusion

  • This APAR introduces two new .sql files:
    
    ftelog_tables_zos_bigint.sql - can be used to create a schema
    for DB2 on z/OS that uses BIGINT where appropriate.
    
    ftelog_tables_zos_bigint_int-bigint.sql - can be used to migrate
    data from an existing INT schema to the new BIGINT schema.
    
    The new schema avoids problems when certain fields are
    required to be larger than INT.
    
    ---------------------------------------------------------------
    The fix is targeted for delivery in the following PTFs:
    
    Platform           v7.5
    --------           --------------------
    Multiplatforms     7.5.0.1
    
    Platform           v7.0
    --------           --------------------
    Multiplatforms     7.0.4.3
    
    The latest available 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

    IC86215

  • Reported component name

    WMQ FILE TRANSF

  • Reported component ID

    5724R1000

  • Reported release

    704

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-08-29

  • Closed date

    2012-09-28

  • Last modified date

    2012-09-28

  • 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

  • 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.4","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
28 September 2012