IBM Tivoli Monitoring, Version 6.3

REBIND

After running RUNSTATS on your database tables, you must rebind your applications to take advantage of those new statistics.

Rebinding ensures that DB2® is using the best access plan for your SQL statements. Perform a REBIND after running RUNSTATS as part of you normal database maintenance procedures. The type of SQL that you are running determines how the rebind occurs.

DB2 provides support for the following types of SQL:

Dynamic SQL
Static SQL

Feedback