Enhancement request: modify a system-required index

Toad for IBM DB2
1

Currently, Toad doesn’t allow an index used by a primary key constraint to be modified. I’d like to be able to change things like clustering, %free, allow reverse scans on a PK index. Toad would need to drop the PK constraint, drop the index, rebuild the index with changes, and re-add the PK.

Thanks.
Jim Frentress
Principal Financial Group

2

Hello Jim,

I have opened enhancement request 73,390 for you regarding your suggestion for
Toad for DB2 functionality.

Thanks,

randall