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
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center