IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Detailed Transaction History report from SMF 110 Subtype 1


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Kyle Carroll

New User


Joined: 31 Aug 2016
Posts: 10
Location: USA

PostPosted: Tue Oct 18, 2016 12:42 am
Reply with quote

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
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Tue Oct 18, 2016 2:09 am
Reply with quote

Hi,
Do you have MXG or MICS at your shop?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Tue Oct 18, 2016 3:21 am
Reply with quote

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
View user's profile Send private message
Kyle Carroll

New User


Joined: 31 Aug 2016
Posts: 10
Location: USA

PostPosted: Tue Oct 18, 2016 6:54 pm
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Tue Oct 18, 2016 7:16 pm
Reply with quote

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
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Tue Oct 18, 2016 10:07 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CICS

 


Similar Topics
Topic Forum Replies
No new posts Looking for a little history of ISPF ... TSO/ISPF 5
No new posts How to identify the transaction categ... IMS DB/DC 3
No new posts Need help on formatting a report DFSORT/ICETOOL 14
No new posts Creating Report using SORT DFSORT/ICETOOL 7
No new posts Ca7 long running jobs report All Other Mainframe Topics 1
Search our Forums:

Back to Top