Over the last few months I have been asked about how to get MainView historical data into third party software or in-house written applications. While BMC has always provided multiple ways to do this, we now have a single, more consistent method available to extract and transform MainView historical data. It will provide you an easier integration with more metrics to your third-party applications, better reporting and improved audit capabilities allowing you to make better data-driven decisions and spend less time answering audit requests.
We are excited to deliver two new utilities with the MainView Infrastructure in two small programming enhancements. The first utility allows you to automate the extraction of the historical data into the standard archive files or create a GDG, so you can save the data for as long as you wish and will no longer miss an archive. The second utility is a transformation utility that simplifies the selection of the metrics you are interested in with easy SQL-like statements.
The extraction utility will pull the data from online history files and store them in a GDG. It can also extract directly into a follow-on job step such as Merrill Associates MXG for use in creating a PDB or other reports. The extraction utility can be used in conjunction with sort statements, that are built using the Data Maps provided in BBSAMP. You can select only the metrics that you wish to use in an application, which is important in applications such as Splunk where the amount of data sent directly influences the cost.
Using sort is fast and uses less processor, but sometimes requires an expert to figure out the offsets and write the sort statements. This leads us to the second utility, an alternative to using sort, the data transformation utility. This utility will allow you to take the data from the extraction utility and with easy to write SQL-like select statements pull from the extracted data directly by the element name. You no longer need to figure out the offsets or create sort statements. The output can be a CSV file which is easily loaded into almost any third-party application. This utility will also take advantage of the Data Maps that are provided by the MainView products for assuring the appropriate metrics are gathered based on your select statements.
Data maps are being provided by each individual product and are in BBSAMP today. The format of the name of the data map will be a tlaTDM where tla is the three-letters associated with the product. For example, the data map for MQ is BBSTDM. Today maps are available for AUTOperator, MQ, and CICS with others following in short-order.
For information on how to get and implement the extraction utility please follow this link.
For information on how to get and implement the transformation utility please follow this link.
The MainView Infrastructure provides a common set of services and architecture that delivers a single view and control of your environment, centralized administration, intelligent alarms and proactive automation to provide a highly efficient, and holistic systems management experience. To learn more about the MainView Family visit the MainView Systems Management site to see how you can transform your mainframe systems management today.