DB2 FOR LUW / DB2FORLUW / A10 - 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 10.1 and Fix Pack 4 or higher.        * 
****************************************************************

Adjust generated DDL manually

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

Problem was first fixed in DB2 version 10.1 and Fix Pack 4.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

08.10.2013
02.06.2014
02.06.2014