Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

When does a package becomes INVALID in the sysibm.syspackage

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rahuindo

New User


Joined: 09 Apr 2008
Posts: 83
Location: Chennai

PostPosted: Tue Feb 10, 2009 12:25 pm    Post subject: When does a package becomes INVALID in the sysibm.syspackage
Reply with quote

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
View user's profile Send private message

Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 785
Location: Chennai, India

PostPosted: Tue Feb 10, 2009 1:53 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 785
Location: Chennai, India

PostPosted: Tue Feb 10, 2009 1:59 pm    Post subject:
Reply with quote

Here it is,

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.admin/db2z_invalidinoperativeplanpackage.htm
Back to top
View user's profile Send private message
rahuindo

New User


Joined: 09 Apr 2008
Posts: 83
Location: Chennai

PostPosted: Tue Feb 10, 2009 2:07 pm    Post subject: Reply to: When does a package becomes INVALID in the sysibm.
Reply with quote

Thanks a lot..that was quite informative.. icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts INVALID FIELD OR CONSTANT IN SORTOF ?? Ron Klop DFSORT/ICETOOL 8 Wed Jan 11, 2017 3:44 pm
No new posts JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts IEF645I INVALID REFERBACK IN THE RC ... abdulrafi JCL & VSAM 2 Mon Aug 29, 2016 10:57 am
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts Invalid frequency code, dataset descr... Bhanu Praveen JCL & VSAM 4 Fri Feb 05, 2016 10:43 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us