|
| How to find out the affected packages if I were to drop an index ? |
 |
Thu, 22 Nov 2007 02:09:13 EST |
Hi,<br />
<br />
As above.<br />
<br />
|
| Post Reply
|
| Re: How to find out the affected packages if I were to drop an index ? |
 |
Thu, 22 Nov 2007 02:46:42 -050 |
<dwforums@us.ibm.com> wrote in message
news:430635593.1195715384076.JavaMail.wassrvr@ltsgwas009.sby.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).
|
| Post Reply
|
| Re: How to find out the affected packages if I were to drop an |
 |
Thu, 22 Nov 2007 11:02:53 EST |
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 />
|
| Post Reply
|
|
|
|
|
|
|
|
|
|