Fixes are available
DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
Importing BLOBs on Windows can result in SQL0901N, or SQL0452N, or "CORRELATION IDENTIFIER OVERFLOW", or SQLJC_ERROR_ICE errors. This is caused by a defect in the sqlochgfileptr() function when seeking in a file above 2 GB boundary (but below 4 GB). This is Windows specific problem and a db2 trace would show error ERROR_NEGATIVE_SEEK (131): ---------------------------------------------------------------- 252586 data DB2 UDB oper system services sqlochgfileptr cei (3.3.15.660.2.1) pid 6216 tid 8140 cpid 7 node 0 probe 1 bytes 40 Data1 (PD_TYPE_DEFAULT,4) Hexdump: 2C02 0000 ,... Data2 (PD_TYPE_DEFAULT,8) Hexdump: 8E29 6280 0000 0000 .)b..... Data3 (PD_TYPE_DEFAULT,4) Hexdump: 0000 0000 .... ... 252596 errtrans DB2 UDB oper system services sqlochgfileptr cei (13.3.15.660.2.100) pid 6216 tid 8140 cpid 7 node 0 probe 100 Error Translation Original Error OSERRNO = 131 => ERROR_NEGATIVE_SEEK New Error ZRC = 0x860F0006 = -2045837306 = SQLO_DSEK ---------------------------------------------------------------- This problem can be identified by errors SQL0901N and SQLJC_ERROR_ICE in the db2diag.log: ---------------------------------------------------------------- 2008-07-30-21.52.15.828000+330 I79322H497 LEVEL: Warning PID : 228 TID : 3764 PROC : db2move.exe INSTANCE: DB2 NODE : 000 APPID : *LOCAL.DB2.080730154635 EDUID : 3764 FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcBeginDss, probe:100 MESSAGE : ZRC=0x82360001=-2110390271=SQLJC_ERROR_ICE "SYSTEM ERROR" DIA8532C An internal processing error has occurred. DATA #1 : String, 32 bytes Correlation Identifier overflow. ---------------------------------------------------------------- Another sign of hitting this APAR is db2move failure to import large BLOBs due to error SQL0452N: SQL0452N Unable to access the file referenced by host variable "8". Reason code: "5". SQLSTATE=428A1
Local fix
Problem summary
USERS AFFECTED: The DB2 users on Windows platform PROBLEM DESCRIPTION: Importing BLOBs on Windows can result in SQL0901N, or SQL0452N, or "CORRELATION IDENTIFIER OVERFLOW", or SQLJC_ERROR_ICE errors. PROBLEM SUMMARY: The problem is caused by a defect in the sqlochgfileptr() function when seeking in a file above 2 GB boundary (but below 4 GB). This is Windows specific problem and a db2 trace would show error ERROR_NEGATIVE_SEEK (131): ---------------------------------------------------------------- 252586 data DB2 UDB oper system services sqlochgfileptr cei (3.3.15.660.2.1) pid 6216 tid 8140 cpid 7 node 0 probe 1 bytes 40 Data1 (PD_TYPE_DEFAULT,4) Hexdump: 2C02 0000 ,... Data2 (PD_TYPE_DEFAULT,8) Hexdump: 8E29 6280 0000 0000 .)b..... Data3 (PD_TYPE_DEFAULT,4) Hexdump: 0000 0000 .... ... 252596 errtrans DB2 UDB oper system services sqlochgfileptr cei (13.3.15.660.2.100) pid 6216 tid 8140 cpid 7 node 0 probe 100 Error Translation Original Error OSERRNO = 131 => ERROR_NEGATIVE_SEEK New Error ZRC = 0x860F0006 = -2045837306 = SQLO_DSEK ---------------------------------------------------------------- This problem can be identified by errors SQL0901N and SQLJC_ERROR_ICE in the db2diag.log: ---------------------------------------------------------------- 2008-07-30-21.52.15.828000+330 I79322H497 LEVEL: Warning PID : 228 TID : 3764 PROC : db2move.exe INSTANCE: DB2 NODE : 000 APPID : *LOCAL.DB2.080730154635 EDUID : 3764 FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcBeginDss, probe:100 MESSAGE : ZRC=0x82360001=-2110390271=SQLJC_ERROR_ICE "SYSTEM ERROR" DIA8532C An internal processing error has occurred. DATA #1 : String, 32 bytes Correlation Identifier overflow. ---------------------------------------------------------------- Another sign of hitting this APAR is db2move failure to import large BLOBs due to error SQL0452N: SQL0452N Unable to access the file referenced by host variable "8". Reason code: "5". SQLSTATE=428A1
Problem conclusion
First fixed in DB2 UDB Version 9.5, FixPak 3 (s081118).
Temporary fix
Comments
APAR Information
APAR number
JR30345
Reported component name
DB2 UDB EXE WIN
Reported component ID
5724E4901
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-08-27
Closed date
2009-03-09
Last modified date
2009-03-09
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
DB2 UDB EXE WIN
Fixed component ID
5724E4901
Applicable component levels
R810 PSN
UP
R820 PSN
UP
R910 PSN
UP
R950 PSN
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950"}]
Document Information
Modified date:
07 October 2021