When altering a SMS tablespace to add new data files, the tablespace has to be recreated. If the tablespace contains tables with both identity and without identity and Preserve Data Method set to "Use Temporary tables" and these tables are included in the steps of temporary tables, then these tables will fail to create.
These tables should be dropped and then recreated since their data is preserved using utilities and no temporary tables are needed.
WORKAROUND:
Set 'Preserve Data Method' to 'Use commands/utilities' in Options | Database | DB2 | Advanced Admin.
STATUS:
Waiting for fix in a future release of Toad for DB2.
