DB2 FOR LUW / DB2FORLUW / 970 - DB2

When running db2look, alter table commands may be missing to set
the start point for tables that contain identify columns.  A
statement such at this is missing from the generated db2look
output:

ALTER TABLE... ALTER COLUMN ... RESTART WITH #

For example,

1) Create Table
a. CREATE TABLE TEST.OTE ( ID BIGINT NOT NULL GENERATED ALWAYS
AS
IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE
9223372036854775807 NO CYCLE NO CACHE ORDER ), NR BIGINT NOT
NULL ) DATA
CAPTURE NONE COMPRESS NO
2) Insert Record
a. insert into "TEST"."OTE" ("NR") values(4711)
3) db2look
a. db2look -d sample -e -t OTE

The resulting db2look output should contain the following line:
ALTER TABLE  TEST.OTE ALTER COLUMN ID RESTART WITH 2

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 9.7 Fix Pack 6                                *
****************************************************************

Manually insert a record, then db2look will generate the restart
with ID.

not known / see Local fix

forerunner  : 
follow-up : IT20216 IT20217 

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

13.04.2017
09.05.2017
09.05.2017

9.7.FP6