DB2 FOR LUW / DB2FORLUW / 970 - DB2

db2look -d <dbname> -e -o ddl.sql does not extract all objects 
of the database in question and fails with the following 
message: 
 
SQL0304N  A value cannot be assigned to a host variable because 
the value is not within the range of the host variable's data 
type. SQLSTATE=22003 
 
This happens, when SECPOLICYID in SYSCAT.SECURITYPOLICIES 
contains values larger than 32766.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See error description above.                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 5.                       * 
****************************************************************

Drop all the SECURITY POLICYs with a SECPOLICYID larger than 
32766.

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
 

First fixed in DB2 Version 9.7 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

07.07.2011
27.12.2011
27.12.2011

9.7.FP5