Upgrade Guide for DB2 UDB for z/OS and OS/390 > Upgrading a Database from the Midtier >

Updating Statistics

Upgrades: All upgrades.

Environments: Development (midtier-centric) environment.

This topic is part of an upgrade process. See How to Perform the Upgrade.

This section describes how to update statistics. Perform this task on tables that receive a large number of inserts on the repository imports.

To update statistics

1. Navigate to the following directory:

   SIEBEL_ROOT\siebsrvr\bin

2. Execute the file RSTAT390.exe

   The following table describes the parameters for this executable.

   Argument	Description
   /u	Username. For example, sbladm. This argument is required.
   /p	Password. This argument is required.
   /c	ODBC Data Source. This argument is required.
   /d	Siebel Table Owner. This argument is required.
   /e	Specify Y to execute RUNSTATS on entire schema. Default = N.
   /t	Specify the table to RUNSTATS on.
   /a	Specify Y to RUNSTATS on all tables in table space. Default = N.
   /i	Specify Y to ignore errors. This applies to the entire schema only. Default = N.
   /l	Specify directory and filename for log file. Default filename = rstat390.log.
   /s	Sample value. Default = 25.