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) and Version 15.0 >

Executing the RUNSTATS Command on Microsoft SQL Server 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) and Version 15.0. Use this task to execute the RUNSTATS command on Microsoft SQL Server. 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 Microsoft SQL Server

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

    /u SADMIN /p MSSQL /s ODBC_data_source_name

  2. Execute the following command:

    Exec sp_updatestats;

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