QLOAD version 9.1.1 is released

MQGem Software is pleased to announce that a new version of QLOAD, our queue load/unload tool for IBM MQ, is now available.

The main features of the release are as follows:-

  • Non-QLOAD file can contain property data
    Extending the feature introduced in QLOAD V9.1.0, this allows your delimited file to contain a second set of delimiters to mark where property data to be added to the message is to be found. Look out for a more detailed blog post coming soon.
  • Fully qualified queue name separator character
    If your queue names contain one of the default separator characters that QLOAD looks for, you can now specify exactly which character should be considered a separator to avoid confusion.
    For example to put messages to a queue called Q1/SALES on queue manager MQG2:-

    qload -m MQG1 -f data.qld -$# -oMQG2#Q1/SALES

    or to avoid QLOAD thinking that you want to put messages to a queue called SALES on queue manager Q1, when actually your queue is called Q1/SALES:-

    qload -m MQG1 -f data.qld  -$#-oQ1/SALES
  • Backout queue
    This version of QLOAD will pay attention to the backout threshold (BOTHRESH) and re-queue name (BOQNAME) you have defined on any input queues, and re-queue any messages with an MQMD.BackoutCount that meet or exceed the threshold.
  • Application Name
    If your IBM MQ version is appropriate, QLOAD will set an application name of ‘MQGem Software QLOAD’
  • Summary Display
    The summary display is extended in this version to show more age and size ranges in its output. For example:

    Message Ages
    ============
    
    < 2  secs < 10 secs < 1   min < 1  hour < 1   day < 1  week
    --------- --------- --------- --------- --------- ---------
            0         0         0         0         0         2
    
    < 2 weeks < 4 weeks < 3 month < 6 month  1  year
    --------- --------- --------- --------- --------- ---------
            2         2        13       110         0         0
    
    Youngest Message : 4 Days 2 Hrs 29 Mins 28 Secs
    
    Oldest   Message : 19 Weeks 3 Days 3 Hrs 26 Mins 7 Secs
    
    Message Sizes
    =============
    
    < 100b <  1Kb <  4Kb <100Kb <  1Mb < 10Mb  50Mb
    ------ ------ ------ ------ ------ ------ ------ ------
         1    128      0      0      0      0      0      0
    
    Smallest Message : 4 bytes
    
    Biggest  Message : 368 bytes
  • Counting mode
    Sometimes you might want to simply discover how many messages are on your queue that meet a certain criteria. For example, how many are over a certain age, or how many contain a certain string of text. Older versions of QLOAD could be used to do such a count with a little bit of manipulation using a command like the following:-

    qload -m MQG1 -i Q1 -T05:00:00 -f null

    New in this version, you can specifically request a count of the messages as follows:

    qload -m MQG1 -i Q1 -T05:00:00 -dk

    or if you literally only want the number of the count as output, you can use:

    qload -m MQG1 -i Q1 -T05:00:00 -dK
  • Update Put Date and Put Time
  • Normally QLOAD will fill in all the context fields in a message from the file or queue you are loading from. In this version however, if you wish to do that but with a current PutDate and PutTime, you can use the -Ct option.

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

Advertisements

MQGem Monthly (July 2019)

MQGem Monthly Banner
VOLUME V. – No. 7. TUESDAY, 30 JULY, 2019 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, Q and QLOAD products, our IBM MQ training modules, and interesting articles about IBM MQ.

News

At the beginning of July, a new version of MO71 was released with a number of customer requested features. Read more here.

IBM announced, and released IBM MQ V9.1.3 on the distributed platforms this month, with the z/OS version coming in the early days of August. Read more about this release here, and we’re collecting up posts about it here.

This month, IBM MQ has moved to a new Support site to replace the IBM Service Request Tool. More details in the link.

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 how to simplify the MO71 GUI interface.

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

MO71 version 9.1.2 is released

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

The main features of the release are as follows:-

Combined Date/Time Fields

There are many places where MQ outputs a pair of fields to show the date and time something happened; a queue created, a channel started, alteration of any object. Using these fields is simpler now that MO71 has combined them into a single field, and allowed you to format them as you please. Read more about this feature in a separate blog post here.

Field Units

Many of the MQ configuration and status values are sizes, time intervals or percentage values. Sometimes we don’t remember which units are in use – was that milliseconds or microseconds? MO71 helps your memory by labelling field titles and values, to show the units in use. Further, MO71 allows you type in values using unit labels, for example, next time you need to change the Max Msg Length to 100MB, just type that into MO71 and let it calculate the number for you. Read more about this feature in a separate blog post here.

Understanding Remote Product

When a channel connects to your queue manager, MQ allows you to see what product is at the other end of the channel, i.e. the type of queue manager (z/OS or Distributed), or the type of client (‘C’, Java, XMS and so on). There are a number of 4-character codes to identify each one. Read more about this MQ output field here. MO71 will show you the meaning of this 4-character code to make it easier to understand.

MO71 RPRODUCT

MO71 Channel Status list showing Remote Product field

Making MO71 filters easier to read

The filters in MO71 are one of its most powerful features. You can learn more about these filters in this video about them. One small change in this release that makes filters easier to use is that you can now use AND, OR and NOT operators in place of ‘&’, ‘|’ and ‘!’.

MO71 Filters AND OR NOT

MO71 Filters can now use AND OR and NOT in place of &, | and !


MO71 Show Hide options

MO71 list dialog Show/Hide options

Show/Hide Column Filters

Just as you can show or hide the buttons, toolbar, filter bar and fields on a list dialog in MO71, you can now also show or hide the column filters. All in the right-mouse context menu.

Location Dialog updates

The location dialog has gained a few buttons with useful actions that you need when first setting up your location settings for a queue manager. You can connect and disconnect directly from this dialog, and also view the local INI file and local error log – very helpful if your connection fails and you need to quickly look at the reason.

MO71 Location Dialog new buttons

The MO71 Location Dialog has new buttons

Main Window group status

Your queue manager groups on the main window can now display several pieces of information (in a format of your choosing). The data that can be displayed includes; number of queue managers in the group; number connected, failed and with unknown state and the group name. With the following Group Text set in my preferences dialog:-

%n (Total:%t{ Connected:%c}{ Failed:%f}{ Unknown:%u})

I see the following on my main window. You can of course configure it to exactly what you want to show.

MO71 Main Window Group Title

MO71 Main Window showing Group Titles

Exporting Objects – keeping track

If you automatically download your object definitions using MO71, you may find it useful to be able to see when the last download was actually done. This is now displayed on the Export tab in the Location dialog.

MO71 Export status

See the status of your automatic object exports in the Location dialog

Also, if you exported a list of objects from a list dialog, it is handy to know in your exported report if that list was filtered and didn’t show everything. You can now add the filter and fields from the top of the list dialog to your exported report.

MO71 Export Headings

Add the field and filter contents as headings to your exported report

Averages, rates and units in User Columns

User columns were added in an early version of MO71, and have been enhanced in V9.1.2 to give you the ability to generate numbers which are rate or averages. In addition, your user columns can have units just like the MQ values in your dialogs. Read more about this feature in a separate blog post here.


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 (June 2019)

MQGem Monthly Banner
VOLUME V. – No. 6. FRIDAY, 28 JUNE, 2019 PRICE: FREE

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

News

IBM announced the EOS for IBM MQ V8, the MQ Appliance M2000, and IBM MQ for HP Non Stop V5.3. Read more 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.

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 which shows you how to export IBM MQ definitions using the MO71 product.

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.

Contact Information

Are you looking forward to summer and some time off? 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

MQGem Monthly (May 2019)

MQGem Monthly Banner
VOLUME V. – No. 5. FRIDAY, 31 MAY, 2019 PRICE: FREE

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

News

MQGem was in attendance at the Integration Tech Conference in Texas at the beginning of May – read our report here.

MQGem command line tools are now available on Linux on Little Endian Power

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 which introduces the MO71 product.

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 you’re following lots of IBM MQ blogs. 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

MQGem tools on Linux on Little Endian Power

MQGem is pleased to announce the availability of three of its products on the Linux on Little Endian Power platform.

We have had these products available on Linux on Power for a number of years, and now have added the Little Endian platform to the list.

Thanks to those customers who requested it.

You cannot run a Big Endian application on a Little Endian platform and vice versa. Ensure you download the appropriate version of the tool for the platform you are using. For example, if you try to run the Big Endian version on a Little Endian platform, you will see an error something like this:-

-bash: ./mqscx: cannot execute binary file

If you are not sure which platform you are using, try one of the following commands:-

lscpu

which will show you output similar to:

Architecture:          ppc64le
Byte Order:            Little Endian
CPU(s):                ...

Or if you have an older version of Linux, which doesn’t provide that command, try:-

uname -a

which might give you hint.

Linux gemlnx4.mqgem.com 3.10.0-327.36.3.el7.ppc64le #1 SMP Thu Oct 20 04:58:48 EDT 2016 ppc64le ppc64le ppc64le GNU/Linux

Extra Reading Material


The new versions can be downloaded from the website from the links given above. Any current licensed users of these products can run them on the new platform using their existing licence. If you don’t have a licence and would like to try out any of our products then send an email to support@mqgem.com and a 1-month trial licence will be sent to you.

MQGem at Integration Tech Con 2019

We’ve just finished attending the inaugural event of the IBM Integration Tech Conference in Grapevine, Texas. It was 2½ days of sessions on various integration subjects. There were six tracks:-

  • App Integration
  • Architecture
  • Data Movement
  • Gateway/API
  • Messaging
  • Partner Sessions

spread across five rooms in the Convention Centre at the Great Wolf Lodge. There were 18 unique sessions dedicated to IBM MQ – in fact more than one session to choose from in a number of the time slots. Morag gave one of the MQ technical sessions as mentioned in a previous post. The Convention Centre was an intimate venue so there wasn’t far to walk between sessions. There were almost 400 people in attendance.

There were a number of vendors, like ourselves, in attendance, each with a table from which to ply our wares. Paul gave a number of demos of our products and we gave out product brochures and MQGem mouse mats. We were a little off the beaten track down a corridor to the Lab Room so I don’t think everyone was aware of our position. However we did have some great conversations with some of the people who did find us.

MQGem vendor table

Our vendor table at the conference

It was great to meet and chat with fellow MQ enthusiasts; we learned some great technical information in the sessions; and we hope a similar event is held next year – MQ deserves an annual event dedicated to technical sessions about it.