Publishing Additional IBM MQ Attributes as Facts in AutoPilot

This article explains how to publish additional IBM MQ attributes as facts in AutoPilot when they are not enabled by default. You can publish these attributes either by adding a database configuration entry or by deploying a Universal Agent expert.

Option 1 — Publish Attribute Using a Database Entry (Recommended)

Use this method when you want to publish the attribute under the existing MQ expert.

Steps

1. Connect to the apwmq database schema (for example, NASTEL_APWMQ).

2. Execute the following SQL statement:

   INSERT INTO WGS_FACT_LIST VALUES('<Workgroup_Name>', <OBJ_TYPE>, <ATTR_VALUE>);

3. Restart the Workgroup Server (WGS).

4. Verify that the attribute appears under the MQ expert facts.

Important Notes

• The OBJ_TYPE and ATTR_VALUE values are not publicly documented. meshIQ Support must provide these values.

• Contact Support before inserting new attributes to ensure you use the correct values.

• The database entry persists across upgrades unless you rebuild the database.

• This method avoids deploying additional experts and is generally recommended.

Option 2 — Deploy a Universal Agent Expert

Use this method when you want to publish attributes directly by executing MQSC commands.

Summary

• The Universal Agent executes MQSC commands.

• The system publishes the results as facts.

Steps

1. Right-click the CEP node and select:
   Deploy Expert > IBM MQ > Universal Agent.

2. In the General tab, provide a name for the expert.
   

3. In the Fact Options tab, configure fact expiration if required.
   

4. In the Properties tab, configure the following:

   MQSC Command:

   DISPLAY QSTATUS(*) UNCOM

   MQSC Fact Update:

   DISPLAY QSTATUS('{OBJECTNAME}') UNCOM

   

5. Click Deploy.

6. Verify that the facts appear under the deployed expert.