Technical Blog Post
MQ agent: Historical Queue Statistics workspace has no data
Product: WebSphere MQ monitoring agent (ITCAM)
In Tivoli Enterprise Portal (TEP), MQ monitoring agent workspace Queue Statistics, real time data is available. However Historical Queue Statistics workspace data is not available as shown in the following screenshot.
Screenshot 1: Historical Queue Statistics table view has no data in it.
If this history collection is not distributed to the MQ agent, the agent workspace for "Historical Queue Statistics" will show error KFWITM217E rc=3000 SQL1_DistReqError - this error means that the history collection is not enabled on this agent.
Follow steps for configuring ITCAM MQ agent and history collection for Queue Statistics data.
1) Settings in the MQ agent configuration file
Make sure the configuration file mq_instancename.cfg has following settings:
1.1 The line for "SET QUEUE" must have the "STATISTICS(YES)" setting as follows:
SET QUEUE NAME(*) MGRNAME(TESTQM) QDEFTYPE(PREDEFINED) STATISTICS(YES)
Warning: The lines in the cfg file must not exceed 80 characters or they will be truncated to 80 characted. If the line exceeds 80 characters, then use continuation character hyphen "-" at 80 or less position and add the rest on the next line.
1.2 The line for "PERFORM STARTMON" must have the "HISTORY(YES)" setting as follows:
PERFORM STARTMON SAMPINT(300) HISTORY(YES)
2) Configure history collection in Tivoli Enterprise Portal
Open History Collection Configuration panel in TEP. Make sure the history collection for "Queue Long Term History" attribute group is configured, and distributed to the agent. Select "Apply" to save the configuration. The collection should look green in TEP. See example screenshots below:
Screenshot 2: Create history collection for Queue Long Term History attribute group
Screenshot 3: History is distributed to the agent, the collection shows green after it is distributed.
Click OK to exit the history configuration panel.
3) Steps to confirm that history collection has started at the agent
3.1 Check agent log Check *MQ.LG0 log file for the MQ agent, look for following log statement which confirms that the history for Queue_Long_Term_History is started.
KRAIRA000 Starting UADVISOR_KMQ_QMQLH for KMQ.QMQ_LH
3.2 Check the history file path for history files for the attribute group:
The default history file path for MQ agent on Linux platform is /opt/IBM/ITM/lx8263.
4) Steps to access Historical Queue Statistics workspace
This is a linked workspace and must be accessed from links at a queue row in the Queue Statistics workspace.
Use steps and screenshots below to access the Historical Queue Statistics workspace:
1. From the Physical View in TEP
2. Navigate down to the qmgr in question
3. Click on '+' to expand the sub-tree
4. Left-click on Queue Statistics
5. Select a local queue from the table view
6. Right click -> Link To ... -> Historical Queue Statistics
This is shown in the screenshots below:
Screenshot 4: Shows a row for queue TESTQ2 is right-clicked, showing links available for selection.
Screenshot 5: Linked workspace for "Historical Queue Statistics" shows data.
Changing monitoring options
Enabling queue statistics monitoring
A mapping table for attribute groups and historical workspaces
Attribute name Workspace name
Queue Long Term History Historical Queue Statistics workspace
Monitoring options: PERFORM STARTMON - HISTORY(YES)