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 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: 10
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: 1521
Location: Chennai

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: 8151
Location: East Dubuque, Illinois, USA

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: 10
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: 8151
Location: East Dubuque, Illinois, USA

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: 1521
Location: Chennai

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 Delete IMS remote transaction when MO... Sam Singh IMS DB/DC 0 Wed Aug 23, 2017 9:12 pm
No new posts Need to track the CICS transaction fr... sam8051 CICS 3 Mon Aug 07, 2017 3:11 pm
No new posts CICS Transaction attach count of supp... lind sh CICS 1 Wed Jun 21, 2017 1:33 pm
No new posts Report cost in CA-dispatch Nileshkul CA Products 3 Wed Jun 07, 2017 10:32 pm
No new posts CICS Transaction Timeout Hooman24 CICS 2 Sun Apr 16, 2017 2:16 pm

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