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
 

 

what is automatic rebinding operation in db2

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

New User


Joined: 16 Sep 2006
Posts: 12

PostPosted: Tue Dec 05, 2006 9:24 am    Post subject: what is automatic rebinding operation in db2
Reply with quote

hello everybody,

i want to know about automatic rebinding operation in db2. please if any body has the information provide it.


regards & thanks

kumar
Back to top
View user's profile Send private message

Farooq

New User


Joined: 24 Nov 2006
Posts: 15
Location: Chennai

PostPosted: Tue Dec 05, 2006 1:08 pm    Post subject:
Reply with quote

HI,

Automatic rebinds are the internal binds the system performs when an package has been invalidated. The rebind is performed the first time that the database manager needs to execute an SQL statement from the package.
For example, packages are invalidated when you:
Drop an object, such as a table, view, or index, on which the plan is dependent
Add or drop a foreign key
Revoke object privileges on which the plan is dependent.

Thanks
Farooq
Back to top
View user's profile Send private message
Farooq

New User


Joined: 24 Nov 2006
Posts: 15
Location: Chennai

PostPosted: Tue Dec 05, 2006 1:09 pm    Post subject:
Reply with quote

HI,

Automatic rebinds are the internal binds the system performs when an package has been invalidated. The rebind is performed the first time that the database manager needs to execute an SQL statement from the package.
For example, packages are invalidated when you:
Drop an object, such as a table, view, or index, on which the plan is dependent
Add or drop a foreign key
Revoke object privileges on which the plan is dependent.

Thanks
Farooq
Back to top
View user's profile Send private message
kvskris
Currently Banned

New User


Joined: 16 Sep 2006
Posts: 12

PostPosted: Wed Dec 06, 2006 9:22 am    Post subject: Re: what is automatic rebinding operation in db2
Reply with quote

Hello Farooq,

Thank you for providing information.

regards,

kumar
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 Joinkeys operation when key1 and key2... Susanta DFSORT/ICETOOL 5 Wed Nov 02, 2016 5:35 pm
No new posts Joinkeys operation betwen VB and FB file Susanta SYNCSORT 4 Sun Sep 25, 2016 9:49 pm
No new posts how to eliminate records from operati... PUMA DFSORT/ICETOOL 5 Tue Dec 23, 2014 4:42 pm
No new posts Operation with 3 files sun_job DFSORT/ICETOOL 5 Wed Oct 15, 2014 6:46 pm
No new posts File operation sakthikumarT CICS 6 Sun Oct 12, 2014 10:03 pm


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