MQGem recently delivered a new version of MO71 that supports the new IBM MQ V9 release. As well as support for the new command level, there were a number of other features in this new version of MO71. One of those new features was a customer request for a way to view Buffer Pool and Pageset Usage.
You’ve always been able to see this through the MQSC window (which is your fallback for any command that MO71 doesn’t have a specific menu or dialog for), which would show you a display something like this:-
CSQI010I M901 Page set usage ... Page Buffer Total Unused Persistent NonPersist Expansion set pool pages pages data pages data pages count _ 0 0 1078 1042 36 0 USER 0 _ 1 0 1078 1059 19 0 USER 0 _ 2 1 1078 897 181 0 USER 0 _ 3 2 1078 976 0 102 USER 0 _ 4 3 1078 1056 17 5 USER 0 _ 25 3 1078 1078 0 0 USER 0 End of page set report
In the latest version of MO71 you can now view this same data in a standard MO71 dialog.
This means that you have all the usual manipulation capabilities at your fingertips. For example, you can sort any of the columns simply by clicking on the title; you can rearrange the order of the columns, or exclude columns that you are not interested in; you can export the data in CSV format to import into your favourite spreadsheet or graphing program; and you can write filters to work with the data and colour rows that meet a certain criteria.
Here’s one such example of how you might want to manipulate this data just to give you an idea. You can write filters in MO71 to make a new column with a calculation of your own based on the other data available.
Here’s a filter that adds a new column (the ‘#’ character causes the new column) containing a floating point variable (the ‘@@’ makes the variable a floating point number, where a single ‘@’ would be an integer) which is the percentage of the ‘Total Pages’ that are ‘Persistent Pages’. You can call the variable anything you like and it’s name will become the column heading. N.B. The filter is a boolean expression, so to ensure every row is still shown, we finish the expression with “1”.
@@PercentPsist# := PSISTPG*100/TOTALPG; 1
You can sort your new column from within the filter (or by clicking on the heading just as with any other column).
sortd(@@PercentPsist# := PSISTPG*100/TOTALPG); 1
You can go further still and colour the rows that meet a certain criteria, for example, any Pageset with more than 10% of persistent pages.
sortd(@@PercentPsist# := PSISTPG*100/TOTALPG); bg(@@PercentPsist# >10,red); 1
Buffer Pool Usage
As with Pageset Usage, the same MQSC command DISPLAY USAGE also shows you the Buffer pool attributes. While issuing the command through MQSC would report both tables to you, in MO71, each set of information is in a separate table, since the columns are of course different for each set of information.
CSQI065I M901 Buffer pool attributes ... Buffer Available Stealable Stealable Page Location pool buffers buffers percentage class _ 0 1000 963 96 4KB BELOW _ 1 1000 821 82 4KB BELOW _ 2 1000 894 89 4KB BELOW _ 3 1000 782 78 4KB BELOW End of buffer pool attributes
So the above information can also be seen, and manipulated, in an MO71 list dialog.
Note that this feature is available for any version of Queue Manager – it is not a IBM MQ V9 feature. If you are a current MO71 licence holder, you can simply download the new version of MO71 and start using it. If you’re not a current licence holder, and you’d like to try out MO71, please email email@example.com to request a trial licence.