IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Performance tuning > Tivoli Data Warehouse > Relational database design and performance tuning for DB2 Database servers > Database design details > Database maintenance

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2


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:


Parent topic:

Database maintenance

+

Search Tips   |   Advanced Search