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:

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: NO YES 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:

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

SELECT REPORT_DEFINITION, REPORT_SYSTEM, NEXT_RUN_TIME FROM QUSRBRM.ENTERPRISE_REPORT_STATUS WHERE DATE(NEXT_RUN_TIME) = CURRENT_DATE + 1 DAYS

Example output: