Fixes are available
APAR status
Closed as fixed if next.
Error description
attempting to read data form named pipe on Windows will end up with error C:\> db2 "INSERT INTO test_table (uuid, id, text) SELECT uuid,id,text FROM EXTERNAL '\\.\pipe\myPipe'(uuid VARCHAR(10), id INTEGER, text VARCHAR(50)) USING (DELIMITER ',' REMOTESOURCE YES)" DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL20569N The external table operation failed due to a problem with the corresponding data file or diagnostic files. File name: "\\.\pipe\myPipe". Reason code: "0". SQLSTATE=428IB
Local fix
DB2 Version 11.1 Fix Pack 5
Problem summary
**************************************************************** * USERS AFFECTED: * * all windows Db2 Client * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * DB2 Version 11.1 Fix Pack 5 * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IT28459
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-03-14
Closed date
2020-03-02
Last modified date
2020-03-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
RB10 PSN
UP
[{"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":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 May 2022