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
Dynamic SQL
Dynamic SQL statements are prepared and executed at run time. In dynamic SQL, the SQL statement is contained as a character string in a host variable and is not precompiled. Dynamic SQL statements and packages can be stored in one of the DB2 caches.
A rebind occurs under the following conditions when you are using dynamic SQL:
- If the statement is not in the cache, the SQL optimizer ’binds’ the statement and generates a new access plan.
- If the statement is in the cache, no rebind occurs. To clear the contents of the SQL cache, use the FLUSH PACKAGE CACHE SQL statement.
Parent topic:
Database maintenance