CICS Explorer V5.4 provided, among other things, a quick filter option to examine your CICS resources in more detail. Now, CICS Explorer V5.5 adds aggregation support. This is similar to the CPSM WUI’s summarize function and offers a new way to look for anomalies in your CICS resources and definitions.
To try the aggregation function out, you’ll need CICS Explorer V5.5 and to enable the CMCI JVM server within CICS TS V5.5. (more details in the Knowledge Center).
Aggregation – an example
We’ll introduce the idea of aggregation with a scenario; you’ve received a report from one of your users that your application is failing intermittently. The error message is something to do with a file.
We open the Local Files view to get started. There’s a lot of data in the open files view and we’ll need to cut this down somehow.
We know that the app in question is installed across a few regions and uses a few different files – ACCOUNT, LOG, and CUST. A quick way to start to make sense of the data in the Local Files view would be to use the new aggregation feature to group on the name of the file. We do this by right-clicking on the Name column and choosing Group By.
Grouping by Name collects resources together so that each row represents multiple resources with the same name. Attributes in other columns are aggregated by details they have in common and using asterisks (*) where there is a difference. This means you can quickly spot differences between large numbers of similar records by looking for *s!
In the next screenshot, you can see that out of the 33 files, we have 8 unique names. The Name column, which is the grouping column, is highlighted and brought to the left hand side for clarity. The Count column on the far left indicates how many resources are represented by each row.
Also in the same view, for LOG files, we can see that there are 3 resources with a common region name of IYCWEZ*1 between them, where the * indicates that there is a difference between some of the resources. The status of the records also appears to be different between the 3 records because it is shown as ****. We want to see what that difference is. We do that by right-clicking on the row and choosing Expand. This opens a new view next to the local files view we were using and you can see that expand has automatically added a filter for the file name “LOG”.
The expanded log view shows that the LOG file has been disabled on IYCWEZH1. This is likely the cause of the intermittently failing application.
More control over aggregation
We’ve also introduced two new toolbar buttons to the views, that provide some additional control over how aggregation works. The first button allows you to toggle aggregation of records. The second button shows a menu with options to customize grouping and aggregation (screenshot below).
The menu options in this second toolbar button allow you to see and change exactly what groups you have set, and the way attributes are aggregated, such as taking the average, maximum, minimum, or sum for numeric fields.
If these toolbar buttons are disabled, the most likely reason is that you’ve not yet set up the server correctly.
You can find more detail about the specifics of using and configuring aggregation in the CICS Knowledge Center.
Taking this further
We’d love to hear your thoughts once you’ve tried this; do comment on this blog post with suggestions or questions. We’ll be providing more blog posts in the near future that will take you through some more advanced ideas like how you can use new GraphQL API that provide support for aggregation in your own applications and scripts.