A statistical report provides detailed performance information about an archive, extract, or delete process. Use the information in statistical reports to find the best methods to improve performance. For example, you might change the method of access to a database table, increase the number of keys, or create an index for a key column.
The statistical report for an archive or extract process is organized according to the steps in the process, as it proceeds from table to table. These steps coincide with the show steps report obtained from the Access Definition Editor. You cannot obtain a show steps report for a delete process and the statistical report for a delete process is organized by table.
The statistical report provides basic information about the table that is processed in each step. The statistical report also indicates the number of key values used to retrieve rows in the table. The report includes information about relationships with previously processed parent tables and primary keys for the start table or previously processed child tables. Finally, DBMS access statistics provide information about the actual database access to the table.
You can use DBMS tools and statistics with information in the statistical report to tune your archive or extract processes to more nearly meet your performance requirements. You might run a sample process several times to find the best combination for your needs.
For each table in a delete process, the statistical report provides detailed processing information and basic information about the table that is processed.
A bold header indicates the step number and the table name. A separate step is shown for each instance in which a table is accessed in a processing cycle. For a reference table, (Ref Table), instead of the step number, is shown.

Indicates whether file system compression is used on the directory for the archive file.
The statistical information for a step includes:
For each table, one of the following statistics is provided, according to the relationship with the table processed in a previous step. For example, if the step processes the start table or the traversal is from child to parent table, a PK value is shown. If the traversal is from parent table to child table, an FK value is shown.
Finally, the strategy and any user-provided criteria used to select rows is identified. For the start table or a traversal from child table to parent table, a Parent Strategy is shown. If traversal is from parent table to child table, a Dependant Strategy is shown. In either case, the strategy used for selecting rows by key value is:
A process generally uses a key lookup if a DBMS index is available and a scan, if one is not. If a significant portion of the table must be accessed, the process defaults to a scan, even if an index is available. A scan is also used with generalized selection criteria (for example, ORDER_ID < '100'). If the default method is undesirable from the standpoint of your needs and database configuration, you can override it. To override, use the Relationships tab on the Access Definition Editor. You can also force the process to default to a scan by using the Primary Key or Relationship Index Analysis feature to establish needed indexes.
Information about keys used to select rows in the table is also provided. This information indicates the number of key values for which the table was searched. For the start table or a traversal from child table to parent table, primary key information is shown. If traversal is from parent table to child table, relationship information, with the name of the relationship, is shown. The key information includes:
If indexes are not present, you can use the relationship index analysis to establish them. (See index analysis for a description of the relationship index analysis.)
You might also want to modify the Keys Per Cursor value. The Key Lookup method uses an SQL WHERE clause to select rows. For example, if 100 rows with unique customer IDs are processed, the WHERE clause in the SELECT statement includes CUST_ID = hostvar. By default, a cursor/fetchloop is opened once per key or 100 times, in the example, with a single key value as the host variable for each. However, you can change the Key Lookup Limit to override the default Keys Per Cursor setting. (For more information, seeKey Lookup Limit). If this setting is 5, the host variable includes five key values for each lookup and a cursor/fetchloop is opened for every five keys. In the preceding example, the cursor/fetchloop is opened 20 times.
Information regarding database access is provided to the DBMS for each SELECT request that is executed during the processing step. For example, you might use generalized criteria such as ORDER_ID < '100' and Point and Shoot to select start table rows for an extract process. In this case, the statistical report for the processing step includes DBMS access entries for a key lookup to select the Point-and-Shoot rows and a scan to select rows that match the generalized criteria.
DBMS Access Information includes:
Statistical information for a delete process can be included in the Delete Process Report or in the Archive Process Report, if specified.
For each table in a delete process, the statistical report provides detailed processing information and basic information about the table that is processed. The delete impact analysis shows the estimated amount of storage saved as a result of the deletion. This estimate does not account for any additional DBMS storage that is used to manage the row data.
A bold header indicates the table from which rows are deleted. At the end of the report the totals for the process are provided. This statistical information can indicate whether you can improve performance by overriding the default method (scan or key lookup) of accessing a table. (For details on overriding the default method, see Table Access Strategy.)


When compression options are used in an archive process, those statistics are included in the statistical information. Archive file and individual table compression values are shown as described in the following.