DB2 FOR LUW / DB2FORLUW / A50 - 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 version 10.5 fix pack 9                       * 
****************************************************************

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

First fixed in db2 version 10.5 fix pack 9

See local fix

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

13.04.2017
27.09.2017
27.09.2017

9.0.