Siebel Database Upgrade Guide > Performing the Siebel Incremental Repository Merge > Process of Performing an Incremental Upgrade of the Siebel Database from Siebel CRM Version 8.1.1.x and 8.2.2.x (SIA Repository) >
Executing the RUNSTATS Command on IBM DB2 Database During the Pause Following New Repository Creation
This task is a step in Process of Performing an Incremental Upgrade of the Siebel Database from Siebel CRM Version 8.1.1.x and 8.2.2.x (SIA Repository). Use the following task to execute the RUNSTATS command on IBM DB2 Database, or see your database administrator to have the command executed. The Upgrade Wizard pauses notifying you to execute RUNSTATS and then resume. At this point paused moment, the RUNSTATS command has to be executed. To execute the RUNSTATS command on IBM DB2 Database
- Connect to the IBM DB2 command window and execute the following commands:
echo "select 'runstats on table ' concat rtrim(creator) concat '.' concat rtrim(Name) concat ' and detailed indexes all shrlevel change' concat ';' from sysibm.systables where type='T' and (name not in ('S_ESCL_LOG','S_DOCK_INIT_ITEM') and name not like ('S_DOCK_INITM_%')) order by name ;">DBname_tmp_runstats.sql
Example:
db2 connect to db204205 user siebel using db2 db2 -tf DB204205_tmp_runstats.sql | grep runstats | grep -v ^select > DB204205_runstats.sql db2 terminate
db2 connect to db204205 user siebel using db2 db2 -tf DB204205_runstats.sql db2 terminate
|