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

MXG - Processing Compressed DB2 SMF records


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1689
Location: Tiruppur, India

PostPosted: Thu May 10, 2018 12:47 am
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: 8569
Location: Dubuque, Iowa, USA

PostPosted: Thu May 10, 2018 12:58 am
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: 1689
Location: Tiruppur, India

PostPosted: Thu May 10, 2018 2:53 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Merging more than two records DFSORT/ICETOOL 15
No new posts Matching and non matching records usi... DFSORT/ICETOOL 11
No new posts REMOVE DUPLICATE RECORDS BASED ON A S... DFSORT/ICETOOL 4
No new posts Using sort on VB records based on off... DFSORT/ICETOOL 6
No new posts Inserting records into the empty segm... IMS DB/DC 1
Search our Forums:

Back to Top