But db2rbind recompiles only Packages. It does not affect the Views and
Stored Procedures.

Am I missing something here?



>From: "Singh Rahul "
><db2udbdba-ezmlmshield-x8476152.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: RE: Recompile inoperative Views or Stored Procedures....
>Date: Wed, 28 Mar 2007 00:52:18 -0400
>
>This can be achieved by rebinding your database
>Look for db2rbind
>
>-----Original Message-----
>From: vedant k7 [mailto:db2udbdba-ezmlmshield-x22759237.[Email address
>protected]
>Sent: Wednesday, March 28, 2007 8:53 AM
>To: LazyDBA Discussion
>Subject: Recompile inoperative Views or Stored Procedures....
>
>When I make table changes, I always re-create dependent Views and Stored
>Procedures.
>
>Is there a way to Recompile the Views that are inoperative?? And how do I
>do
>the same for Stored Procedures??
>
>
>Thanks,
>
>Surendar.
>
>_________________________________________________________________
>Tried the new MSN Messenger? It's cool! Download now.
>http://messenger.msn.com/Download/Default.aspx?mkt=en-in
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>

_________________________________________________________________
Post ads for free. On new MSN Classifieds.
http://www.yello.in/home.php?utm_source=hotmailtag&utm_medium=textlink&utm_content=in&utm_campaign=intro


DB2 & UDB email list listserv db2-l LazyDBA home page