Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as program error.
Error description
A client Load might fail if loading to a remote (different box) Multinode System with Nodes on the same box with the following errors: SQL3109N The utility is beginning to load data from file "/u/r1dw/andchur/db23c827/R1DW.EQTY_MKT_RISK_USD_05_07/000/NYTD_ R1DW_HI". SQL3500W The utility is beginning the "LOAD" phase at time "01/03/2008 12:28:05.306016". SQL0980C A disk error occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005 db2diag.log will show entries like: 2008-01-03-12.28.05.314153-300 E117432E624 LEVEL: Warning (OS) PID : 8579 TID : 183041513728PROC : db2lfrm0 1 INSTANCE: nyqxt110 NODE : 001 APPHDL : 1-1478 APPID: *N0.nyqxt110.080103172805 AUTHID : ANDCHUR FUNCTION: DB2 UDB, oper system services, sqlochdir, probe:100 MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found." DIA8411C A file "" could not be found. CALLED : OS, -, unspecified_system_function OSERR: ENOENT (2) DATA #1 : File name, 86 bytes /a/nyn19f3/vol/nyn19f3v3/r_ied_r1dw/r1dw/andchur/db23c827/R1DW.E QTY_MKT_RISK_USD_05_07 2008-01-03-12.28.05.315023-300 I118057E541 LEVEL: Error PID : 8579 TID : 183041513728PROC : db2lfrm0 1 INSTANCE: nyqxt110 NODE : 001 APPHDL : 1-1478 APPID: *N0.nyqxt110.080103172805 AUTHID : ANDCHUR FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 DATA #1 : String, 197 bytes LOADID: 30707.2008-01-03-12.28.04.703962.1 (6;17) /a/nyn19f3/vol/nyn19f3v3/r_ied_r1dw/r1dw/andchur/db23c827/R1DW.E QTY_MKT_RISK_USD_05_07 , -2045837302, (nil), Detected in file:sqluldat.C, Line:4501
Local fix
Problem summary
Users affected: ALL Problem description:CLIENT LOAD FAILS WITH SQL0980C "A DISK ERROR OCCURRED" CONNECTING TO REMOTE MULTINODE SYSTEM WITH NODES ON SAME BOX. Problem Summary: ERROR DESCRIPTION: A client Load might fail if loading to a remote (different box) Multinode System with Nodes on the same box with the following errors: SQL3109N The utility is beginning to load data from file "/u/r1dw/andchur/db23c827/R1DW.EQTY_MKT_RISK_USD_05_07/000/NYTD R1DW_HI". SQL3500W The utility is beginning the "LOAD" phase at time "01/03/2008 12:28:05.306016". SQL0980C A disk error occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005 db2diag.log will show entries like: 2008-01-03-12.28.05.314153-300 E117432E624 LEVEL: Warning (OS) PID : 8579 TID : 183041513728PROC : db2lfrm0 1 INSTANCE: nyqxt110 NODE : 001 APPHDL : 1-1478 APPID: *N0.nyqxt110.080103172805 AUTHID : ANDCHUR FUNCTION: DB2 UDB, oper system services, sqlochdir, probe:100 MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found." DIA8411C A file "" could not be found. CALLED : OS, -, unspecified_system_function OSERR: ENOENT (2) DATA #1 : File name, 86 bytes /a/nyn19f3/vol/nyn19f3v3/r_ied_r1dw/r1dw/andchur/db23c827/R1DW.E QTY_MKT_RISK_USD_05_07 2008-01-03-12.28.05.315023-300 I118057E541 LEVEL: Error PID : 8579 TID : 183041513728PROC : db2lfrm0 1 INSTANCE: nyqxt110 NODE : 001 APPHDL : 1-1478 APPID: *N0.nyqxt110.080103172805 AUTHID : ANDCHUR FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 DATA #1 : String, 197 bytes LOADID: 30707.2008-01-03-12.28.04.703962.1 (6;17) /a/nyn19f3/vol/nyn19f3v3/r_ied_r1dw/r1dw/andchur/db23c827/R1DW.E QTY_MKT_RISK_USD_05_07 , -2045837302, (nil), Detected in file:sqluldat.C, Line:4501
Problem conclusion
First fixed in DB2 UDB Version 9.1, Fixpak 5
Temporary fix
Comments
APAR Information
APAR number
LI73041
Reported component name
DB2 UDE ESE LIN
Reported component ID
5765F4104
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-01-15
Closed date
2008-07-07
Last modified date
2008-07-07
APAR is sysrouted FROM one or more of the following:
LI73032
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 UDE ESE LIN
Fixed component ID
5765F4104
Applicable component levels
R910 PSY
UP
Document Information
Modified date:
15 October 2021