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:

  • 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:

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.