The actual procedure for completing package rebinding in the IBM DB2 database

Source: Internet
Author: User
Tags ibm db2 ibm db2 database

The following articles mainly describe how to rebind packages in the IBM DB2 database. We all know that rebinding is an application that has previously been bound to the relevant database, to generate a Package. When the package corresponding to the application is marked as Invalid or Inoperative.

Rebinding is the process of re-generating packages for applications that have previously been bound to the database. When the package corresponding to the application is marked as Invalid or Inoperative, you must rebind it. In some cases, the package is still valid, but in order to improve the running performance of the program, such as using new indexes or using new system optimization data after running the RUNSTATS command, the user will also rebind the package.

If the application package depends on some data objects, such as tables and triggers. When these data objects are deleted, the package is set to Invalid (Invalid ). When an invalid package is executed next time, it is automatically rebound by the Database Manager. Users must note that if the system fails to automatically re-bind, unexpected errors will occur during the execution of the program. At this time, the program statement may not be wrong. The error is caused by the failure of the rebinding operation.

However, if a user's package depends on a user-defined function (UDF), when the UDF is deleted, the package is set to Inoperative ). For unoperable packages, you must manually rebind them.

In addition, if you want to modify the parameters of the binding process, you also need to re-execute the binding command.

The COMMAND for executing rebinding can be BIND or REBIND. For details about how to use the COMMAND, refer to command reference.

The above content is an introduction to how to re-bind the packages in the IBM DB2 database.

The above content is a description of how to bind the package in the IBM DB2 database. I hope it will help you in this aspect.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.