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 RUNSTATS Command on MSSQL 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). Perform the following task to execute the RUNSTATS command on MSSQL Database. 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 MSSQL Database

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

    /u SADMIN /p MSSQL /s <your ODBC data source name>

  2. Execute the following command:

    Exec sp_updatestats;

Siebel Database Upgrade Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.