|
Problem IC97885
|
Status: Closed |
SQL0206N "A.TYPERULES" NOT FOUND SHOULD NOT BLOCK DB2LOOK TO GENERATE DDLS FOR OTHER OBJECTS |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users who use db2 v10.5 fp2 and fp3 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2 v10.5 fp4 or above *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
The problem is fixed in v10.5 fp4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.11.2013
08.09.2014
08.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
