Hi,

Please help me.

Using db2move I moved my DB from AIX to NT, everything ok, but sequences are automatically set to 1. How I can set the same sequence value as AIX DB.

Allian

Alter sequence <sequence_name> restart with <numeric_constant>

regards

Mujeeb

If they are IDENTITY columns you can use:

ALTER table mytable alter column identCol restart with X
(where X is the next value that you AIX system would generate).

HTH

Andy

Hi,

I would like to know is any facility there in DB2MOVE to get exact same sequece from source db


allian

did you ever figure out how to set these sequences automatically. I have 100s of tables. If I have to go through them one at a time it would be a very long week.

under windows, you can use the following command to generate the alter statements required to restart the identity columns with their proper value...

db2look -z schema -d dbname -e -nofed | find /i "restart with" > restart.sql

the file restart.sql will contain the alter statements.