Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
MXG - Processing Compressed DB2 SMF records

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1657
Location: Tirupur

PostPosted: Thu May 10, 2018 12:47 am    Post subject: MXG - Processing Compressed DB2 SMF records
Reply with quote

Hi,

We are planning to enable DB2 SMF compression. We generate around 15 GB of DB2 SMF from the accounting records and buffer pool statistics information.

The DB2 SMF is currently processed by MXG.
Is anyone aware of how much increase in CPU time we could expect to process compressed DB2 SMF vs uncompressed DB2 SMF?

Like a rough ballpark ratio.

Thank you,
Vasanth.S
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


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

PostPosted: Thu May 10, 2018 12:58 am    Post subject: Reply to: MXG - Processing Compressed DB2 SMF records
Reply with quote

SOURCLIB member NEWSLTRS mentions a 2012 study showing about 141 TCB seconds to process (decompress) 2 million DB2 records; I don't see anything comparing compressed versus uncompressed times.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1657
Location: Tirupur

PostPosted: Thu May 10, 2018 2:53 am    Post subject:
Reply with quote

Thank you Robert, That gives some perspective. It sounds a little expensive.
I'll test the scenario in our test system and see how it fares

Regards,
Vasanth.S
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DFSMShsm Dataset Recovery with B and ... Joerg.Findeisen JCL & VSAM 2 Sat Oct 05, 2019 10:01 pm
No new posts Duplicating records in a PDS memebr/I... imcoolleo COBOL Programming 5 Mon Sep 16, 2019 3:32 pm
No new posts Compare duplicate records in same file pshongal DFSORT/ICETOOL 3 Fri Aug 09, 2019 9:37 am
No new posts How to count duplicate key records co... sergeyken SYNCSORT 0 Thu Jul 25, 2019 8:03 pm
No new posts Sort records within a data block rajiv rengasamy DFSORT/ICETOOL 0 Fri Jul 12, 2019 3:25 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us