DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

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

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

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

This issue is fixed in db2_v95fp7 and db2_v97fp4. After the 
fix, user can execute clp script without any error.

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

Vorgänger  : APAR is sysrouted TO one or more of the following: IC70571 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

02.08.2010
30.09.2010
30.09.2010