DB2 FOR LUW / DB2FORLUW / A10 - 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 Version 10.1 Fix Pack 1.                      * 
****************************************************************

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 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 10.1 Fix Pack 1.

keiner bekannt / siehe Local-Fix

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

14.06.2012
29.11.2012
29.11.2012