logDirectory

The log directory. The file AnalazerLog is created in this folder. The program creates a new folder if one does not exist. If the folder is left empty no log files are created.

If you are providing a log directory location, you need to add two back slashes instead of the one back slash. For example, on Windows:

C:\\Program Files\\Informatica\\PowerCenterServer7.1.2 \\Server\\TgtFiles\\AnalyzeLogs

customSQL

The location of the customsql.xml. This file is used to customize statistics for the database tables. If you don't set this parameter, the customsql.xml is not read, and the default analyze syntax is used.

If you are providing a custom statistics XML file location, you need to add two back slashes instead of the one back slash. For example, on Windows:

C:\\Program Files\\Informatica\\PiowerCenter Server 7.1.2 \\Server\\SrcFiles\\mycustomsql.xml

ConcurrencyLevel

This parameter identifies how many tables are analyzed simultaneously. Note: parallelism is achieved only when you make multiple calls to utility. A set of tables specified in a call runs sequentially.

NOTE:  For DB2, check the concurrency level with the Database Administrator. If deadlocks occur, set the value to 1.

GatherStats

The value for this parameter is Y or N. You can set the value to N to avoid analyzing tables without removing the call to the program from the session. Otherwise set the parameter value to Y.

NumberOfRetries

This parameter identifies how many attempts is made to analyze a table before failing. If this parameter is not set, the default value of 10 is used.

Timeout

Time (in milliseconds) before the analysis call is considered to fail. No timeout is used if this parameter is not set.