|
Problem IC68796
|
Status: Closed |
DB2 CLP CAN HANG OR RETURNS AN ERROR, WHEN ONE DB2 CLP OUPUT IS PIPED INTO A SECOND DB2 CLP COMMAND |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem description: |
Shell comamnds, where the ouput from one DB2 CLP is piped into
the next DB2 CLP, can hang or return an error.
Example:
db2 -x "SQL statement" | db2 +p -tv
On AIX, this can lead to a hang of DB2 CLP.
On non AIX platforms, this can return the following error:
sh: /bin/db2bpq: No such file or directory
DB21007E End of file reached while reading the command. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* on Unix/Linux platform when user is piping output of one clp *
* command to othere clp command. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Shell comamnds, where the ouput from one DB2 CLP is piped *
* into *
* the next DB2 CLP, can hang or return an error. *
* *
* *
* *
* Example: *
* *
* db2 -x "SQL statement" | db2 +p -tv *
* *
* *
* *
* On AIX, this can lead to a hang of DB2 CLP. *
* *
* *
* *
* On non AIX platforms, this can return the following error: *
* *
* sh: /bin/db2bpq: No such file or directory *
* *
* *
* *
* DB21007E End of file reached while reading the command. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v98fp4 or later version. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
Problem was first fixed in Version 9.8 Fix Pack 4. After the
fix, issue got solved. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.05.2010
31.03.2011
31.03.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.4
|
 |
