Command Totals

When listing IBM MQ objects or status records, it is very often the case that you will have more than one response, with wild-carded inquiries often many, many more. A good MQ administration tool will show you the total number of responses. Having the total immediately available to you can also be very useful when problem solving various issues, for example, server-connection channels reaching MAXINST, or not enough open handles on a queue.

Both MQGem Software administration tools do this, our GUI admin tool – MO71, and our command line tool – MQSCX.

MO71 – GUI Administration

When displaying a list of items, MO71 shows two numbers in the bottom right corner of the dialog. The first number shows you how many items are being shown in the list, and the second number shows you how many items were returned from the queue manager. These two numbers may be different if you have some local filtering applied to the list before it is presented to the user.

MO71 Queue List Totals

A filtered list of queues shown in MO71 with the totals at the bottom right of the dialog.

MQSCX – Command Line Administration

MQSCX has a setting where it will show you total numbers of items listed. You turn this setting on using an =set command:-

MQSCX Extended MQSC Program – Version 8.0.1

Licenced to Paul Clarke

Licence Location: MQGem Office

Connected to ‘MQ800’

MQ800> =set distotals(on)

As with MO71, MQSCX will show two totals, the first is the number of items returned from the queue manager and the second is the number of items shown, again because you may have some local filtering applied.

MQSCX Extended MQSC Program – Version 8.0.1

Licenced to Paul Clarke

Licence Location: MQGem Office

Connected to ‘MQ800’

DISPLAY QUEUE(SYSTEM.*) =WHERE(CURDEPTH)

QUEUE(SYSTEM.ADMIN.QMGR.EVENT) TYPE(QLOCAL) CURDEPTH(1)

QUEUE(SYSTEM.AUTH.DATA.QUEUE) TYPE(QLOCAL) CURDEPTH(124)

QUEUE(SYSTEM.CHANNEL.SYNCQ) TYPE(QLOCAL) CURDEPTH(1)

QUEUE(SYSTEM.CHLAUTH.DATA.QUEUE) TYPE(QLOCAL) CURDEPTH(3)

QUEUE(SYSTEM.CLUSTER.REPOSITORY.QUEUE) TYPE(QLOCAL) CURDEPTH(2)

QUEUE(SYSTEM.DURABLE.SUBSCRIBER.QUEUE) TYPE(QLOCAL) CURDEPTH(1)

QUEUE(SYSTEM.HIERARCHY.STATE) TYPE(QLOCAL) CURDEPTH(2)

QUEUE(SYSTEM.RETAINED.PUB.QUEUE) TYPE(QLOCAL) CURDEPTH(2)

Total display responses – Received:45 Matched:8

MQ800>

If you’d like to try out either of these products, and you are not currently a licence holder, you may email support@mqgem.com to request a trial licence.

Advertisements

The team at MQGem would love to hear what you think. Leave your comments here.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s