|
You can retain the next available value for AUTOINCREMENT columns in the rebuilt database by specifying the dbunload -l option. This option adds calls to the sa_reset_identity system procedure to the generated reload.sql script for each table that contains an AUTOINCREMENT value, preserving the current value of SYSTABCOL.max_identity.