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 (SIA Repository), 8.2.2.x, 15.x, and 16.x >

Executing the UPDATESTATS 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 (SIA Repository), 8.2.2.x, 15.x, and 16.x. 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_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 © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.