Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 788
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: 788
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 SYSIBM Catlog tables to see DDL chang... rakesh17684 DB2 0 Fri Jun 08, 2018 3:43 am
No new posts INVALID RECFM FOR DDNAME SYSLIN AND C... sandeep kumar302 All Other Mainframe Topics 7 Fri Apr 27, 2018 6:07 pm
No new posts Invalid XML character while producing... nikhil.bhole IBM Tools 4 Tue Mar 20, 2018 1:24 am
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts ERM-Diagram of SysIBM-Catalog-Tables Auryn DB2 2 Fri Feb 17, 2017 6:22 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us