When I perform an alter table that requires the table to be dropped and recreated, the identity column on the table does not have a reset command run for it during the recreation.
Waiting for fix to be released in a future version of Toad for DB2.
This issue only seems to occur when Generate parameter is set to "By Default", instead of "Always".
This issue is fixed in the beta version of Toad for DB2 5.1. You can download the beta at...