Displaying the current transaction workload

You can view information about the number and type of OTMA messages that are currently being processed by IMS by issuing the type-2 IMS Command QUERY OTMATI.

Issuing the QUERY OTMATI command without specifying any parameters shows the current number of OTMA messages on each IMS system in an IMSplex listed with the OTMA client and the tpipe used to submit the messages. For example, in an IMSplex with three IMS systems the following information could be returned by QUERY OTMATI:

TMember          TPipe    MbrName    CC MsgCnt                       
MQ               APPLA    IMSA        0    102                       
MQ               APPLB    IMSB        0    201                       
WAS              APPLC    IMSB        0    301

By specifying the parameters of QUERY OTMATI, you can filter and refine the information returned by the command.

For example, if you need to know if messages are waiting too long to be processed by IMS, the MSGAGE(nnn) subparameter returns a count of all messages in an IMS system that are older than nnn, where nn is a clock time specified in seconds. In the following example, QUERY OTMATI MSGAGE(3) was specified and the message count for each IMS system includes only those messages that are older than three seconds:

TMember          TPipe    MbrName    CC MsgCnt MsgAge                
MQ               APPLA    IMSA        0     50      3                
MQ               APPLB    IMSB        0     80      5                
WAS              APPLC    IMSB        0     100     4

In the example above, the number shown in the MsgAge column is the age of the most recently submitted message among all messages that are older than three seconds. For example, among the 80 messages submitted by MQ on tpipe APPLB to IMSB that are older than three seconds, the message that has been processing for the least amount of time has been processing for five seconds.

The QUERY OTMATI command includes over 25 parameters and subparameters that return information about the various components and resources that are associated with the processing of messages from OTMA clients. In addition to message counts and ages, you can also retrieve information about such things as: