Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Detailed Transaction History report from SMF 110 Subtype 1

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
Kyle Carroll

New User


Joined: 31 Aug 2016
Posts: 9
Location: USA

PostPosted: Tue Oct 18, 2016 12:42 am    Post subject: Detailed Transaction History report from SMF 110 Subtype 1
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: 1445
Location: Azeroth

PostPosted: Tue Oct 18, 2016 2:09 am    Post subject:
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: 7913
Location: Bellevue, IA

PostPosted: Tue Oct 18, 2016 3:21 am    Post subject: Reply to: Detailed Transaction History report from SMF 110 Subtype 1
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: 9
Location: USA

PostPosted: Tue Oct 18, 2016 6:54 pm    Post subject:
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: 7913
Location: Bellevue, IA

PostPosted: Tue Oct 18, 2016 7:16 pm    Post subject:
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: 1445
Location: Azeroth

PostPosted: Tue Oct 18, 2016 10:07 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am
No new posts How to calculate an specific transact... lind sh CICS 2 Tue Sep 13, 2016 9:20 pm
No new posts Daily report to be extracted from CA ... polymathtarun DFSORT/ICETOOL 5 Mon Jul 11, 2016 4:33 pm
No new posts Report view in Mobile devices Robert Sample All Other Mainframe Topics 0 Thu Jun 23, 2016 7:05 pm
No new posts COBOL Report view in Mobile devices balaji81_k COBOL Programming 4 Thu Jun 23, 2016 6:41 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us