Hi All,



I'm a newbie in DB2 Z/OS Version 7 looking for info about altering an
identity column. We created a table in our prod environment using
GENERATED BY DEFAULT and having a unique index on the identity column.
We then loaded rows into the table from our QA environment. When the
client attempted to insert a row, the insert failed on a duplicate key
error. To get around this we dropped the table and recreated it with
the start field set to start at 1000 and incremented by 1. We then
loaded the rows back into the table (254 rows). When the client
inserted the row it was created with an identity id of 1000, as
expected. This obviously is not something we want to do going forward,
which leads me to my question.



We just went to Version 7 two weeks ago and migration to Version 8 is
not even on the radar yet. My question is: Is the ALTER TABLE
<table> ALTER COLUMN <id col> RESTART WITH <nextval> available in
Version 7 if we apply maintenance ?



TIA,



George


DB2 & UDB email list listserv db2-l LazyDBA home page