DB2 FOR LUW / DB2FORLUW / 950 - DB2

On linux, when the select clause in import command exceeds 64k 
or more, the command may fail with -3009 error. 
 
For example: 
When the below test script is executed: 
 
db2 "create db xmldb using CODESET utf-8 TERRITORY us" 
db2 connect to xmldb 
db2 "CREATE TABLE longstmtsel( column000000000001 
VARCHAR(25),column000000000002 VARCHAR(25) )" 
db2 "INSERT INTO longstmtsel VALUES('select', 'select 
validated')" 
db2 -tvf test.clp 
 
 
cat test.clp: 
UPDATE COMMAND OPTIONS USING s OFF; 
UPDATE COMMAND OPTIONS USING c OFF; 
UPDATE DB CFG FOR XMLDB USING APPLHEAPSZ 1000 STMTHEAP 524288; 
 
!db2 -tvf 64kexport.clp; 
 
Export may return the error: 
SQL3009N  The Action String parameter is not valid or too long. 
 
File 64kexport.clp contains an import command with select clause 
exceeding 64k in size.

**************************************************************** 
* USERS AFFECTED:                                              * 
* clp users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* export command fails on linux when the select stmt exceeds   * 
* 64K                                                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.5 FP9 or higher                             * 
****************************************************************

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem Fixed in DB2 Version 9.5 Fix Pack 9

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC80300 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

12.10.2011
30.03.2012
30.03.2012

9.5.FP9