Bundling a bundle in the IBM DB2 database

Rebind is the process of regenerating a package (Package) for an application that has previously been bound to the database. When the application's corresponding package is marked as Invalid or not operable (inoperative), the user must rebind it. In some cases, the package is still legal, but the user will also be able to rebind the package to improve the performance of the program, such as using the new index, or using the new system to optimize the data after the Runstats command has been run.

If the application's package relies on some data objects, such as tables, triggers, and so on. When these data objects are deleted, the package will be set to Invalid. An illegal package is automatically executed by the database manager the next time it is executed. The user must be aware that if the system fails to perform the binding automatically, the program will be executed with unexpected errors. At this point, the program's statements may not be correct, and the error is caused by a heavy-bind operation failure.

However, if the user's package relies on a data object that has a user-defined function (UDF), the package is set to be inoperative when the UDF is deleted. A package that is set to be not operable and must be manually rebind by the user.

Also, when the user wants to modify the parameters of the binding process, the bind command needs to be executed again.

The commands that perform the binding can be bind or rebind, and the specific command use method user can refer to command REFERENCE.