PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
| Column Name | Column Description |
|---|---|
PWII_ID | ID of the instance. Columns of |
PWII_INSTANCE_NAME | Name of the instance. |
PWII_TECHNOLOGY | Two characters defining the technology of the instance (such as |
PWII_SERVER | Name of the server on which the instance is installed. |
PW_MQBD_BODY_N
The WebSphere message body normalization table.
| Column Name | Column Description |
|---|---|
MQBD_ID | The ID of the WebSphere message body. |
MQBD_STRING_VALUE | The name of the WebSphere message body. |
PW_MQAT_ATTRIBUTES_N
The WebSphere message header fields normalization table.
| Column Name | Column Description |
|---|---|
MQAT_ID | The ID of the WebSphere message header fields. |
MQAT_STRING_VALUE | The name of the WebSphere message header fields. |
PW_MQMT_MSG_TYPES
The WebSphere message type normalization table.
| Column Name | Column Description |
|---|---|
MQMT_ID | The ID of the WebSphere message type. |
MQMT_TYPE | The name of the WebSphere message type. |
PW_MQSG_SERVER_GRP
The WebSphere server group table.
| Column Name | Column Description |
|---|---|
MQSG_INSM_ID | The ID of servers passing the WebSphere message. |
MQSG_INGD_ID | The ID of the servers group passing the WebSphere message. |
PW_MQMG_QUEUE_MGR_NAME_GRP
The WebSphere queue manager group table.
| Column Name | Column Description |
|---|---|
MQMG_MQMN_ID | The ID of queue manager passing the WebSphere message. |
MQMG_INGD_ID | The ID of the queue manager group passing the WebSphere message. |
PW_MQUG_USER_GRP
The WebSphere user group table.
| Column Name | Column Description |
|---|---|
MQUG_MQUN_ID | The ID of user passing the WebSphere message. |
MQUG_INGD_ID | The ID of the user group passing the WebSphere message. |
PW_MQQG_QUEUE_NAME_GRP
The WebSphere queue group table.
| Column Name | Column Description |
|---|---|
MQQG_MQQN_ID | The ID of queue passing the WebSphere message. |
MQQG_INGD_ID | The ID of the queue group passing the WebSphere message. |
PW_MQLG_APPLICATION_GRP
The WebSphere reader and writer applications group table.
| Column Name | Column Description |
|---|---|
MQLG_MQLN_ID | The ID of reader or writer applications passing the WebSphere message. |
MQLG_INGD_ID | The ID of the reader or writer applications group passing the WebSphere message. |
PW_MQUN_USER_N
The WebSphere user normalization table.
| Column Name | Column Description |
|---|---|
MQUN_ID | The ID of user passing the WebSphere message. |
MQUN_STRING_VALUE | The name of the user passing the WebSphere message. |
PW_MQLN_APPLICATION_N
The WebSphere application normalization table.
| Column Name | Column Description |
|---|---|
MQLN_ID | The ID of application passing the WebSphere message. |
MQLN_STRING_VALUE | The name of the application passing the WebSphere message. |
PW_MQMN_QUEUE_MGR_NAME_N
The WebSphere queue manager normalization table.
| Column Name | Column Description |
|---|---|
MQMN_ID | The ID of queue manager passing the WebSphere message. |
MQMN_STRING_VALUE | The name of the queue manager passing the WebSphere message. |
PW_MQQN_QUEUE_NAME_N
The WebSphere queue name normalization table.
| Column Name | Column Description |
|---|---|
MQQN_ID | The ID of queue passing the WebSphere message. |
MQQN_STRING_VALUE | The name of the queue passing the WebSphere message. |
PW_MQAC_ACTIONS_T
The WebSphere message activity summarized by each aggregated invocation.
| Column Name | Column Description |
|---|---|
MQAC_PWII_INSTANCE_ID | The ID of the instance passing the WebSphere message. |
MQAC_TIMESTAMP | The time summary. |
MQAC_MAJOR_MSG_ID | The ID of the WebSphere message. |
MQAC_QUEUE_NAME | The ID of the queue passing the WebSphere message. |
MQAC_QUEUE_MGR_NAME | The ID of the queue manager passing the WebSphere message. |
MQAC_MSG_TYPE | The ID of the WebSphere message type. |
MQAC_USER | The ID of the user passing the WebSphere message. |
MQAC_RD_APPLICATION | The ID of the reader application passing the WebSphere message. |
MQAC_WR_APPLICATION | The ID of the writer application passing the WebSphere message. |
MQAC_ATTRIBUTES | The ID of the WebSphere message header fields. |
MQAC_BODY | The ID of the WebSphere message body. |
MQAC_STAT1_SUM | The number of message bytes, transferred while passing the WebSphere message. |
MQAC_TIME1_SUM | Total time the WebSphere message waited in a queue. |
MQAC_TIME2_SUM | Total WebSphere message processing time. This time includes the time the message was processed till it was placed in another queue. |
MQAC_REQUESTS_SUM | Total number of WebSphere message executions. |
MQAC_RED_SUM | Total number of WebSphere message executions, which Breached their SLA. |
MQAC_YELLOW_SUM | Total number of WebSphere message executions, which Near Breached their SLA. |
MQAC_GREEN_SUM | Total number of WebSphere message executions, which did Not Breach their SLA. |
Expressions
| Oracle | SQL Server | Expression Description |
|---|---|---|
SUM(MQAC_TIME1_SUM+MQAC_TIME2_SUM) | SUM(MQAC_TIME1_SUM+MQAC_TIME2_SUM) | Total time WebSphere message was between two queue inserts. |
SUM(MQAC_TIME1_TIME_SUM)/sum(decode(MQAC_REQUESTS_SUM,0,1, MQAC_REQUESTS_SUM)) | SUM(MQAC_TIME1_TIME_SUM)/sum(decode(MQAC_REQUESTS_SUM,0,1, MQAC_REQUESTS_SUM)) | Average time the WebSphere message waited in a queue. |
SUM(MQAC_TIME2_TIME_SUM)/sum(decode(MAAC_REQUESTS_SUM,0,1, MQAC_REQUESTS_SUM)) | SUM(MQAC_TIME2_TIME_SUM)/sum(decode(MAAC_REQUESTS_SUM,0,1, MQAC_REQUESTS_SUM)) | Average WebSphere message processing time. This time includes the time the message was processed until it was placed in another queue. |
SUM(MQAC_TIME1_SUM+MQAC_TIME2_SUM)/sum(decode(MQAC_REQUESTS_SUM ,0,1,MQAC_REQUESTS_SUM)) | SUM(MQAC_TIME1_SUM+MQAC_TIME2_SUM)/sum(decode(MQAC_REQUESTS_SUM ,0,1,MQAC_REQUESTS_SUM)) | Average time the WebSphere message was between two queues inserts. |
SUM(MQAC_REQUESTS_SUM-MQAC_RED_SUM-MQAC_YELLOW_SUM-MQAC_GREEN_SUM) | SUM(MQAC_REQUESTS_SUM-MQAC_RED_SUM-MQAC_YELLOW_SUM-MQAC_GREEN_SUM) | Total number of WebSphere service executions, for which the SLA was not defined. |
SUM(MQAC_RED_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | SUM(MQAC_RED_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | Percentage of WebSphere message executions, which Breached their SLA. The percentage is calculated out of the WebSphere messages, for which SLA was established. |
SUM(MQAC_YELLOW_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | SUM(MQAC_YELLOW_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | Percentage of WebSphere message executions, which Near Breached their SLA. The percentage is calculated out of the WebSphere messages, for which SLA was established. |
SUM(MQAC_GREEN_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | SUM(MQAC_GREEN_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | Percentage of WebSphere message executions, which Not Breached their SLA. The percentage is calculated out of the WebSphere messages, for which SLA was established. |
PW_MQAC_ACTIONS_QMUAT_T
The WebSphere message activity summarized by each aggregated invocation.
| Column Name | Column Description |
|---|---|
MQAC_PWII_INSTANCE_ID | The ID of the instance passing the WebSphere message. |
MQAC_TIMESTAMP | The time summary. |
MQAC_QUEUE_NAME | The ID of the queue passing the WebSphere message. |
MQAC_QUEUE_MGR_NAME | The ID of the queue manager passing the WebSphere message. |
MQAC_MSG_TYPE | The ID of the WebSphere message type. |
MQAC_USER | The ID of the user passing the WebSphere message. |
MQAC_RD_APPLICATION | The ID of the reader application passing the WebSphere message. |
MQAC_WR_APPLICATION | The ID of the writer application passing the WebSphere message. |
MQAC_STAT1_SUM | The number of message bytes, transferred while passing the WebSphere message. |
MQAC_TIME1_SUM | Total time the WebSphere message waited in a queue. |
MQAC_TIME2_SUM | Total WebSphere message processing time. This time includes the time the message was processed till it was placed in another queue. |
MQAC_REQUESTS_SUM | Total number of WebSphere message executions. |
MQAC_RED_SUM | Total number of WebSphere message executions, which Breached their SLA. |
MQAC_YELLOW_SUM | Total number of WebSphere message executions, which Near Breached their SLA. |
MQAC_GREEN_SUM | Total number of WebSphere message executions, which did Not Breach their SLA. |
Expressions
| Oracle | SQL Server | Expression Description |
|---|---|---|
SUM(MQAC_TIME1_SUM+MQAC_TIME2_SUM) | SUM(MQAC_TIME1_SUM+MQAC_TIME2_SUM) | Total time WebSphere message was between two queue inserts. |
SUM(MQAC_TIME1_TIME_SUM)/sum(decode(MQAC_REQUESTS_SUM,0,1, MQAC_REQUESTS_SUM)) | SUM(MQAC_TIME1_TIME_SUM)/sum(decode(MQAC_REQUESTS_SUM,0,1, MQAC_REQUESTS_SUM)) | Average time the WebSphere message waited in a queue. |
SUM(MQAC_TIME2_TIME_SUM)/sum(decode(MAAC_REQUESTS_SUM,0,1, MQAC_REQUESTS_SUM)) | SUM(MQAC_TIME2_TIME_SUM)/sum(decode(MAAC_REQUESTS_SUM,0,1, MQAC_REQUESTS_SUM)) | Average WebSphere message processing time. This time includes the time the message was processed until it was placed in another queue. |
SUM(MQAC_TIME1_SUM+MQAC_TIME2_SUM)/sum(decode(MQAC_REQUESTS_SUM ,0,1,MQAC_REQUESTS_SUM)) | SUM(MQAC_TIME1_SUM+MQAC_TIME2_SUM)/sum(decode(MQAC_REQUESTS_SUM ,0,1,MQAC_REQUESTS_SUM)) | Average time the WebSphere message was between two queues inserts. |
SUM(MQAC_REQUESTS_SUM-MQAC_RED_SUM-MQAC_YELLOW_SUM-MQAC_GREEN_SUM) | SUM(MQAC_REQUESTS_SUM-MQAC_RED_SUM-MQAC_YELLOW_SUM-MQAC_GREEN_SUM) | Total number of WebSphere service executions, for which the SLA was not defined. |
SUM(MQAC_RED_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | SUM(MQAC_RED_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | Percentage of WebSphere message executions, which Breached their SLA. The percentage is calculated out of the WebSphere messages, for which SLA was established. |
SUM(MQAC_YELLOW_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | SUM(MQAC_YELLOW_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | Percentage of WebSphere message executions, which Near Breached their SLA. The percentage is calculated out of the WebSphere messages, for which SLA was established. |
SUM(MQAC_GREEN_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | SUM(MQAC_GREEN_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | Percentage of WebSphere message executions, which Not Breached their SLA. The percentage is calculated out of the WebSphere messages, for which SLA was established. |
PW_MQAC_ACTIONS_UAT_T
The WebSphere message activity summarized by each aggregated invocation.
| Column Name | Column Description |
|---|---|
MQAC_PWII_INSTANCE_ID | The ID of the instance passing the WebSphere message. |
MQAC_TIMESTAMP | The time summary. |
MQAC_MSG_TYPE | The ID of the WebSphere message type. |
MQAC_USER | The ID of the user passing the WebSphere message. |
MQAC_RD_APPLICATION | The ID of the reader application passing the WebSphere message. |
MQAC_WR_APPLICATION | The ID of the writer application passing the WebSphere message. |
MQAC_STAT1_SUM | The number of message bytes, transferred while passing the WebSphere message. |
MQAC_TIME1_SUM | Total time the WebSphere message waited in a queue. |
MQAC_TIME2_SUM | Total WebSphere message processing time. This time includes the time the message was processed till it was placed in another queue. |
MQAC_REQUESTS_SUM | Total number of WebSphere message executions. |
MQAC_RED_SUM | Total number of WebSphere message executions, which Breached their SLA. |
MQAC_YELLOW_SUM | Total number of WebSphere message executions, which Near Breached their SLA. |
MQAC_GREEN_SUM | Total number of WebSphere message executions, which did Not Breach their SLA. |
Expressions
| Oracle | SQL Server | Expression Description |
|---|---|---|
SUM(MQAC_TIME1_SUM+MQAC_TIME2_SUM) | SUM(MQAC_TIME1_SUM+MQAC_TIME2_SUM) | Total time WebSphere message was between two queue inserts. |
SUM(MQAC_TIME1_TIME_SUM)/sum(decode(MQAC_REQUESTS_SUM,0,1, MQAC_REQUESTS_SUM)) | SUM(MQAC_TIME1_TIME_SUM)/sum(decode(MQAC_REQUESTS_SUM,0,1, MQAC_REQUESTS_SUM)) | Average time the WebSphere message waited in a queue. |
SUM(MQAC_TIME2_TIME_SUM)/sum(decode(MAAC_REQUESTS_SUM,0,1, MQAC_REQUESTS_SUM)) | SUM(MQAC_TIME2_TIME_SUM)/sum(decode(MAAC_REQUESTS_SUM,0,1, MQAC_REQUESTS_SUM)) | Average WebSphere message processing time. This time includes the time the message was processed until it was placed in another queue. |
SUM(MQAC_TIME1_SUM+MQAC_TIME2_SUM)/sum(decode(MQAC_REQUESTS_SUM ,0,1,MQAC_REQUESTS_SUM)) | SUM(MQAC_TIME1_SUM+MQAC_TIME2_SUM)/sum(decode(MQAC_REQUESTS_SUM ,0,1,MQAC_REQUESTS_SUM)) | Average time the WebSphere message was between two queues inserts. |
SUM(MQAC_REQUESTS_SUM-MQAC_RED_SUM-MQAC_YELLOW_SUM-MQAC_GREEN_SUM) | SUM(MQAC_REQUESTS_SUM-MQAC_RED_SUM-MQAC_YELLOW_SUM-MQAC_GREEN_SUM) | Total number of WebSphere service executions, for which the SLA was not defined. |
SUM(MQAC_RED_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | SUM(MQAC_RED_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | Percentage of WebSphere message executions, which Breached their SLA. The percentage is calculated out of the WebSphere messages, for which SLA was established. |
SUM(MQAC_YELLOW_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | SUM(MQAC_YELLOW_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | Percentage of WebSphere message executions, which Near Breached their SLA. The percentage is calculated out of the WebSphere messages, for which SLA was established. |
SUM(MQAC_GREEN_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | SUM(MQAC_GREEN_SUM)/sum(decode(MQAC_RED_SUM+MQAC_YELLOW_SUM+ MQAC_GREEN_SUM,0,1,MQAC_RED_SUM+MQAC_YELLOW_SUM+MQAC_GREEN))*100 | Percentage of WebSphere message executions, which Not Breached their SLA. The percentage is calculated out of the WebSphere messages, for which SLA was established. |