How to find out the affected packages if I were to drop an index ?

[d***@us.ibm.com]

Hi,<br />
<br />
As above.<br />
<br />
TIA !

[Mark A]

Post by d***@us.ibm.com
Hi,<br />
<br />
As above.<br />
<br />
TIA !

Why do you care? The packages will do an auto rebind upon first execution if
the package is marked invalid (because the index is gone).

[Doug Doole]

Take a look at the catalog view SYSCAT.PACKAGEDEP.<br />
<br />
SELECT PKGSCHEMA, PKGNAME FROM SYSCAT.PACKAGEDEP WHERE<br />
BTYPE = 'I' AND BSCHEMA = '+INDEX_SCHEMA+' AND BNAME = '+INDEX_NAME+'<br />
<br />
should do the trick.<br />
<br />
<hr />
Doug Doole<br />
DB2 Universal Database Development<br />
IBM Toronto Labs