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:

  • STRRCYBRM

  • STRMNTBRM

  • DSPLOGBRM

  • PRTRPTBRM

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.