DB2 FOR LUW / DB2FORLUW / 970 - DB2

If you attempt to use the Import or Export utilities from a 
DB2 LUW 9.5 client to a DB2 on z/OS, DB2 on VSE, DB2 on VM, or 
DB2 on iSeries server you may encounter a SQL2019N. 
 
Prior to v95, binding the list file ddcsmvs.lst, ddcsvse.lst, 
ddcsvm.lst or ddcs400.lst  was sufficient 
to use these utilities from a DB2 LUW client to a DB2 on z/OS, 
DB2 on VSE, DB2 on VM or DB2 on iSeries server respectively. 
 
However in V95 a new package named db2uiDescribe.bnd 
was introduced in Import & Export. This package was correctly 
added to db2ubind.lst (for DB2 LUW servers), but not to 
ddcsmvs.lst (for DB2 on z/OS servers), or to ddcsvse.lst (for 
DB2 on VSE servers), or to ddcsvm.lst (for DB2 on VM servers), 
or to ddcs400.lst (for DB2 on iSeries servers). 
 
The APAR fix involves adding db2uiDescribe.bnd to the 
ddcsmvs.lst, ddcsvse.lst, ddcsvm.lst, and ddcs400.lst list 
files.

IMPORT & EXPORT FROM DB2 LUW CLIENT TO DB2 Z/OS SERVER OR OTHER 
HOST SERVERS RETURNS SQL2019N BECAUSE PACKAGE NOT BOUND

You can manually bind db2uiDescribe.bnd.

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 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 9a 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 10 for Linux, UNIX, and Windows
 

First Fixed in DB2 Version 9.7 Fix Pack 1

The workaround is to manually bind the db2uiDescribe.bnd file to 
the database. 
 
Example: 
This example illustrates how to bind the db2uiDescribe.bnd file 
contained in the db2inst1 instance to the sample database when 
logged in as the instance owner. 
 
cd \db2inst1\sqllib\bnd 
db2 terminate 
db2 CONNECT TO sample 
db2 bind db2uiDescribe.bnd BLOCKING ALL GRANT PUBLIC ACTION ADD 
db2 terminate

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

22.10.2009
15.12.2009
08.10.2010

9.7.FP1