IT28459: SELECT FROM PIPE VIA EXTERNAL TABLES DOES NOT WORK ON WINDOWS CLIENT

Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

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 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