Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Initializing and Populating the Siebel Customer-Centric Enterprise Warehouse > Process of Configuring the Table Analyze Utility >

Running the Table Analyze Utility

This task is a step in the Process of Configuring the Table Analyze Utility.

Tables are run sequentially when using the Table Analyze Utility for a list of tables. Running multiple Table Analyze Utilities results in multiple tables being analyzed at the same time (if ConcurencyLevel is higher than 1).

The Table Analyze Utility uses the W_ETL_STAT_UTIL data warehouse table. There is a record created in the W_ETL_STAT_UTIL table for each analyzed table. If a table is analyzed daily, a new record is created for each day. When the Table Analyze Utility examines multiple tables, a record for each table is created, when all the previous tables are successfully analyzed.

If you want to cancel a request, find the analyzed table name and set the ABORT_FLG to Y in the TABLE_NAME column. The Table Analyze Utility cancels the table analysis and skips the remaining tables.

Table Analyze Utility returns an error code on completion. Table 13 lists the error codes and their descriptions.

NOTE:  Truncate the W_ETL_RUN_ANAL table for improved performance.

To run the Table Analyze Utility

• At the command prompt, enter the following:
  • Windows

  %MY_JAVA_HOME%\java -cp %CLASSPATH% AnalyzeTables -d PropertiesFile -p PasswordFile table1 table2 ...

  • Unix

  $MY_JAVA_HOME/java -cp $CLASSPATH AnalyzeTables -d PropertiesFile -p PasswordFile table1 table2 ...

  where the PropertiesFile is the name and path of the properties file. The PasswordFile is the name and path of the encrypted password file.