The statistic database can record a wide variety of statistics relating to user activity, data warehouse activity, report SQL, and system performance. In some scenarios, it may need to trace the timestamp when the report is finished executing from the Statistics table without performing a dataload and running an Enterprise Manager report.
Below are two mays to trace this timestamp using the statistics table of IS_REPORT_STATS and IS_REP_STEP_STATS:
- The first method is to trace the last step's FINISHTIME in IS_REP_STEP_STATS for the report with the job ID recorded in IS_REPORT_STATS.
- The second method is to calculate it from IS_REPORT_STATS as REQUESTRECTIME+EXECFINISHTIME. The column of REQUESTRECTIME records the timestamp when the request is received. The column of EXECFINISHTIME records the time passed when the last step is finished which is an offset of the RequestRec Time.
NOTE:
- The IS_REPORT_STATS tracks job level statistics information about every completed report execution that occurs in Intelligence Server, which is used when the Basic Statistics option is selected in the Statistics section.
- The IS_REP_STEP_STATS tracks each step in the report execution process, which is used when the Report Job Steps option is selected in the Statistics section.
For more information on Statistics data table model, consult the Strategy 9 Supplemental Reference for System Administration product manual.
