DB2 FOR LUW / DB2FORLUW / 970 - DB2

Db2look utility does not generate column options for typed 
tables. 
 
Example: 
$ db2 CONNECT TO SAMPLE 
$ db2 "CREATE TYPE Person_t AS (Name VARCHAR(20), Age INTEGER) 
REF USING INTEGER MODE DB2SQL" 
$ db2 "CREATE TABLE PERSON OF Person_t (REF IS Oid USER 
GENERATED, Name WITH OPTIONS NOT NULL)" 
$ db2look -d SAMPLE -t PERSON -e 
[...] 
------------------------------------------------ 
-- DDL Statements for Table "DB2INST1"."PERSON" 
------------------------------------------------ 
 
CREATE TABLE "DB2INST1"."PERSON" OF "DB2INST1"."PERSON_T" 
 (REF IS "OID" USER GENERATED) 
 IN "USERSPACE1" ; 
[...] 
 
"Name WITH OPTIONS NOT NULL" clause has not been generated.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 Fix Pack 9.                       * 
****************************************************************

Adjust generated DDL manually

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 9.

keiner bekannt / siehe Local-Fix

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

25.09.2013
16.12.2013
16.12.2013

9.7.FP9