Configuring List Dialogs in MO71

MO71 is our graphical administration tool for IBM MQ. You can manage all the different object types in MQ using its lists and object dialogs. The lists are fully flexible allowing you to determine which fields are interesting to you and which are not and choosing only to display those columns in the list as a result.

You can make these changes temporarily, just to the instance of the dialog you are currently using. You can make them more permanently, so that every time you bring up that list on that queue manager, you have the same columns. Or finally, you can make these changes across all your queue managers, because the columns you want are the ones you think should be the default set. You can also change the columns in a dynamic manner using filters.

This post will cover these various different mechanisms.

Temporarily alter the list shown

When looking at a list of objects you can change the columns that are displayed by selecting the Options -> Alter List… item from the context menu.

MO71 Alter List Menu

This will bring up a dialog where you can locate the additional columns you want to display. So I’ve got a list of queues, with some cluster queues and I want to see the Cluster Queue Manager that hosts the cluster queues, so I locate the field Cluster Queue Manager Name (CLUSQMGR) in the right hand side of the window in the list of “Remaining Fields”, and move it to the “List Contents” by pressing the  <<  button. Then I can move its position in the columns on the left hand side using the up and down buttons, and press   OK   to complete the change.

MO71 Change Queue List attributes

Now you’ll see that your queue list has the additional column you selected. However, if you close the queue list dialog, and later open another queue list dialog, you’ll see that your alteration to the list of fields shown has been forgotten, it was a temporary change that you made.

Permanently alter the list for one queue manager

Following exactly the same process as above, with one small change, you can make the change permanent for that queue manager. On the dialog which allows you to change the columns shown, instead of just pressing   OK   to make the change, first press Apply All which applies the change to all instances of that particular list dialog for this queue manager, both those currently open, and any future invocations of that list dialog. This change is also remembered across a restart of the MO71 program.

MO71 Change Queue List attributes Apply All

Permanently alter the list for all queue managers

In essence, this mechanism is changing the defaults for list dialogs. If you add a new queue manager to MO71, it will pick up the default columns too.

Using the menu option View -> Set Default Lists -> Queue List… (or whichever list dialog you want to change), you will be presented with a very similar dialog to the one above, except instead of referring to a single queue manager in the window title, it will indicate that it is a “global” list.

MO71 Change global Queue List attributes

Pressing   OK   or  Apply  on the global change list dialog will set the new default and all queue managers that have not had their list changed by the above mechanisms will pick up these new defaults. Pressing Apply All on this dialog will set all queue managers to use this list instead of anything that may have previously been altered by the above mechanisms. Because this is a ‘destructive’ setting (i.e. you lose previous set up you might have done), there is a confirmation dialog for this change. This change is also remembered across a restart of the MO71 program.

MO71 Change global Queue List attributes Confirmation

Changing columns in a filter

You can also change the column display from within a filter. This can particularly useful when creating pre-defined dialogs. Especially if you want to have several different ‘default’ sets of columns.

This can be done in two ways. Firstly by adding a ‘#’ character after a keyword or user variable name, to show it as a column on the end of the display. The example below has a filter which creates a user variable called “Fullness” and as a result of the ‘#’ character on the end, also displays that as a column.

MO71 Fullness column

The other way to manipulate columns from within a filter is to use the showcol and hidecol functions. This is very useful in a pre-defined dialog, allowing you to change the default set of columns to exactly what you need for this dialog. You might, for example, have several different queue lists, one for cluster queues, one for transmission queues, and one for dead-letter queues across all your queue managers. You can imagine wanting slightly different columns on display for each one.

The showcol function takes the MQSC spelling of the keyword and the column position, and the hidecol function just takes the keyword.

MO71 showcol hidecol

Heopfully now you can have exactly the columns you want on display in any list you are viewing. If you have any questions please leave a comment below, or get in touch.


If you don’t have a licence and would like to try out MO71 then send an email to support@mqgem.com and a 1-month trial licence will be sent to you.

Advertisements

MQGem Monthly (August 2017)

MQGem Monthly Banner
VOLUME III. – No. 8. THURSDAY, 31 AUGUST, 2017 PRICE: FREE

Welcome to the August edition of the MQGem Monthly Newsletter, bringing you company news from MQGem Software, information about the MO71, MQSCX, MQEdit, and QLOAD products, and interesting articles about IBM MQ.

News

A new version of MO71, V9.0.5, providing column filters, was released earlier this month. Read more about it here.

Also this month, MQEdit was updated, with V9.0.2 providing formatters for JSON, FIX and CSV (OFS) messages. Read more about it here.

Preparation is well underway for the MQTC conference later in September. Both Paul and Morag will be there, giving MQ technical sessions and at the MQGem Booth in the Sponsor’s Pavilion in the evenings. Come by and say hello.

Interesting IBM MQ links

Here are a few links that caught our eye this month.

We share all the above links on our Twitter feed and Facebook page so if you don’t want to wait until the end-of-month newsletter, follow us on there.

Upcoming events

There are a number of conference events where IBM MQ will be featured in the coming months. Hopefully you’ll be able to sign up to one near you and obtain some MQ technical education.

Upcoming online events

If you’re unable to get to any “in-person” events, then these online webcasts are just what you need.

Product Info

This months highlighted product information is a video showing the API Exerciser in MO71.

IBM MQ Latest Maintenance

Make sure you’re on the latest maintenance level of your version of IBM MQ. These are the latest Fix Packs at the time of going to press. Check here for the latest versions now, and here for the planned dates for the next ones.

Handy IBM MQ Resources

If you want to read blog posts on IBM MQ subject matter, these resources are good places to follow. There are a great number of IBM MQ Experts that write in the IBM MQ Blogosphere.

Contact Information

MQGem hopes to see you at the MQTC Conference. We’d love to hear from you. Get in touch by email or follow us on one of our social media channels.
EmailFacebookTwitterLinkedInYouTubeWordPress

← Previous Newsletter

Looking forward to MQTCv2.0.1.7

MQTC IconIt’s nearly September, and in less than four weeks is the MQTC conference in Sandusky, Ohio.

MQTC – the only conference dedicated to IBM MQ – takes place from September 25 to September 27. There is a full schedule of technical sessions as well as a number of vendor sessions. There’s also lots of information about the conference on the CapitalWare Blog, and you can follow the twitter hashtag #MQTC2017.

MQGem Software is a Gold Sponsor of the conference, so come and find us in the evening Sponsor Pavilion, held in the Zambezi room, on Monday and Tuesday, and we can demonstrate any of the MQGem products to you and you can enter our prize draw. Or just grab a beer from the bar and come and say “Hello”.

Paul Clarke and Morag Hughson will be there from MQGem Software, doing a number of technical sessions:-

Title:
Speaker:
Scheduled:
Introduction to the MQI
Morag Hughson
Monday 1:00pm Leopardwood; Tuesday 2:30pm Aloeswood
Abstract: This entry level session will teach the basics of the beautifully simple MQ API – the MQI. You’ll have heard many describe how writing an application for MQ is very simple, just MQPUT a message, or MQGET a message. Come to this session and learn it for yourself. Example code in C and COBOL will be used, and a live demonstration using an API Exerciser will show how some of the input and output fields operate.
Title:
Speaker:
Scheduled:
Learn to code the MQ Message Property MQI calls
Morag Hughson
Monday 3:50pm Rosewood; Wednesday 9:50am Leopardwood
Abstract: This session will introduce you to the MQI message property calls. You’ll learn how to create message handles, and use them to populate, or read message properties on an IBM MQ message. Example code in C and COBOL will be used, and a live demonstration using an API Exerciser will show how some of the input and output fields operate.
Title:
Speaker:
Scheduled:
Using Application Activity Trace
Morag Hughson
Tuesday 9:50am Aloeswood; Wednesday 3:50pm Aloeswood
Abstract: Application Activity Trace is a feature of IBM MQ that allows you to discover exactly what the applications connected to your queue manager are doing. You can see the object names that they open and the options they use on the various verbs they call. You can find out about the size, persistence, priority and more, of your messages. Please note, this feature is only available on the Distributed platforms.
Title:
Speaker:
Scheduled:
Introduction to MQ Clients
Paul Clarke
Tuesday 8:30am Aloeswood; Wednesday 1:00pm Leopardwood
Abstract: This session introduces the IBM MQ clients: what they are, on which platforms they run, and how customers use them in their applications. We will mainly focus on the ‘C’ IBM MQ MQI client, but will also introduce the Java and XMS clients. The session will also discuss a number of basic implementation considerations, including when it may be appropriate to use each client and describe new client features. The intent is to familiarize you with the things necessary to succeed with a simple IBM MQ client implementation.

Paul will also be giving two vendor sessions:-

Title:
Speaker:
Scheduled:
The MQGems – MQ Administration tools from MQGem Software
Paul Clarke
Monday 11:15am Rosewood
Abstract: In this session, Paul Clarke, founder and CEO of MQGem Software, will take you through the administration tools that MQGem produces. This includes MO71 – our GUI administrator for MQ and MQSCX – a huge improvement on MQSC. The presentation will be largely based on demonstrations of the tools.
Title:
Speaker:
Scheduled:
The MQGems – Message manipulation tools from MQGem Software
Paul Clarke
Wednesday 11:15am Leopardwood
Abstract: In this session, Paul Clarke, founder and CEO of MQGem Software, will take you through the message manipulation tools that MQGem produces. This include MQEdit – our GUI Message editor for MQ, and QLOAD – the load/unload messages tool. The presentation will be largely based on demonstrations of the tools.

We look forward to seeing you there!

MQEdit version 9.0.2 is released

MQGem Software is pleased to announce that a new version of MQEdit, our Live Parsing Editor for IBM MQ messages, is now available.

MQEdit already had formatters for standard MQ messages such as MQXQH, MQDLH and MQPCF and XML and EDIFACT messages.

This release adds new formatters for JSON, FIX and CSV (OFS) messages.

MQEdit Formatted JSON Customer Record

MQEdit Formatting a JSON Customer Record

You can tie these new formatters to your messages just as you do user formats. Given it’s most likely that these will have an MQ Format of MQSTR, you should tie the formatter to the queue name, as follows.

queue APP1.CUSTOMER.ADDRESS
{
  formatter JSON;
}

Alternatively you can use the Formatter context menu when viewing a message to invoke the appropriate formatter.

MQEdit Formatter menu

MQEdit Formatter menu

You’ll also see another useful option in this menu, the “Contextual Newline”. This inserts the appropriate character into the message when you hit the enter key. Very useful for formats such as FIX where the newline character is the SOH (0x01) character.


The new version can be downloaded from the MQEdit Download Page. Any current licensed users of MQEdit can run the new version on their existing licence. If you don’t have a licence and would like to try out MQEdit then send an email to support@mqgem.com and a 1-month trial licence will be sent to you.

MO71 version 9.0.5 – Column Filters

MQGem Software is pleased to announce that a new version of MO71, our GUI Administrative tool for IBM MQ, is now available.

This release was created for one specific requested feature – Column Filters.

MO71 has a very powerful filtering capability already, but with power often comes complexity and some find this daunting to learn. The introduction of column filters allows for, very easy to use, filtering by columns, to reduce the amount of data you are looking at on a list dialog.

To use it, look in the column heading of a column in a list dialog, and you will see a new filter icon. Click on this icon and a filter dialog will pop-up. This dialog will look a little different depending on the type of attribute you are trying to filter. For strings, you can type in a string, or part of a string to match on; for integers you can provide a minimum and/or maximum; and for enumerated values, you can see all the possible values and select or deselect them.

MO71 Column Filters

The column filter dialog shows the number of each type

In the case of enumerated values, you also see a count of how many of each value there are in the current list dialog. This can be handy in itself without using any filtering!

Now I can reduce the amount of data shown in my list, by deselecting the values that I am not interested in at the moment.

MO71 Column Filtered

Use the check boxes to reduce what is shown

In case you forget that you have filtered the list, and wonder where your other objects are, there are two visual clues that filtering is currently in effect. Firstly, the icon in the column heading changes to show that a filter is active, and the count of objects displayed does not match the total number available as shown in the bottom right of the window.

MO71 Indication of Filtering

You can tell that your display is filtered

You can filter on several columns at once in a single dialog, and so if you later want to turn them all off, you can do so with one click, using either the context menu option, Options -> Remove Column Filters, or the toolbar button for the same.


The new version can be downloaded from the MO71 Download Page. Any current licensed users of MO71 can run the new version on their existing licence. If you don’t have a licence and would like to try out MO71 then send an email to support@mqgem.com and a 1-month trial licence will be sent to you.

MQGem Monthly (July 2017)

MQGem Monthly Banner
VOLUME III. – No. 7. MONDAY, 31 JULY, 2017 PRICE: FREE

Welcome to the July edition of the MQGem Monthly Newsletter, bringing you company news from MQGem Software, information about the MO71, MQSCX, MQEdit, and QLOAD products, and interesting articles about IBM MQ.

News

A new version of MO71, V9.0.4, was released earlier this month. Read more about it here.

Both Paul Clarke and Morag Hughson will be representing MQGem Software at this year’s MQTC conference.

QLOAD V9.0.2 was released near the end of the month with a feature specifically requested by a customer. Read more about the Required Rate function.

MQSCX V9.0.1 was released right at the end of the month with a mini-release mainly to give you the ability to issue RESET QSTATS as an MQSC command. Read more about it here.

Interesting IBM MQ links

Here are a few links that caught our eye this month.

We share all the above links on our Twitter feed and Facebook page so if you don’t want to wait until the end-of-month newsletter, follow us on there.

Upcoming events

There are a number of conference events where IBM MQ will be featured in the coming months. Hopefully you’ll be able to sign up to one near you and obtain some MQ technical education.

Product Info

This months highlighted product information is a video showing the powerful filtering provided by MQSCX.

IBM MQ Latest Maintenance

Make sure you’re on the latest maintenance level of your version of IBM MQ. These are the latest Fix Packs at the time of going to press. Check here for the latest versions now, and here for the planned dates for the next ones.

Handy IBM MQ Resources

If you have a question about IBM MQ that you can’t find the answer to, these resources are good places to ask your question.

Contact Information

MQGem hopes you are enjoying your summer holidays. We’d love to hear from you. Get in touch by email or follow us on one of our social media channels.
EmailFacebookTwitterLinkedInYouTubeWordPress

← Previous Newsletter Next →

MQSCX version 9.0.1 is released

MQGem Software is pleased to announce that a new version of MQSCX, our command line extended MQSC tool for IBM MQ, is now available.

This is a mini-release, specifically to release the first of the below features. But then we added a couple more things at the same time!

Issue RESET QSTATS as an MQSC command

Sparked by a conversation on MQSeries.net we were intrigued when one user asked us whether it would be possible to provide RESET QSTATS as an MQSC command on the distributed platforms using MQSCX. Turns out it is possible!

Support certlabl on connect

The =conn command provides for a number of client channel configuration attributes, and now certlabl is among them.

The Any Key

Press Any Key?

Provide a simple way of getting user key input

This version introduces the getkey() function which will return the next key pressed by the user. This can be useful to, for example, navigate your way through a script menu, or to exit from a while loop in a script at the user’s command.


The new version can be downloaded from the MQSCX Download Page. Any current licensed users of MQSCX can run the new version on their existing licence. If you don’t have a licence and would like to try out MQSCX then send a note to support@mqgem.com and a 1-month trial licence will be sent to you.