The DB2Night Show #163: DB2 LUW BLU Concepts and Best Practices

@db2guy

Special Guest: Matt Huras IBM DE, Chief Architect DB2 LUW DB2 LUW BLU Concepts and Best Practices! 100% of our audience learned something! Matt Huras fills session rooms at IDUG conferences, and today our studio audience size was rather large as well. And, it is no wonder - Matt has a gift for explaining complicated technical things and making them understandable. He's an excellent presenter too. As Chief Architect for DB2 LUW, who would know better about how DB2 works!?!? Enjoy our replay! Watch and learn...

Show Host Scott Hayes Commentary

Wow. My head is still spinning. I think I just had a large glass of IBM BLU punch. Great job Matt, and thanks for being our guest and sharing best practices information with our DB2 community.

DB2 LUW BLU - Topics Cloud

Here are just a few things that you are going to learn about: DB2_WORKLOAD, DB2 compression, actionable compression, SIMD, data skipping, MON_GET_TABLE, AVG_COLS_REF_PER_QUERY, operating system recommendations, CPU, Core, and Memory recommendations, DFT_TABLE_ORG, SORTHEAP, SHEAPTHRES_SHR, AUTO_REORG, autoconfigure using mem_percent 90 (if database owns the server), tablespace best practices, define columns as NOT NULL (if possible), informational constraints, use LOAD to populate, sort before load, need ample memory for UTIL_HEAP_SZ, SYSCAT.TABLES, PCTENCODED, PCTPAGESAVED, LOGBUFSZ, When Inserting, Commit in large batches (greater than 1,000) if possible, and, of course, MORE!

More shows on DB2 LUW BLU

Want to learn more about BLU? Check out these replays of past shows:

• Episode #159, June 5, 2015 "10.5 BLU Monitoring In-Depth " with David Kalmuk, IBM STSM
• Episode #141, October 17, 2014 "V10.5 CANCUN Shadow Table Experiences " with Iqbal Goralwalla, Triton
• Episode #140, October 3, 2014 "V10.5 CANCUN Overview " with George Baklarz, IBM
• Episode #138, September 5, 2014 "Upgrading to DB2 V10.5 Best Practices! " with Melanie Stopfer, IBM
• Episode #116, October 4, 2013 "Intimate Details- DB2 BLU with IBM Master Inventors " with Guy Lohman and Shankar Raman, IBM

A message from our sponsor:
DBI Software

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 SUCCESS STORY with HealthPlan Services, do your 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? 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 includingfuture shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!

Get the Download 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!