Upgrade Guide for DB2 UDB for z/OS > Upgrading a Development Environment Database from the Midtier >

Updating Statistics

Upgrades: All upgrades.

Environments: Development environment only.

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\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 for which you want to execute RUNSTATS.
   /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.