The DB2Night Show #162: DB2 LUW pureScale Performance with Steve Rees, IBM


Posted by Scott on September 25, 2015, 4:21 pm
in DB2 LUW ( The DB2Night Show)







title="Steve Rees on LinkedIn">
Steve Rees, IBM STSM


@db2steve


Special Guest: Steve Rees, IBM STSM



DB2 LUW pureScale Performance

Config, Monitoring, and Best Practices!



100% of our audience learned something! Steve is one of the top DB2 LUW performance gurus at the IBM Canada Lab, and he gives great presentations too! Today was no exception! Steve covered recommended configurations, how to monitor DB2 pureScale, and offered his sage advice based on his worldly experiences. Watch and learn...








title="Steve Rees on LinkedIn">
Steve Rees, IBM STSM


@db2steve


Special Guest: Steve Rees, IBM STSM



DB2 LUW pureScale Performance

Config, Monitoring, and Best Practices!



100% of our audience learned something! Steve is one of the top DB2 LUW performance gurus at the IBM Canada Lab, and he gives great presentations too! Today was no exception! Steve covered recommended configurations, how to monitor DB2 pureScale, and offered his sage advice based on his worldly experiences. Watch and learn...






Show Host Scott Hayes Commentary



Are you using pureScale? A surprising 7% of our audience was currently using it - other attendees were considering it or just attended to learn for education purposes. Speaking of education, do you have your copy of the DB2 10.1/10.5 Certification Book yet? We featured the authors, Kent Collins and Mohan Saraswatipura, this past February during episodes #148 and #150. See book details on Amazon.com.


DB2 pureScale performance - Topics Cloud



Here are just a few things that you are going to learn about: pureScale configuration, cluster geometry, cluster components, scaling up, cpu/memory/disk ratio recommendations, monitoring pureScale locking, bufferpools, the cluster cache facility (CF), the interconnect, and disk performance, CF_DB_MEM_SZ, CF_GBP_SZ, Infiniband vs. RoCE, how to smartly use SSD, how to avoid inode contention, LOCKLIST requirements, pool_data_lbp_pages_found, pool_data_gbp_l_reads, ool_data_gbp_p_reads, pool_data_gbp_invalid_pages, pool_async_data_gbp_l_reads, computing the GBP (Global Bufferpool) hit ratio, mon_get_page_access_info, sample SQL commands, recommended page sizes, random indexes, env_cf_sys_resources, and, of course, MORE!


More from Steve Rees



Want to learn more from Steve? Check out these replays of past shows:







A message from our sponsor:

DBI Software


During today's quick 3 minute commercial, DBI demonstrated some performance trend charts that are complete with change indicators plotted on the charts. DBI has been automatically tracking important database change events since V8.2 of DB2. Change events are plotted on trend charts so that you can see the performance consequences of any changes. Trend charts without changes are, at best, merely pretty. Do you want pretty, or do you want clear results?









Magic Hat Money

Working with DBI is like making money magically appear!


Typical customers enjoy 40-60% CPU utilization reductions in the first week, plus measurably faster
transaction and query response times. More importantly, your time savings will be substantial!
Read our newest title="Press Release: DBI and HealthPlan Services celebrate DB2 LUW successes!">SUCCESS STORY with
HealthPlan Services, do your target="NEW" title="Learn about the high cost of 'free' tools and do your due diligence">due diligence,
and speak with as many references as you have time to call.


We saved a health care company $250,000 in one afternoon, solved a performance problem in two hours that two senior
DBAs were unable to solve in six months, and we have helped top brand name retailers achieve top ranked e-Commerce
performance on Black Friday multiple years in a row. 8 of the Top 25 Retailers, plus others, plus top Banks,
State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you?
target="NEW" title="Let's have a conversation - Contact DBI">Contact DBI






Join The DB2Night Show™ LinkedIn Group


The DB2Night Show™ has a LinkedIn Group. The
"closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including
future shows and replay information, and, if you like, start some discussions about the show! href="http://www.linkedin.com/groupRegistration?gid=2761037" target="NEW" title="New Window: Join The DB2Night Show LinkedIn Group">Join The DB2Night Show LinkedIn Group!




Get the Download Replays




Click Here for Replays



PDF Handout



A PDF handout was distributed to live show attendees. Do you like handouts? Join our shows live! If our guest makes handouts available, they'll be distributed via GoToWebinar during the live shows.


Sharing is Caring!


Share a great show with your friends and followers!
















Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=638