|
Problem IC66277
|
Status: Geschlossen |
SQL3003C WHEN WORKING WITH NAMED PIPES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error description *
****************************************************************
* RECOMMENDATION: *
* Update to DB2 UDB LUW V9.1 FP10. *
**************************************************************** |
| Local-Fix: |
n/a |
| verfügbare FixPacks: |
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
|
| Lösung |
Update to DB2 UDB LUW V9.1 FP10. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 15.02.2010
14.06.2011
14.06.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP10
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.10
|
 |
