|
Problem IC97885
|
Status: Geschlossen |
SQL0206N "A.TYPERULES" NOT FOUND SHOULD NOT BLOCK DB2LOOK TO GENERATE DDLS FOR OTHER OBJECTS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
The problem is fixed in v10.5 fp4 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 22.11.2013
08.09.2014
08.09.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.4
|
 |
