var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2MOVE Urgent!!!!!!!!!
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.
Alter sequence <sequence_name> restart with <numeric_constant>
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).
I would like to know is any facility there in DB2MOVE to get exact same sequece from source db
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.