QUSRBRM.ENTERPRISE_REPORT_STATUS View
The QUSRBRM.ENTERPRISE_REPORT_STATUS view shows the current status of report definitions run on an enterprise node.
Authorization:Â Â
The authorization ID of the statement must include the following privileges:
*OBJOPR and *READ authority to the QUSRBRM/RPT_STATUS object.
Result Table
The following table describes the columns in the view. The system name is RPT_STATUS. The schema is QUSRBRM.
Column Name | System Column Name | Data Type | Description |
REPORT_DEFINITION | REPORT | VARCHAR(10) | The name of the report definition. |
REPORT_SYSTEM | SYSTEM | VARCHAR(17) | The name of the system where the report was performed. Note: The system format is nnnnnnnn.ssssssss where nnnnnnnn is the network identifier and ssssssss is the local location name. |
REPORT_ACTIVE | ACTIVE | VARCHAR(3) Nullable | Indicates if the report is currently active or in the process of running. The possible values are:
Contains the null value if no reports have run. |
REPORT_START_TIME | START_TIME | TIMESTAMP(0) Nullable | Report start timestamp of the report. Contains the null value if no reports have run. |
LAST_SUCCESS_TIME | LAST_SUCC | TIMESTAMP(0) Nullable | The timestamp of the last successful run of the report. Contains the null value if no reports have run successfully. |
LAST_RUN_TIME | LAST_RUN | TIMESTAMP(0) Nullable | The timestamp of the last run of the report. Contains the null value if no reports have run. |
NEXT_RUN_TIME | NEXT_RUN | TIMESTAMP(0) Nullable | The timestamp of the next scheduled run of the report. Contains the null value if no reports have run. |
Examples
Example 1 : Reports that are currently running
SELECT REPORT_DEFINITION, REPORT_SYSTEM, REPORT_ACTIVE, REPORT_START_TIME FROM QUSRBRM.ENTERPRISE_REPORT_STATUS WHERE REPORT_ACTIVE = 'YES'
Example output:
REPORT_DEFINITION | REPORT_SYSTEM | REPORT_ACTIVE | REPORT_START_TIME |
QREPORTDFN | APPN.SYSTEM1 | YES | 2022-06-23-13.09.18 |
QREPORTDFN | APPN.SYSTEM2 | YES | 2022-06-23-12.56.11 |
QREPORTDFN | APPN.SYSTEM3 | YES | 2022-06-23-13.27.13 |
QREPORTDFN | APPN.SYSTEM4 | YES | 2022-06-23-13.27.13 |
QREPORTDFN | APPN.SYSTEM5 | YES | 2022-06-23-13.27.13 |
Example 2: Reports the last time the report definition named RECOVERY successfully ran
SELECT REPORT_DEFINITION, REPORT_SYSTEM, LAST_SUCCESS_TIME FROM QUSRBRM.ENTERPRISE_REPORT_STATUS WHERE REPORT_DEFINITION = ‘RECOVERY’
Example output:
REPORT_DEFINITION | REPORT_SYSTEM | LAST_SUCCESS_TIME |
RECOVERY | APPN.SYSTEM1 | 2022-06-20-05.00.22 |
Example 3: Reports that are scheduled to run the next day
SELECT REPORT_DEFINITION, REPORT_SYSTEM, NEXT_RUN_TIME FROM QUSRBRM.ENTERPRISE_REPORT_STATUS WHERE DATE(NEXT_RUN_TIME) = CURRENT_DATE + 1 DAYS
Example output:
REPORT_DEFINITION | REPORT_SYSTEM | NEXT_RUN_TIME |
QREPORTDFN | APPN.SYSTEM1 | 2022-06-24-13.00.00 |
QREPORTDFN | APPN.SYSTEM2 | 2022-06-24-13.00.00 |
QREPORTDFN | APPN.SYSTEM3 | 2022-06-24-13.00.00 |
QREPORTDFN | APPN.SYSTEM4 | 2022-06-24-13.00.00 |
QREPORTDFN | APPN.SYSTEM5 | 2022-06-24-13.00.00 |
Privacy Policy | Cookie Policy | Impressum
From time to time, this website may contain technical inaccuracies and we do not warrant the accuracy of any posted information.
Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.