what is automatic rebinding operation in db2

kvskris · New User Joined: 16 Sep 2006 Posts: 12

hello everybody,

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

regards & thanks

kumar

Farooq · New User Joined: 24 Nov 2006 Posts: 15 Location: Chennai

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

Farooq · New User Joined: 24 Nov 2006 Posts: 15 Location: Chennai

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

kvskris · New User Joined: 16 Sep 2006 Posts: 12

Hello Farooq,

Thank you for providing information.

regards,

kumar