DB2 FOR LUW / DB2FORLUW / B10 - DB2

DDL for sequence (db2look.mimic_sequence.sql)

CREATE SEQUENCE "MYSEQ" AS BIGINT
        MINVALUE 100000000000000000 MAXVALUE 199999999999999999
        START WITH 100000000000000000 INCREMENT BY 1
        NO CACHE CYCLE NO ORDER;

ALTER SEQUENCE "MYSEQ" RESTART WITH
100000000000522496;



Steps to reproduce this problem :

db2 "ALTER SEQUENCE "MYSEQ" RESTART WITH
10000000000555555"

$ db2look -d sample -e | grep 'ALTER SEQUENCE'
..
ALTER SEQUENCE  "MYSEQ" RESTART WITH
10000000000555556;
---
$ db2 "ALTER SEQUENCE "MYSEQ" RESTART WITH
10000000000333333"


$ db2look -d sample -e | grep 'ALTER SEQUENCE'

ALTER SEQUENCE "MYSEQ" RESTART WITH
10000000000333332;
..

Db2look is not handling DECIMAL(31,0) datatype properly. When
the sequence is too large, calculations are done incorrectly,
and precision is lost.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
****************************************************************

Use sequences up to 15 digits max.

not known / see Local fix

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

06.02.2019
16.01.2020
16.01.2020