Step
nameThe read-only columns on the Statistics window show display statistics about step processing.
The displayed information is filtered based upon filters set in previous sessions or the current session. Sort columns by clicking the column heading. Drag the column margin to resize it. Any changes you make are saved when you close the window.
Double-click the step name to obtain detailed performance statistics for the step. The Statistics Details window opens.
Shows the step name.
Shows the step type: DB2 programs, DB2 OLAP Server programs, File programs, SQL, Statistical transformers, User-defined programs, and Warehouse transformers.
Shows the name of the process.
Shows the average elapsed time in seconds that it took an edition to process. The time includes the time to complete all processing steps, including connection time, disconnection time, and the time that it took to commit changes.
Shows the average amount of data in bytes that was extracted during an edition's processing.
The column displays the not-applicable symbol, - -, if byte data is unavailable for the step, such as for a step that receives data from other steps. The not-applicable symbol is also displayed when source and target databases are the same database.
For steps that contain LONG VARCHAR or other LOB data types, the byte count that is shown in this column might not equal the actual byte count.
Shows the type of the source database from which the Data Warehouse Center extracted the data for the step.
Shows the name of the source database from which the Data Warehouse Center extracted the data for the step.
Shows the type of the target database that contains the step data.
Shows the name of the target database that contains the step data.