How to find out the affected packages if I were to drop an index ?This is a discussion on How to find out the affected packages if I were to drop an index ? within the db2-udb forums in Other Databases category; Hi, As above. TIA !... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
11-22-2007, 03:09 AM
|
 How to find out the affected packages if I were to drop an index ? Hi, As above. TIA !  |
|
#2
11-22-2007, 03:46 AM
|
| Re: How to find out the affected packages if I were to drop an index ? news:430635593.1195715384076.JavaMail.wassrvr-at-ltsg was009.sby.ibm.com... > Hi, > > As above. > > 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). |
|
#3
11-22-2007, 12:02 PM
|
| Re: How to find out the affected packages if I were to drop anindex ? Take a look at the catalog view SYSCAT.PACKAGEDEP. SELECT PKGSCHEMA, PKGNAME FROM SYSCAT.PACKAGEDEP WHERE BTYPE = 'I' AND BSCHEMA = '+INDEX_SCHEMA+' AND BNAME = '+INDEX_NAME+' should do the trick. Doug Doole DB2 Universal Database Development IBM Toronto Labs |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -4. The time now is 05:36 AM.
