View previous topic :: View next topic
|
Author |
Message |
Kyle Carroll
New User
Joined: 31 Aug 2016 Posts: 10 Location: USA
|
|
|
|
Is there a CICS TS 4.1 program and JCL available that I can use to produce a CICS TS 4.1 transaction history report from SMF 110 subtype 1 records?
I am looking for the report to be one line per transaction.
Thanks,
Kyle. |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Hi,
Do you have MXG or MICS at your shop? |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
If your site has one of the CICS reporting tools available (MXG, MICS, TDS, CICS PA, CA-JARS, SAS IT Resource Manager), then you would best use it to analyze the data.
If your site does not have one of the CICS reporting tools, you need to be aware that correctly interpreting the SMF type 110 records is NOT a simple task. You need to find and retain the dictionary record written each time the CICS region starts up (or when monitoring is turned on for the region) in order to correctly evaluate the various monitor components of the SMF 110 subtype 1 record. Furthermore, every recent version of CICS compresses its data so you need to run the SMF 110 records through the decompression routine before you attempt to use the dictionary to define and extract the data fields you're wanting. Tools like MXG do the decompression and matching for you automatically.
If you are going the do-it-yourself route, research DFHMNDUP and DFH$MOLS as you will become VERY familiar with them. |
|
Back to top |
|
|
Kyle Carroll
New User
Joined: 31 Aug 2016 Posts: 10 Location: USA
|
|
|
|
Thanks for the response.
We are a small shop and don't have those tools.
I was hoping that CICS TS 4.1 would have some reporting that would read the SMF 110 subtype 1 records and give me a report of the detail transaction history. I could have then take that report output and feed it into an Excel.
I tried to read the SMF records (after uncompressing it) in a REXX and it worked for much of the data I needed but some of the fields are packed or binary (Transaction dates and time) so that is where I got stuck on.
We do have Omegamon XE V5.3 but it appears they removed the reporting piece in that version and require other tools to do the reporting. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Unfortunately, IBM does not make available any easy way to produce reports from the SMF 110 data.
There were a series of articles back in 2013 in IBM Systems Magazine that discussed reading SMF data in REXX. Part 2 from April has REXX code to read, for example, the date / time stamp and convert it: REXX Offers Tools for Automated Processing of SMF Data but you will want to read the entire set of articles.
Rather than using REXX, you could use COBOL or other language to read the SMF data. |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Quote: |
Omegamon XE V5.3 but it appears they removed the reporting piece in that version and require other tools to do the reporting. |
sucks when they upgrade a product and remove its features. EPILOG for Omegamon was nice to use - online & batch. |
|
Back to top |
|
|
|