View Buffer Pool and Pageset Usage via MO71

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.

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.

MO71 Pageset List

View Pageset Usage in an MO71 List 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
MO71 Pageset List Filtered

MO71 Pageset List manipulated with a Filter

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.

MO71 Buffer Pool List

Viewing the Buffer Pool usage in MO71

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 support@mqgem.com to request a trial licence.

Advertisements

2 thoughts on “View Buffer Pool and Pageset Usage via MO71

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