DB2 - Problem description
Problem IT37014 | Status: Closed |
WITH FEDERATION USE OF A FLAT FILE FAILS IF THE FILE > 3GB IN SIZE ON WINDOWS | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Trying to transfer information from a Mainframe via unload files that they are then parsing via federation on Windows (they do not have direct access to the MF). We seem to have hit an issue with a file > ~ 3gb when trying to treat it as an external table via federation. The SQL statement or command failed because of a database system error. (Reason "/. ERRNO = 132".). SQLCODE=-901, SQLSTATE=58004, DRIVER=3.68.61 Looking at the trace I have the formatted SQLCA structure: 157571 data DB2 UDB oper system services sqlofica cei (3.3.15.739.2.10) pid 4176 tid 2612 cpid 5328 node 0 probe 10 bytes 144 Data1 (PD_DB2_TYPE_SQLCA,136) SQLCA: sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 40 sqlerrmc: STAT Failed on data source. ERRNO = 132 sqlerrp : SQLFFQOP sqlerrd : (1) 0x8026006D (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 58004 We did some digging (thanks Shakeb) and it appears that based on this article on the web: https://stackoverflow.com/questions/13893580/calling-stat-from-s ys-stat-h-faills-with-value-too-large-for-defined-data-typ We may need to add #define _FILE_OFFSET_BITS 64 to the vbs/engn/sqls_file/File_Portability.h to allow us to open these large files. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * 11.5.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to next release 11.5.7.0 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * 11.5.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to next release 11.5.7.0 * **************************************************************** | |
Comment | |
Fixed in Db2 v11.5.7.0 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.05.2021 11.11.2021 11.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |