SQL Enterprise Views

Contact Info

View enterprise contacts using the SQL view QUSRBRM.ENTERPRISE_CONTACT_INFO.

Example 1: Select all contact information

SELECT * FROM QUSRBRM.ENTERPRISE_CONTACT_INFO

Example 2: Report the contact information form contact user name ADMIN

SELECT CONTACT_USER_NAME, FIRST_NAME, LAST_NAME, EMAIL_ADDRESS FROM QUSRBRM.ENTERPRISE_CONTACT_INFO WHERE CONTACT_USER_NAME = 'ADMIN'

Hub Info

View enterprise hub attributes using the SQL view QUSRBRM.ENTERPRISE_HUB_INFO.

Example 1: Select all the hub information

SELECT * FROM QUSRBRM.ENTERPRISE_HUB_INFO

Example 2: Report the primary hub contact and refresh rate

SELECT PRIMARY_CONTACT, REFRESH_RATE FROM QUSRBRM.ENTERPRISE_HUB_INFO

Node Info

View the nodes that are part of the enterprise network using the SQL view QUSRBRM.ENTERPRISE_NODE_INFO.

Example 1: Select all the node information

SELECT * FROM QUSRBRM.ENTERPRISE_NODE_INFO

Example 2: Report the output queues being used to store reports for system name APPN.SYSTEM1

SELECT SYSTEM_NAME, HUB_OUTPUT_QUEUE_LIBRARY, HUB_OUTPUT_QUEUE, STORE_REPORTS_ON_NODE, NODE_OUTPUT_QUEUE_LIBRARY, NODE_OUTPUT_QUEUE FROM QUSRBRM.ENTERPRISE_NODE_INFO WHERE SYSTEM_NAME = 'APPN.SYSTEM1'

Network Info

View the enterprise network health that are part of the enterprise network using the SQL view QUSRBRM.ENTERPRISE_NETWORK_INFO.

Example 1: Select all the network information

SELECT * FROM QUSRBRM.ENTERPRISE_NETWORK_INFO

Example 2: Check the network health

SELECT SYSTEM_NAME, INSTALLED_BRMS_RELEASE, LATEST_BRMS_PTF_ID, COMMUNICATION_ACTIVE, TRANSACTIONS_BEHIND FROM QUSRBRM.ENTERPRISE_NETWORK_INFO

Example 3: Report the systems in the network which are behind on network transactions

SELECT SYSTEM_NAME, INSTALLED_BRMS_RELEASE, COMMUNICATION_ACTIVE FROM QUSRBRM.ENTERPRISE_NETWORK_INFO WHERE TRANSACTIONS_BEHIND > 0

Report Definition Info

View the report definitions defined for the enterprise network using the SQL view QUSRBRM.ENTERPRISE_REPORT_DEFINITION_INFO.

Example 1: Select all the report definition information

SELECT * FROM QUSRBRM.ENTERPRISE_REPORT_DEFINITION_INFO

Example 2: Report the commands being run weekly on Monday

SELECT REPORT_DEFINITION, SYSTEM_NAME, FREQUENCY_INTERVAL, RUN_MONDAY, GENERATION_TIME, REPORT_COMMAND FROM QUSRBRM.ENTERPRISE_REPORT_DEFINITION_INFO WHERE FREQUENCY_INTERVAL= 'WEEKLY' AND RUN_MONDAY = 'YES'

Report Status

View the current status of report definitions run on an enterprise node using the SQL view QUSRBRM.ENTERPRISE_REPORT_STATUS.

Example 1: Select all report status information

SELECT * FROM QUSRBRM.ENTERPRISE_REPORT_STATUS

Example 2: 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 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

Report Output

View the results of reports run on an enterprise node using the SQL view QUSRBRM.ENTERPRISE_REPORT_OUTPUT.

Example 1: Select all the report output information

SELECT * FROM QUSRBRM.ENTERPRISE_REPORT_OUTPUT

Example 2: Report output for report definition named QREPORTDFN on system APPN.SYSTEM1 for the past 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