|
Problem IC97811
|
Status: Closed |
SQL0206N "A.TYPERULES" NOT FOUND SHOULD NOT BLOCK DB2LOOK TO GENERATE DDLS FOR OTHER OBJECTS |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - 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 v10.1 fixpack 2 or 3 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v10.1 fixpack 4 or above *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
The problem is first fixed in v10.1 fixpack 4 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC97885
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.11.2013
02.06.2014
02.06.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.4
|
 |
