|
Problem IC70571
|
Status: Geschlossen |
CLP CANNOT EXECUTE A FILE WHICH CONTAINS CR+LF IN THE LAST OF A STATEMENT ON 9.5FP6 FOR LINUX/UNIX. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
When we execute a file including CR+LF in the last of a CLP
statement on V9.5FP6/Linux or Unix, it fails with DB21007E. It
only occurs on Fixpack6 and does not occur on FP5 or lower.
For example:
$ echo 'connect to sample;' | perl -pe 's/\012/\015\012/' >
crlf.sql
$ db2 -tvf crlf.sql
DB21007E End of file reached while reading the command. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* When user execute a clp script which contains CR at the end *
* of a line on Linux/Unix platform. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When we execute a file including CR+LF in the last of a CLP *
* statement on V9.7FP2/Linux or Unix, it fails with DB21007E. *
* It only occurs on Fixpack2 and does not occur on GA, FP1. *
* *
* For example: *
* $ echo 'connect to sample;' | perl -pe 's/\012/\015\012/' > *
* crlf.sql *
* $ db2 -tvf crlf.sql *
* DB21007E End of file reached while reading the command. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2_v97fp4 or later release. *
**************************************************************** |
| Local-Fix: |
Open file in vi(m) editor and remove CR character manually using
find and replace command. f.e. this single command could update
the file and make ready for use. :%s/^M//g
Note that here ^M is (ctrl+v+m). |
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
This issue is fixed in db2_v95fp7 and db2_v97fp4. After the
fix, user can execute clp script without any error. |
| Workaround |
Open file in vi(m) editor and remove CR character manually using
find and replace command. f.e. this single command could update
the file and make ready for use. :%s/^M//g
Note that here ^M is (ctrl+v+m). |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 14.08.2010
30.09.2010
30.09.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.7
|
 |
| 9.5.0.7
|
|
