This table to used to store TSreorg job statistics. The information stored here is used to predict future job execution time and is used to forecast when another reorg will be needed.
When the JAS job is deleted, the corresponding row in this table is removed by TSreorg.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| job_id | decimal(31) | not null | This is the JAS job id for the reorg job. |
| job_run | decimal(31) | not null | This is the JAS job run number (within the job) for this reorg job. |
| mb_processed | decimal(31) | with null | This is the number of megabytes processed by the reorg job. |
| n_indexed_rows | decimal(31) | with null | This is the number of rows that have been indexed. If there is no index for the table, this will be 0. |
| cpu_time | decimal(31) | with null | This is the CPU time taken to run the reorg job. |
| elapsed_time | decimal(31) | with null | This is the elapsed wall-clock time for the reorg job. |
Product Name: Unicenter Database Management
Table Type: Table