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
Static SQL
Static SQL statements are embedded within a program, and are prepared during the program preparation process before the program is executed. After preparation, a static SQL statement does not change, although values of host variables that the statement specifies can change. These static statements are stored in a DB2 object called a package.
A rebind occurs under the following conditions when you are using static SQL:
- Explicitly, if an explicit REBIND package occurs
- Implicitly, if the package is marked ’invalid’, which can happen if an index that the package was using was dropped.
Parent topic:
Database maintenance