View previous topic :: View next topic
|
Author |
Message |
rahuindo
New User
Joined: 09 Apr 2008 Posts: 83 Location: Chennai
|
|
|
|
Hi,
I wanted to know when does a package becomes INVALID (VALID='N') and Inoperative (OPERATIVE='N') in the sysibm.syspackage table? |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
When a privilege that is required by a plan or package is revoked, the plan or package is invalidated.
If an index is dropped that is used by a package, that is marked as invalid.
When an invalid package is executed, DB2 does an automatic rebind so that DB2 can determine a new access path. If the rebind fails (for example, if a referenced table, view or column is missing) the package is marked as inoperative. |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
Back to top |
|
|
rahuindo
New User
Joined: 09 Apr 2008 Posts: 83 Location: Chennai
|
|
|
|
Thanks a lot..that was quite informative.. |
|
Back to top |
|
|
|