| By Dave Beulke, on August 30th, 2011 There are many design aspects for DB2 Temporal Tables that I have discussed in some of my previous blog entries. While reviewing the design of a recent data warehouse system, it became apparent that many index design points weren’t evaluated and were causing overall poor application DB2 performance. These same index design points are especially . . . → Read More: Three Essential DB2 Performance Design Points about DB2 Temporal Table Indexes By Dave Beulke, on April 5th, 2011 Reviewing the DB2 10 Data Warehouse DSNZPARM for z/OSThe previous two weeks’ Part 1 and Part 2 discussions highlighted and discussed the various DB2 Data Warehouse DSNZPARMS for z/OS within Versions 8 and 9. With the new DB2 Temporal Tables the system needs . . . → Read More: DB2 Data Warehouse DSNZPARMS Part 3 By Dave Beulke, on March 29th, 2011 Reviewing the DB2 Data Warehouse DSNZPARM for z/OSLast week we talked about the first alphabetic group of DB2 data warehouse DSNZPARMS that can improve your access paths and overall application performance. This week the second set of DSNZPARMS are discussed. Many of the . . . → Read More: DB2 Data Warehouse DSNZPARMS Part 2 By Dave Beulke, on March 22nd, 2011 Reviewing the DB2 Data Warehouse DSNZPARM for z/OSIn the previous weeks I briefly talked about the new DB2 10 temporal tables and how they are great for data warehousing applications. To leverage the temporal tables and data warehousing applications within the DB2 for . . . → Read More: DB2 Data Warehouse DSNZPARMS Part 1 By Dave Beulke, on September 27th, 2010 DB2 Leads with Innovation Benefiting DB2 Business Intelligence Applications 2008 DB2 Magazine article shows how DB2 on the System Z platform supports cost efficiencies and DB2 performance for DB2 business intelligence applications. By Dave Beulke, on September 27th, 2010 DB2 9 Provides a DB2 Performance Boost 2007 DB2 Magazine provides specific examples of DB2 SELECT, DB2 FETCH and more to show how DB2 9 for DB2 zos can improve DB2 performance. By Dave Beulke, on September 27th, 2010 Follow Through on Best DB2 Performance Practices to Achieve DB2 Scalability 2006 DB2 Magazine article by DB2 consultant, Dave Beulke, discusses DB2 8 for Z/os and DB2 LUW 9 with their improved DB2 performance and DB2 scalability. By Dave Beulke, on September 27th, 2010 DB2 8 for DB2 zos Performance Boost 2006 DB2 Magazine article by DB2 consultant, Dave Beulke, identifies a few key cost-saving measures DBAs can take with DB2 8 for DB2 zos to improve Java DB2 performance. By Dave Beulke, on September 27th, 2010 Boosting DB2 9 for zos Performance and DB2 Scalability 2007 DB2 Magazine article shows how improvements to DB2 locks in DB2 9 for DB2 zos improves DB2 performance and DB2 scalability. By Dave Beulke, on September 20th, 2010 Top DB2 Performance Features in DB2 9 for zOS 2009 DB2 Magazine article talks about two DB2 performance features in DB2 9 for zos, DB2 index on expression and DB2 index compression. | |