PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column NameColumn Description
PWII_ID

ID of the instance. Columns of XXXX_PWII_INSTANCE_ID have values from the column.

PWII_INSTANCE_NAME

Name of the instance.

PWII_TECHNOLOGY

Two characters defining the technology of the instance (such as OR for Oracle and JE for J2EE).

PWII_SERVER

Name of the server on which the instance is installed.

PW_MQBD_BODY_N

The WebSphere message body normalization table.

Column NameColumn 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 NameColumn 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 NameColumn 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 NameColumn 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 NameColumn 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 NameColumn 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 NameColumn 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 NameColumn 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 NameColumn 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 NameColumn 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 NameColumn 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 NameColumn 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 NameColumn 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

OracleSQL ServerExpression 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 NameColumn 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

OracleSQL ServerExpression 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 NameColumn 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

OracleSQL ServerExpression 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.

IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal