Skip to content

ibm-messaging/mq-smf-csv

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

82 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

mq-smf-csv

Basic formatter for IBM MQ's z/OS SMF records that can run on workstations to simplify import of statistics to spreadsheets and databases.

Description

On z/OS, IBM MQ generates SMF accounting and statistics records to track the usage of the product. These are often used for capacity planning, for performance tuning, or for chargeback.

This package has been created to simplify the task of doing your own analysis of MQ SMF records from a z/OS system, by making it easy to import formatted records into a database or spreadsheet.

The program takes the data from a z/OS dataset, downloaded to a local file, and then runs on a Windows or Unix system, creating standard CSV (comma-separated value) output files.

Unlike packages such as SupportPac MP1B, there is no interpretation at all of the SMF data. That can be done by your own spreadsheet or database programs and macros.

This makes the code for the program very easy to understand; all the structures in the SMF records are printed directly.

See mqsmfcsv.doc for more information on using or building this code, and thoughts on possible enhancements to the code or this repository.

Recent enhancements to the package have gone beyond the primary SMF formatters for the MQ 115 and 116 records. The program can now also format MQ AMS (180) and z/OS Connect EE (123) records. But the name of the program is not changing to reflect that broader scope.

Pull requests

Contributions to this package can be accepted under the terms of the Developer's Certificate of Origin, found in the DCO file of this repository. When submitting a pull request, you must include a statement stating you accept the terms in the DCO.

About

Simple formatter for MQ's SMF records to assist with import to spreadsheets and databases

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages