DB2 Best Practice videos are now available!
These videos are located on the DB2 for z/OS Best Practices developerWorks website.... http://www.ibm.com/developerworks/data/bestpractices/db2zos/
There are 56 Best Practices located at this site covering DB2 for z/OS, DB2 Tools, and QMF.
From the best practice pages on this site you can view the videos (streamed from YouTube), download a copy (MP4) to your local machine, download a transcript, and download slides when available.
DB2 for z/OS Best Practice: FlashCopy and DB2 for z/OS
This Best Practice covers FlashCopy and its uses in conjunction with DB2 for z/OS. It gives you an overview of FlashCopy, how the DB2 utilities use it, and how you can affect the behavior in your environment. How to use FlashCopy to takes backups of data outside of DB2’s control is discussed. Finally, how FlashCopy fits in with DASD based replication solutions such as Metro Mirror (PPRC), z/OS Global Mirror (XRC), and Global Mirror.
DB2 for z/OS Best Practice: How DB2 Performance Structures Improve Performance
In this Best Practice, Sheryl Larsen, the DB2 for z/OS world-wide evangelist discusses structures and appliances that can be used in conjunction with DB2 to improve performance. She presents information on base table indexes, index on expression, Materialized Query Tables (MQTs), zIIPs, and Accelerated Query Tables (AQTs). Decisions and cases regarding when to use these structures are presented.
DB2 for z/OS Best Practice: Advanced SQL Performance Insights
In this Best Practice, Sheryl Larsen, the DB2 for z/OS world-wide evangelist shares many of the insights she has gained in writing efficient and well performing SQL. She explains the stages of SQL processing and filtering and gives practical tips on which predicates might obtain faster results. The steps to review your SQL are outlined. Sheryl also reviews some of the analytic capabilities of SQL statements such as PACK, GROUP BY GROUPING SETS, GROUP BY ROLLUP, and GROUP BY CUBE.