QUSRBRM.ENTERPRISE_REPORT_OUTPUT View
The QUSRBRM.ENTERPRISE_REPORT_OUTPUT view shows the results of reports 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_OUTPUT object.
Result Table
The following table describes the columns in the view. The system name is RPT_OUTPUT. 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_START_TIME | START_TIME | TIMESTAMP(0) | The start timestamp of the report. |
OUTPUT_QUEUE_LIBRARY | OUTQLIB | VARCHAR(10) | The name of output queue library where the reports are stored. |
OUTPUT_QUEUE | OUTQ | VARCHAR(10) | The name of output queue where the reports are stored. |
OUTPUT_QUEUE_SYSTEM | OUTQSYS | VARCHAR(17) | The name of the system where the output queue is stored. Note: The system format is nnnnnnnn.ssssssss where nnnnnnnn is the network identifier and ssssssss is the local location name. |
SPOOLED_FILE | SPLFILE | VARCHAR(10) | The spooled file name. |
QUALIFIED_SPOOLED_FILE_JOB | SPLF_JOB | VARCHAR(28) | The qualified name of the spooled file job. |
SPOOLED_FILE_NUMBER | SPLF_NBR | INTEGER | The spooled file number. |
SPOOLED_FILE_USER_DATA | USER_DATA | VARCHAR(10) | The spooled file user data. |
REPORT_COMMAND | RPTCMD | VARCHAR(10) | The report command. The possible values are:
|
REPORT_COMMAND_LIBRARY | RPTCMDLIB | VARCHAR(10) | The report command library. |
REPORT_NUMBER | RPTNBR | INTEGER | The report number. |
TOTAL_REPORTS | TOTRPTS | INTEGER | The total number of reports. |
Examples
Example 1: Report output for report definition named QREPORTDFN on system APPN.SYSTEM1 for the last 7 days
Â
SELECT REPORT_DEFINITION, REPORT_SYSTEM, REPORT_COMMAND, REPORT_START_TIME, SPOOLED_FILE, REPORT_NUMBER, TOTAL_REPORTS FROM QUSRBRM.ENTERPRISE_REPORT_OUTPUT WHERE DATE(REPORT_START_TIME) > CURRENT_DATE - 7 DAYS AND REPORT_SYSTEM = 'APPN.SYSTEM1' and REPORT_DEFINITION = 'QREPORTDFN' ORDER BY REPORT_START_TIME, REPORT_NUMBER
Example output:
REPORT_DEFINITION | REPORT_SYSTEM | REPORT_COMMAND | REPORT_START_TIME | SPOOLED_FILE | REPORT_NUMBER | TOTAL_REPORTS |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-17-10.00.29 | QP1ARCY | 1 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-17-10.00.29 | QP1A2RCY | 2 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-17-10.00.29 | QP1AASP | 3 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-18-10.00.57 | QP1ARCY | 1 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-18-10.00.57 | QP1A2RCY | 2 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-18-10.00.57 | QP1AASP | 3 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-19-10.00.21 | QP1ARCY | 1 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-19-10.00.21 | QP1A2RCY | 2 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-19-10.00.21 | QP1AASP | 3 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-20-10.00.54 | QP1ARCY | 1 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-20-10.00.54 | QP1A2RCY | 2 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-20-10.00.54 | QP1AASP | 3 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-21-10.00.35 | QP1ARCY | 1 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-21-10.00.35 | QP1A2RCY | 2 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-21-10.00.35 | QP1AASP | 3 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-22-10.01.00 | QP1ARCY | 1 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-22-10.01.00 | QP1A2RCY | 2 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-22-10.01.00 | QP1AASP | 3 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-23-10.01.07 | QP1ARCY | 1 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-23-10.01.07 | QP1A2RCY | 2 | 3 |
QREPORTDFN | APPN.SYSTEM1 | STRRCYBRM | 2022-06-23-10.01.07 | QP1AASP | 3 | 3 |
Â
Example 2: Output queue being used to store reports for report definition named QREPORTDFN on system APPN.SYSTEM1
Â
SELECT DISTINCT REPORT_DEFINITION, REPORT_SYSTEM, OUTPUT_QUEUE_LIBRARY, OUTPUT_QUEUE, OUTPUT_QUEUE_SYSTEM FROM QUSRBRM.ENTERPRISE_REPORT_OUTPUT WHERE REPORT_SYSTEM = 'APPN.SYSTEM1' and REPORT_DEFINITION = 'QREPORTDFN'
Example output:
REPORT_DEFINITION | REPORT_SYSTEM | OUTPUT_QUEUE_LIBRARY | OUTPUT_QUEUE | OUTPUT_QUEUE_SYSTEM |
QREPORTDFN | APPN.SYSTEM1 | QUSRBRM | QENTRPT | APPN.SYSTEM1 |
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.