DB2 FOR LUW / DB2FORLUW / 970 - DB2

If 'ALTER SEQUENCE <sequence name> RESTART WITH <value>' 
statement was issued for the sequence then db2look utility does 
not generate 'ALTER SEQUENCE <sequence name> RESTART WITH 
<value>' statement for that sequence if the next sequence was 
not retrieved by 'NEXT VALUE FOR <sequence name>' statement 
since sequence was altered.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.7 FixPack 6.                    * 
****************************************************************

Retrieve value from the sequence with 'NEXT VALUE FOR <sequence 
name>' before using db2look if sequence was altered with 'ALTER 
SEQUENCE <sequence name> RESTART WITH <value>' statement.

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 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
 

Problem was first fixed in DB2 UDB Version 9.7 FixPack 6.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC84522 
follow-up : 

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

04.08.2011
06.06.2012
06.06.2012

9.7.FP6