Precise Application Performance Platform 10.3.x

Page History

Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on Feb 08, 2021

compared with

New Version Current

changes.mady.by.user Nadja Pollard

Saved on Mar 10, 2021

Key

This line was added.
This line was removed.
Formatting was changed.

Table of Contents

maxLevel	2
minLevel	2

PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column Name	Column 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 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.

Scroll Ignore

scroll-pdf	true
scroll-office	true
scroll-chm	true
scroll-docbook	true
scroll-eclipsehelp	true
scroll-epub	true
scroll-html	true

Newtabfooter
alias IDERA
url http://www.idera.com
|
Newtabfooter
alias Products
url https://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
alias Purchase
url https://www.idera.com/buynow/onlinestore
|
Newtabfooter
alias Support
url https://idera.secure.force.com/precise/
|
Newtabfooter
alias Community
url http://community.idera.com
|
Newtabfooter
alias Resources
url http://www.idera.com/resourcecentral
|
Newtabfooter
alias About Us
url http://www.idera.com/about/aboutus
|
Newtabfooter
alias Legal
url https://www.idera.com/legal/termsofuse

Content

Space Tools

Page History

Versions Compared

Old Version 1

New Version Current

Key

PW_PWII_INSTANCE_ID

PW_MQBD_BODY_N

PW_MQAT_ATTRIBUTES_N

PW_MQMT_MSG_TYPES

PW_MQSG_SERVER_GRP

PW_MQMG_QUEUE_MGR_NAME_GRP

PW_MQUG_USER_GRP

PW_MQQG_QUEUE_NAME_GRP

PW_MQLG_APPLICATION_GRP

PW_MQUN_USER_N

PW_MQLN_APPLICATION_N

PW_MQMN_QUEUE_MGR_NAME_N

PW_MQQN_QUEUE_NAME_N

PW_MQAC_ACTIONS_T

Expressions

PW_MQAC_ACTIONS_QMUAT_T

Expressions

PW_MQAC_ACTIONS_UAT_T

Expressions