Fixes are available
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":"LOB45","label":"Automation"}}]
Document Information
Modified date:
28 September 2012