Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC66277 Status: Closed

SQL3003C WHEN WORKING WITH NAMED PIPES

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
The following error message can occur when working with 
named pipes: 
 
SQL3003C  An I/O error occurred while closing the output data 
file. 
 
Example: 
 
db2 connect to sample 
mkfifo np 
gzip -1 < np > EXPORT_FILE & 
db2 "export to np of ixf select * from org" 
 
The export works, but returns: 
 
SQL3104N  The Export utility is beginning to export data to file 
"np". 
SQL3003C  An I/O error occurred while closing the output data 
file. 
SQL3105N  The Export utility has finished exporting "8" rows. 
 
db2diag.log shows: 
 
2010-02-08-10.59.53.221907-300 E2174E471           LEVEL: Severe 
(OS) 
PID     : 15622                TID  : 182971811808 PROC : db2bp 
INSTANCE: dbxxxxxx             NODE : 000 
APPID   : *LOCAL.dbguest7.100208155917 
FUNCTION: DB2 UDB, oper system services, sqloclose, probe:10 
CALLED  : OS, -, fsync                            OSERR: EINVAL 
(22) 
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes 
0x0000007FBFFFDB08 : 0400 0000 8000 0000 
........ 
 
The error is cosmetic and can be ignored.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 UDB LUW V9.1 FP10.                             * 
****************************************************************
Local Fix:
n/a
available fix packs:
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

Solution
Update to DB2 UDB LUW V9.1 FP10.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.02.2010
14.06.2011
14.06.2011
Problem solved at the following versions (IBM BugInfos)
9.1.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.10 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.