Special Guest: Ian Bjorhovde Principal Consultant at DataProxy LLC
DB2 LUW Data Security 102
90% of our audience learned something! Security isn't sexy, but it is important, especially if you've been a victim of identity theft or endured a data breach. During this show, Ian Bjorhovde "The Master of DB2 Security" shares valuable information and advice on how to achieve a more secure DB2 database environment. Please learn from, and enjoy, the replay...
Special Guest: Michael Tiefenbacher Manager Business Services & Data Management Specialist at ids-System
Facilitate WLM Functions and Tools to Improve Your DB2 LUW Monitoring
100% of our audience learned something! If you don't have tools, you need to be clever about monitoring DB2 with built-in monitoring capabilities. During this show, Michael does a great job of explaining how DB2 Workload Manager (WLM) features and functions can be used for capturing and analyzing SQL, histograms, and system statistics. Enjoy the replay ...
Sage DB2 LUW Performance Advice
Advanced Index Benefit Analysis
BLU Table Convert Row to Column Analysis
100% of our audience learned something! In Sage Advice Part 1 during Episode #142, Scott teaches audiences how to find the biggest problems in DB2 based on weights. In Sage Advice Part 2 during this Episode, Scott teaches audiences how to accurately determine the benefit of each index recommended by IBM program "db2advis". As a bonus, if you are using DB2 10.5, Scott provides a methodology and queries for quickly and easily determining if a Row based table should be converted to BLU Column based. Sage Advice Part 3 "Predictive Index Impact Analysis" will be offered at IDUG conferences in 2016 - hope to see you in AUSTIN Texas at IDUG! Watch and learn...