Executing the UPDATESTATS Command on Microsoft SQL Server During the Pause Following New Repository Creation

This task is a step in Process of Meeting Requirements for an Incremental Repository Merge. Use this task to execute the UPDATESTATS command on Microsoft SQL Server. The Upgrade Wizard pauses and notifies you to execute the UPDATESTATS command and then resume. Execute UPDATESTATS as described in the procedure that follows.

To execute the UPDATESTATS command on Microsoft SQL Server

1. Navigate to $SIEBEL_HOME\bin on the command window, and log in to odbcsql, using the following command:

   /u SADMIN /p ******** /s ODBC_data_source_name

2. Execute the following command:

   Exec sp_updatestats;