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
- Navigate to the following directory:
SIEBEL_ROOT \siebsrvr \bin
- Execute the file
RSTAT390.exe
The following table describes the parameters for this executable.
|
|
/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. |
|