|
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) |
