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 >

About Creating Command Tasks

Whenever the Siebel Customer-Centric Enterprise Warehouse session loads data successfully, it runs post (or pre) session command task, by calling a reusable standalone command task. This command task is called ANALYZE.

You can gather statistics for any of the target tables that are loaded by your sessions, by creating a similar stand alone command task by calling the reusable ANALYZE command task. For example, you could create a post session command task for any of your sessions by reusing the ANALYZE task and adding the target table name to need to be analyze.

Use your post session command task if you have to create a new database.properties file for any of the following reasons:

• Your target table resides on a different schema with different connection information.
• You decide to gather (or not to gather) analyzed logs for a specific table.
• You decide to use a different syntax for a table and you have a new copy of customsql.xml file.

You must have a different concurrency level set for the each specific session.