DB2 FOR LUW / DB2FORLUW / A10 - DB2

In v10.1fp2, db2 introduced another column TYPERULES in 
SYSCAT.DATATYPES by a new feature "Weak type support". db2look 
was accordingly changed to pick up this new column then generate 
 new clause in DDL. However, if the database was created in 
older-version instance, db2look will fail with SQL0206N 
"A.TYPERULES" not found. This "A.TYPERULES" is used to generate 
CREATE TYPE DDLs, it should not affect db2look to generate DDLs 
of other objects such as tables, routines, etc.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use v10.1 fixpack 2 or 3                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v10.1 fixpack 4 or above                      * 
****************************************************************

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

The problem is first fixed in v10.1 fixpack 4

keiner bekannt / siehe Local-Fix

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

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

20.11.2013
02.06.2014
02.06.2014