Data Collection and Reporting Tables (MQ)

This topic provides information to help you define the parameters of your COLLECT and REPORT statements. See COLLECT Statement and REPORT Statement for Custom Reports.

Most report tables are broken into two sections:

  • Report fields: Collect any or all of these fields during playback. Then build custom reports containing the fields you need. For example,
    • COLLECT FIELDS(*) FROM(PLAYBACK)
      collects all report fields from the PLAYBACK table.
    • REPORT FIELDS(OWNA, JBNA, PLNA) FROM(PLAYBACK)
      reports the OwnerName, JobName, and PlaybackName fields from the PLAYBACK table.
  • Statistic fields: These fields report the minimum and maximum values, averages, and sums of specified report fields. You do not collect statistic fields, you collect the field on which the statistic is based. For example, collect MQScriptStatementCount from the MQGROUP table to report the SUM of MQScriptStatementCount on a PLAYBACK report.
    While sorting the collected data, Performance Test for WebSphere MQ calculates statistics for that data. Report the statistic by specifying any or all of the statistics fields on your REPORT statements.
    Additionally, statistics are relative to the table from which they are reported. For example:
    • REPORT FIELDS(MAX(MQScriptReturnCode)) FROM(PLAYBACK)
      reports the highest script return code that occurred during the playback.
    • REPORT FIELDS(MAX(MQScriptReturnCode)) FROM(MQGROUP)
      reports the highest script return code from each group played back.

The tables include the long and short name for each report field. Use either on the FIELDS declarations of your COLLECT and REPORT statements.

PLAYBACK table

The PLAYBACK table includes both report and statistic fields.

PLAYBACK report fields

COLLECT any or all of the following fields and REPORT them on customized PLAYBACK reports.

Long Field Names

Short Field Names

OwnerName

OWNA

JobName

JBNA

JobNumber

JBNU

SystemName

SYNA

PlaybackName

PLNA

PlaybackNumber

PLNU

PlaybackReturnCode

PLRC

PlaybackStartTime

PLST

PlaybackFinishTime

PLFT

PlaybackDuration

PLDR

MQGroupStatementCount

MQCN

Important

Performance Test for WebSphere MQ and Performance Test for Mainframe Servers share the same PLAYBACK report fields table. As such, a report containing all of the PLAYBACK fields includes the MQGroupStatementCount field.

PLAYBACK statistic fields

REPORT any of the following statistics on customized PLAYBACK reports.

Important

Use the Collect from Table column to determine the parameters for the collection statement required to report the given statistic. For example, to report MAXIMUM MQGroupReturnCode from the PLAYBACK table, collect the MQGroupReturnCode field from the MQGROUP table. Collect all fields from all tables to simplify collection and ensure a complete reporting database.


Statistics

For Field (long names)

Field Short Names

Collect from Table

MIN or MAX

MQGroupReturnCode

MQRC

MQGROUP

MIN or MAX

MQScriptReturnCode

MSRC

MQSCRIPT

AVG, MIN, MAX, or SUM

MQGroupDuration

MQDR

MQGROUP

AVG, MIN, MAX, or SUM

MQScriptDuration

MQSD

MQSCRIPT

AVG, MIN, MAX, or SUM

MQOpenQueueDuration

OQDR

MQOPENQUEUE

AVG, MIN, MAX, or SUM

MQMessageSetDuration

MSSD

MQMESSAGESET

SUM

MQScriptStatementCount

MQSC

MQGROUP

SUM

MQOpenQueueCount

MQOC

MQSCRIPT

SUM

MQMessageSetCount

MSSC

MQSCRIPT

SUM

MQMessageCountQueue

MQCQ

MQOPENQUEUE

SUM

MQMessageCountMessageSet

MQMC

MQMESSAGESET

AVG, MIN, MAX, or SUM

MQOpenQueueAttempted

MQOA

MQOPENQUEUE

AVG, MIN, MAX, or SUM

MQOpenQueueFailed

MQOF

MQOPENQUEUE

MIN or MAX

MQOpenQueueStatus

MQOP

MQOPENQUEUE

AVG, MIN, MAX, or SUM

MQOpenQueueMessageRate

MQMR

MQOPENQUEUE

MIN or MAX

MQMessageVersion

MQMV

MQMESSAGE

MIN or MAX

ExpMQMessageVersion

EXMQMV

MQMESSAGE

MQGROUP table

The MQGROUP table includes both report and statistic fields.

MQGROUP report fields

COLLECT any or all of the following fields and REPORT them on customized MQGROUP reports.

Long Field Names

Short Field Names

MQGroupNumber

MQNU

MQGroupID

MQID

MQGroupReturnCode

MQRC

MQGroupStartTime

MQST

MQGroupFinishTime

MQFT

MQGroupDuration

MQDR

MQScriptStatementCount

MQSC

MQGROUP statistic fields

REPORT any of the following statistics on customized MQGROUP reports.

Important

Use the Collect from Table column to determine the parameters for the collection statement required to report the given statistic. For example, to report MAXIMUM MQScriptReturnCode from the MQGROUP table, collect the MQScriptReturnCode field from the MQSCRIPT table. Collect all fields from all tables to simplify collection and to ensure a complete reporting database.


Statistics

For Field (long names)

Field Short Names

Collect from Table

MIN or MAX

MQScriptReturnCode

MSRC

MQSCRIPT

AVG, MIN, MAX, or SUM

MQScriptDuration

MQSD

MQSCRIPT

AVG, MIN, MAX, or SUM

MQOpenQueueDuration

OQDR

MQOPENQUEUE

AVG, MIN, MAX, or SUM

MQMessageSetDuration

MSSD

MQMESSAGESET

SUM

MQOpenQueueCount

MQOC

MQSCRIPT

SUM

MQMessageSetCount

MSSC

MQSCRIPT

SUM

MQMessageCountQueue

MQCQ

MQOPENQUEUE

SUM

MQMessageCountMessageSet

MQMC

MQMESSAGESET

AVG, MIN, MAX, or SUM

MQOpenQueueAttempted

MQOA

MQOPENQUEUE

AVG, MIN, MAX, or SUM

MQOpenQueueFailed

MQOF

MQOPENQUEUE

MIN or MAX

MQOpenQueueStatus

MQOP

MQOPENQUEUE

AVG, MIN, MAX, or SUM

MQOpenQueueMessageRate

MQMR

MQOPENQUEUE

MIN or MAX

MQMessageVersion

MQMV

MQMESSAGE

MIN or MAX

ExpMQMessageVersion

EXMQMV

MQMESSAGE

MQSCRIPT table

The MQSCRIPT table includes both report and statistic fields.

MQSCRIPT report fields

COLLECT any or all of the following fields and REPORT them on customized MQSCRIPT reports.

Long Field Names

Short Field Names

MQScriptNumber

MQSN

MQScriptName

MSCN

MQGroupNumber

MQNU

MQScriptReturnCode

MSRC

MQScriptStartTime

MSCS

MQScriptFinishTime

MSCF

MQScriptDuration

MQSD

MQOpenQueueCount

MQOC

MQMessageSetCount

MSSC

MQSCRIPT statistic fields

REPORT any of the following statistics on customized MQSCRIPT reports.

Important

Use the Collect from Table column to determine the parameters for the collection statement required to report the given statistic. For example, to report MAXIMUM MQMessageSetDuration from the MQSCRIPT table, collect the MQMessageSetDuration field from the MQMESSAGESET table. Collect all fields from all tables to simplify collection and to ensure a complete reporting database.


Statistics

For Fields (long names)

Field Short Names

Collect from Table

AVG, MIN, MAX, or SUM

MQOpenQueueDuration

OQDR

MQOPENQUEUE

AVG, MIN, MAX, or SUM

MQMessageSetDuration

MSSD

MQMESSAGESET

SUM

MQMessageCountQueue

MQCQ

MQOPENQUEUE

Sum

MQMessageCountMessageSet

MQMC

MQMESSAGESET

AVG, MIN, MAX, or SUM

MQOpenQueueAttempted

MQOA

MQOPENQUEUE

AVG, MIN, MAX, or SUM

MQOpenQueueFailed

MQOF

MQOPENQUEUE

MIN or MAX

MQOpenQueueStatus

MQOP

MQOPENQUEUE

AVG, MIN, MAX, or SUM

MQOpenQueueMessageRate

MQMR

MQOPENQUEUE

MIN or MAX

MQMessageVersion

MQMV

MQMESSAGE

MIN or MAX

ExpMQMessageVersion

EXMQMV

MQMESSAGE

MQMESSAGESET table

During playback, Performance Test for WebSphere MQ groups related MQ messages into message sets for reporting purposes. Grouping is based on MQMD header information. Performance Test for WebSphere MQ groups messages with matching correlation IDs. If the message(s) do not have correlation IDs, it groups them by Message IDs.

Important

In addition to matching Correlation and/or Message IDs, the queue on a reply message must match the queue or the ReplyToQueue on the related request message to be grouped with that message.

Performance Test for WebSphere MQ creates a Message Set for each:

  • Request message and all of its related messages
  • Non-request message that is not related to any other message—these message sets contain only a single message.

Finally, Performance Test for WebSphere MQ treats datagrams as reply messages unless they contain a ReplyToQueue. Then they are treated as request messages.

Use the MQMESSAGESET table to collect and report information about message sets. It includes both report and statistics fields.

MQMESSAGESET report fields

COLLECT any or all of the following fields and REPORT them on customized MQMESSAGESET reports.

Long Field Names

Short Field Names

MQMessageSetNumber

MSSN

MQMessageSetID

MMSI

MQScriptNumber

MQSN

MQGroupNumber

MQNU

MQMessageSetStartTime

MSTS

MQMessageSetFinishTime

MSTF

MQMessageSetDuration

MSSD

MQMessageCountMessageSet

MQMC

MQMESSAGESET statistic fields

REPORT any of the following statistics on customized MQMESSAGESET reports.

Important

Use the Collect from Table column to determine the parameters for the collection statement required to report the given statistic. For example, to report MAXIMUM MQMessageVersion from the MQMESSAGESET table, collect the MQMessageVersion field from the MQMESSAGE table. Collect all fields from all tables to simplify collection and to ensure a complete reporting database.


Statistics

For Field (long names)

Field Short Names

Collect from Table

MIN or MAX

MQMessageVersion

MQMV

MQMESSAGE

MIN or MAX

EXPMQMessageVersion

EXMQMV

MQMESSAGE

MQOPENQUEUE table

The MQOPENQUEUE table includes only report fields. There are no statistics fields.

MQOPENQUEUE report fields

COLLECT any or all of the following fields and REPORT them on customized MQOPENQUEUE reports.

Long Field Names

Short Field Names

MQOpenQueueNumber

OQNU

MQOpenQueueID

OQID

MQScriptNumber

MQSN

MQGroupNumber

MQNU

MQOpenQueueName

QNAM

MQOpenQueueManagerName

QMNA

MQOpenQueueStartTime

MSCS

MQScriptFinishTime

MSCF

MQOpenQueueDuration

OQDR

MQMessageCountQueue

MQCQ

MQOpenQueueAttempted

MQOA

MQOpenQueueFailed

MQOF

MQOpenQueueStatus

MQOP

MQOpenQueueMessageRate

MQMR

MQMESSAGE table

The MQMESSAGE table includes only report fields. There are no statistics fields.

MQMESSAGE report fields

COLLECT any or all of the following fields and REPORT them on customized MQMESSAGE reports.

Important

All fields from MQMessageVersion through the end of the table collect and report information from the MQMD header.


Long Field Names

Short Field Names

MQMessageNumber

MMNU

MQMessageID

MMID

MQMessageSetNumber

MSSN

MQOpenQueueNumber

OQNU

MQScriptNumber

MQSN

MQGroupNumber

MQNU

MQMessageVersion

MQMV

MQMessageReport

MQRO

MQMessageType

MQTY

MQMessageExpiry

MQEX

MQMessageFeedback

MQFD

MQMessageVersion

MQMV

MQMessageEncoding

MQEN

MQMessageCharSetID

MQCS

MQMessageFormat

MQFM

MQMessagePriority

MQPR

MQMessagePersistence

MQPS

MQMessageMsgID

MQMI

MQMessageCorrelationID

MQCI

MQMessageBackoutCount

MQBC

MQMessageReplyToQueue

MQRQ

MQMessageReplyToQueueMgr

MQRM

MQMessageUserIdentifier

MQUI

MQMessageAccountingToken

MQAT

MQMessageApplIdentifyData

MQAI

MQMessagePutApplType

MQPA

MQMessagePutApplName

MQPN

MQMessagePutDate

MQPD

MQMessagePutTime

MQPT

MQMessageApplOriginData

MQAO

ExpMQMessageVersion

EXMQMV

ExpMQMessageReport

EXMQRO

ExpMQMessageType

EXMQTY

ExpMQMessageExpiry

EXMQEX

ExpMQMessageFeedback

EXMQFD

ExpMQMessageEncoding

EXMQEN

ExpMQMessageCharSetID

EXMQCS

ExpMQMessageFormat

EXMQFM

ExpMQMessagePriority

EXMQPR

ExpMQMessagePersistence

EXMQPS

ExpMQMessageMsgID

EXMQMI

ExpMQMessageCorrelationID

EXMQCI

ExpMQMessageBackoutCount

EXMQBC

ExpMQMessageReplyToQueue

EXMQRQ

ExpMQMessageReplyToQueueMgr

EXMQRM

ExpMQMessageUserIdentifier

EXMQUI

ExpMQMessageAccountingToken

EXMQAT

ExpMQMessageApplIdentifyData

EXMQAI

ExpMQMessagePutApplType

EXMQPA

ExpMQMessagePutApplName

EXMQPN

ExpMQMessagePutDate

EXMQPD

ExpMQMessagePutTime

EXMQPT

ExpMQMessageApplOriginData

EXMQAO

MQMessageOutbound1

MQMO

MQMessageInbound2

MQMB

MQMessageExpectedInbound

MQME

MQMessageQueueManagerAndQueue

QMAQ

  1. Outbound indicates an MQ_PUT
  2. Inbound indicates an MQ_GET


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*