When a table is created with a primary key, so a system index is created, if a new index is then built with the same criteria as the system index, Toad for DB2 v 4.0.0.880 prompts that index is created successfully. See attached screen shot. However, if user tries to list the index it would not be there. User then tried to create the same index on Quest Central for DB2 which returns the following error:
SQL0605W The index was not created because an index "SYSIBM.SQL081002102512630" with a matching definition already exists. SQLSTATE=01550
WORKAROUND:
None
STATUS
Waiting for fix in a future release of Toad for DB2.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center