
156 Siebel 7.8 with IBM DB2 UDB V8.2 Handbook
REBIND
After performing a RUNSTATS, packages should be rebound so that their static
SQL can take advantage of the most recent system statistics. Use the DB2RBIND
command to rebind all the database packages:
db2rbind dbname -l logfile.out ALL
6.4 DB2 UDB table reorganization
Table and index maintenance is a critical success factor in Siebel
implementations. Appropriate and timely maintenance must be applied to ensure
performance and scalability characteristics, in line with user and management
expectations. Setting up a schedule to perform table maintenance is an important
part of maintaining user produ ...