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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center