We are using db2 UDB version 8.2 on Linux.

Can anyone tell me where the next value for an identity column is held? I can't find it anywhere in the catalog. There are a lot of fields that are related to it but I cannot find where the value is kept.

Thanks in advance
Bob.

The next value isnot stored in any catalog. It is in the table definition itself from where you have to decide the last value of the identity column and what would be its next increment.

Like : in the DDL>
"col1" integer generated always as identity (start with 100 increment by 1)

In V7 look at MAXASSIGNEDVALUE in the SYSSEQUENCES table. I am not sure if it's the same for V8 but you might check it out.

In v8 the column name is LASTASSIGNEDVAL.

Caution that this is the last value cached, not neccessarily assigned... name is a little misleading.

jono

Thanks for the info, I was looking in the worng place. It's not part of the syscat.syssequences view.

I'm not going to use it for anything, I just wanted to know where it was. I knew it had to be somewhere.

Thanks again.