DB2, MQ, and WAS graphs

Db2 Log Manager Hierarchy

Db2 Log Manager Hierarchy

Use to show Db2 Log Manager performance metrics for all Db2 subsystems on all systems. The graph shows the following performance measures:

• CPU Utilization
• Asynchronous Log Write request to active Log, No wait (count/sec)
• Synchronous Log Write request to active Log (count/sec)
• Number of read log requests satisfied from in-storage buffers (count/sec)
• Number of read log requests satisfied from the active log data set (count/sec)
• number of read log requests satisfied from an archive log data set (count/sec)
• Look-ahead tape volume mount performed (count/sec)
• Number of log write IO requested (count/sec)

Db2 Counts Hierarchy

Db2 Counts Hierarchy

Use to show Db2 Subsystems performance metrics for all Db2 subsystems on all systems. The graph shows the following performance measures:

• Number of create thread requests (count/sec)
• Number of Signon requests (count/sec)
• Number of Phase 1 Commits (count/sec)
• Number of Phase 2 Commits (count/sec)
• Number of Synchronize requests (count/sec)
• Number of Checkpoint requests (count/sec)
• Number of Select requests (count/sec)
• Number of Insert/Update/Delete requests (count/sec)
• Number of Open Cursor requests (count/sec)
• Number of Fetch requests (count/sec)
• Number of RID Failures (count/sec)
• Number of Lock requests (count/sec)
• Number of suspends due to IRLM Contention (count/sec)
• Number of False Contentions (count/sec)

Db2 Subsystem EDM Load from DASD

Db2 Subsystem EDM Load from DASD

Use to show performance metrics characterizing Db2 Subsystem EDM load from DASD for selected Db2 subsystems. The graph shows the following performance measures:

• Authorization Checks (count/sec)
• Successful Authorization Checks (count/sec)
• CT Section Requests (count/sec)
• CT Section Load from DASD (count/sec)
• DBD Load from DASD (count/sec)

Db2 Buffer Pools Hierarchy

Db2 Buffer Pools Hierarchy

Use to show Db2 Buffer Pool performance metrics for selected Db2 subsystems. The graph shows the following performance measures:

• Get Page (count/sec)
• Synchronous Read IO operations (count/sec)
• Asynchronous Read IO operations (count/sec)
• Synchronous Write IO operations (count/sec)
• Asynchronous Write IO operations (count/sec)
• Sequential Prefetch IO operations (count/sec)
• Prefetch IO operations (count/sec)
• Dynamic Prefetch IO operations (count/sec)
• List Prefetch IO operations (count/sec)
• Read Sequential IO operations (count/sec)
• Synchronous IO operations (count/sec)

Db2 Group Buffer Pools Hierarchy

Db2 Group Buffer Pools Hierarchy

Use to show Db2 Group Buffer Pool performance metrics for selected Db2 subsystems. The graph shows the following performance measures:

• Synchronous Read requests due to buffer XI (Cross-Invalidate)
• Synchronous Read requests
• Synchronous Write requests
• Asynchronous Write requests
• Castouts Initiated
• Explicit XI (Cross-Invalidate)
• Prefetch Read requests

Db2 GBPools by Data Sharing Hierarchy

Db2 GBPools by Data Sharing Hierarchy

Use to show Db2 Group Buffer Pool performance metrics by Data Sharing groups for selected Db2 subsystems. The graph shows the following performance measures:

• Synchronous Read requests due to buffer XI (Cross-Invalidate)
• Synchronous Read requests
• Synchronous Write requests
• Asynchronous Write requests
• Castouts Initiated
• Explicit XI (Cross-Invalidate)
• Prefetch Read requests

Db2 Subsystem Getpage Rate

Db2 Subsystem Getpage Rate

Use to show a total getpage rate for selected Db2 subsystems.

Db2 Subsystem Synchronous IO

Db2 Subsystem Synchronous IO (Read & Write)

Use to show a synchronous IO rate for selected Db2 subsystems.

Db2 Subsystem Buffer Hit Rate

Db2 Subsystem Buffer Hit Rate

Use to show a buffer hit rate for selected Db2 subsystems.

Db2 Subsystem Buffer Hit Rate without Prefetch 

Db2 Subsystem Buffer Hit Rate without Prefetch

Use to show the buffer hit rate without prefetch for selected Db2 subsystems.

Most Active Db2 Subsystem/Application elements

Most Active Db2 Application Subsystems

Use to show an applications Db2 components with the highest transaction rate in selected systems and Db2 subsystems.

Db2 Response Time by Subsystem

Db2 Response Time by Subsystem

Use to show the average response time of an applications Db2 components in selected systems and Db2 subsystems.

Db2 Transaction Rate by Subsystem

Db2 Transaction Rate by Subsystem

Use to show the transaction rate of an applications Db2 components in selected systems and Db2 subsystems.

Db2 Transaction Count by Subsystem

Db2 Transaction Count by Subsystem

Use to show the transaction count of an applications Db2 components in selected systems and Db2 subsystems.

Db2 Application by Region Hierarchy

Db2 Application by Subsystem

Use to show the Db2 components of all applications in selected systems and Db2 subsystems. The graph can show the following performance measures:

• Transaction rate (Trans/Hr)
• Response Time (sec/tran)
• CPU Utilization
• CPU service (sec/tran)

Db2 Batch Requestors

Db2 Batch Requestors

Use to show the performance metrics of Batch Db2 requestors for selected applications and systems. The graph can show the following performance measures:

• Transaction rate (Trans/Hr)
• Response Time (sec/tran)
• Class 1 CPU time (sec/tran)
• Class 2 CPU time (sec/tran)
• Number of wait trace events for read I/O (count/tran)
• Number of wait trace events for write I/O (count/tran)
• Average Db2 Log write I/Os (count/tran)
• Average Db2 wait time (sec/tran)
• Average Db2 Class 2 Elapsed time (sec/tran)
• Number of wait trace events for database I/O (count/tran)

Db2 Application Total Getpage Rate

Db2 Application Total Getpage Rate

Use to show an applications Db2 component total getpage rate for selected systems and applications.

Db2 Application by Subsystem Getpage Rate

Db2 Application by Subsystem Getpage Rate

Use to show an applications Db2 component getpage rate for all Db2 subsystems serving selected applications on selected systems.

Db2 Application in Subsystem Getpage Rate

Db2 Application in Subsystem Getpage Rate

Use to show an applications Db2 component getpage rate for selected Db2 subsystems serving selected applications on selected systems.

Critical MQ PI Hierarchy

Critical MQ Performance Indicators Hierarchy

Use to show an overview of critical Performance Indicator metrics across the selected intervals. The graph shows the following performance measures:

• Open Proportions – Ratio of open requests to the sum of open and close requests.
• Archive Read Proportions – Ratio of reads from the archive log to total reads from the log.
• Log Read Proportions – Ratio of log reads to total log operations.
• No Archive Percent – Percent of total log operations delayed because of insufficient number of archive logs defined.
• Buffer Hit Ratio – The ratio of getpage requests that were found in the buffer to total getpage requests.
• Buffer Efficiency – Ratio of getpage operations satisfied without an IO to total number of getpage operations.
• Available Buffer Proportion – Ratio of available buffer pages to total buffer pool size.

Critical MQ Perf Indicators

Critical MQ Perf Indicators

Use to show the critical performance indicator metrics by node across the selected intervals.

MQ Msg Manager Hierarchy

MQ Message Manager Hierarchy

Use to show an overview of Message Manager metrics across the selected intervals. The graph shows the following performance measures:

• Number of Open requests
• Number of Close requests
• Number of Get requests
• Number of Put requests
• Number of Put1 requests
• Number of Inquire requests
• Number of Set requests
• Number of Close handle requests
• Ratio of open requests to open and close requests

MQ Data Manager Hierarchy

MQ Data Manager Hierarchy

Use to show an overview of Data Manager metrics across the selected intervals. The graph shows the following performance measures:

• Number of Object Create requests
• Number of Object Put requests
• Number of Object Delete requests
• Number of Object Get requests
• Number of Object Locate requests
• Number of Storage class change requests

MQ Log Manager Hierarchy

MQ Log Manager Hierarchy

Use to show an overview of Log Manager metrics across the selected intervals. The graph shows the following performance measures:

• Write request – wait count.
• Write request – no wait count.
• Write request – force count.
• Number of read log requests per second satisfied from the active log data set.
• Number of read log requests satisfied from in-storage buffers.
• Number of read log requests satisfied from the active log data set.
• Number of read log requests satisfied from in-storage buffers.
• Number of read log requests per second satisfied from the archive log data set.
• Number of read log requests per second delayed due to MAXALLC parameter.
• Number of bootstrap data set access requests per second.
• Number of active log control intervals created.
• Number of calls per second that wrote to active log buffers.
• Number of times per second an archive log data set was allocated for a read request.
• Number of times per second an archive log data set was allocated for a write request.
• Count of CIs per second off-loaded to the archive data set.

MQ Global Buffer Hierarchy

MQ Global Buffer Hierarchy

Use to show an overview of global buffer metrics across the selected intervals. The graph shows the following performance measures:

• Number of buffers in this buffer pool.
• Ratio of available buffer pages to total buffer pool size.
• Number of getpage requests per second where the current page contents are required.
• Number of times per hour the asynchronous write processor was started.
• Number of times per hour the synchronous page processor was started because the synchronous write threshold was reached.
• Number of get requests per second for a new or empty page.
• Ratio of getpage requests that were found in the buffer to total number of getpage requests.
• Ratio of getpage operations satisfied without an IO to total number of getpage operations.

MQ Buffer Manager Hierarchy

MQ Buffer Manager Hierarchy

Use to show an overview of Buffer Manager metrics across the selected intervals. The graph shows the following performance measures:

• Number of buffers in this buffer pool.
• Ratio of available buffer pages to total buffer pool size.
• Ratio of available buffer pages to total buffer pool size.
• Number of getpage requests per second where the current page contents are required.
• Number of get requests per second for a new or empty page.
• Number of pages read DASD operations per second.
• Number of pages updates per second.
• Number of pages written to DASD per second.
• Number of page write operations per second.
• Number of synchronous page write operations per second.
• Number of times per hour the asynchronous write processor was started.
• Number of times per hour the synchronous page processor was started because the synchronous write threshold was reached.
• Number of times no available buffers were found.
• Ratio of getpage requests that were found in the buffer to total number of getpage requests.
• Ratio of getpage operations satisfied without an IO to total number of getpage operations

Most Active MQ Subsystem/Application elements

Most Active Application in MQ Subsystem

Use to identify the applications MQ components with the highest transaction rate in selected systems and MQ subsystems.

MQ Response Time by Subsystem

MQ Response Time by Subsystem

Use to show the average response time of an applications MQ components in selected systems and MQ subsystems.

MQ Transaction Rate by Subsystem

MQ Transaction Rate by Subsystem

Use to show the transaction rate of an applications MQ components in selected systems and MQ subsystems.

MQ Transaction Count by Subsystem

MQ Transaction Count by Subsystem

Use to show the transaction count of an applications MQ components in selected systems and MQ subsystems.

MQ Application by Subsystem Hierarchy

MQ Application by Subsystem

Use to show MQ Components of all applications in selected systems and MQ subsystems. The graph shows the following performance measures:

• Transaction rate (Trans/Hr)
• Response Time (sec/tran)
• CPU Utilization
• CPU service (sec/tran)

WAS Activity Hierarchy

WAS Activity Hierarchy

Use to show WAS performance metrics for selected WAS Servers on selected systems. The graph shows the following performance measures:

• Total Enclave CPU Utilization
• Number of global transactions that have been initiated and run through the server in tran/hr
• Number of local transactions that have been initiated by the server in tran/hr
• Bytes sent to the server from all attached clients in Kbytes/sec
• Bytes sent from the server to all attached clients in Kbytes/sec
• Bytes sent to the server from all locally attached clients in Kbytes/sec
• Bytes sent from the server to all locally attached clients in Kbytes/sec
• Bytes sent to the server from all remotely attached clients in Kbytes/sec
• Bytes sent from the server to all remotely attached clients in Kbytes/sec
• Bytes sent to the server from all HTTP attached clients in Kbytes/sec
• Bytes sent from the server to all HTTP attached clients in Kbytes/sec
• Number of communication sessions active during the interval

WAS Session and Heap Analysis

WAS Session and Heap Analysis

Use to show WAS session and heap performance metrics for selected WAS Servers on selected systems. The graph shows the following performance measures:

• Number of communication sessions that were active during the interval
• Number of active local communication sessions attached during the interval
• Number of active remote communication sessions attached during the interval
• Number of active HTTP sessions attached during the interval
• Number of HTTP sessions that were created
• Number of HTTP sessions that were invalidated
• Average lifetime of invalidated HTTP sessions
• Minimum Heap size during the interval
• Maximum Heap size during the interval
• Average Heap size during the interval
• Minimum Free Heap size during the interval
• Maximum Free Heap size during the interval
• Average Free Heap size during the interval
• Number of Heap allocation failures

WAS J2EE Container Hierarchy

WAS J2EE Container Hierarchy

Use to show J2EE Container performance metrics for Java Bean Groups for selected WAS Servers on selected systems. The graph shows the following performance measures:

• Number of times method was invoked in count/hr
• Maximum method response time in seconds
• Average method response time in seconds
• Minimum method CPU time in seconds
• Maximum method CPU time in seconds
• Average method CPU time in seconds

WAS WEB Container Hierarchy

WAS WEB Container Hierarchy

Use to show Web Container performance metrics for servlets groups on selected WAS Servers on selected systems. The graph shows the following performance measures:

• Number of times the servlet service was requested in count/hr
• Minimum servlet response time in seconds
• Maximum servlet response time in seconds
• Average servlet response time in seconds
• Minimum servlet CPU time in seconds
• Maximum servlet CPU time in seconds
• Average servlet CPU time in seconds
• Number of errors encountered during servlet execution in count/hr

WAS Application Activity by Server

WAS Application Activity by Server

Use to show WAS components of selected applications on all WebSphere Application servers in all systems. The graph shows the following performance measures:

• Transaction rate in tran/hr
• Average transaction response time in seconds
• Average web container CPU time in seconds
• Average J2EE container CPU time in seconds
• CPU Utilization

WAS Application by Server Transaction Rate

WAS Application by Server Transaction Rate

Use to show the transaction rate in transactions per hour for selected WAS Applications on all WebSphere Application servers in all Logical systems across the selected intervals.

WAS Application by Server Transaction Count

WAS Application by Server Transaction Count

Use to show the transaction count for selected WAS Applications on all WebSphere Application servers in all Logical systems across the selected intervals.

WAS Application by Server Response Time

WAS Application by Server Response Time

Use to show the average transaction Response time in seconds per transaction for selected WAS Applications on all WebSphere Application servers in all Logical systems across the selected intervals.

WAS Application by Server CPU Utilization

WAS Application by Server CPU Utilization

Use to show the CPU Utilization for selected WAS Applications on all WebSphere Application servers in all Logical systems across the selected intervals.

WAS Application by Server CPU Time

WAS Application by Server CPU Time

Use to show the average CPU time in seconds per transaction consumed by J2EE Container transactions (Method invocations) and WEB Container transactions (Servlet requests) for selected WAS Applications on all WebSphere Application servers in all Logical systems across the selected intervals.