| 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 September 27th, 2010 Relational Database Design Provides Good DB2 Performance 2006 DB2 Magazine article shows the importance of adhering to best relational database design practices and understanding DB2 in order to save time and effort on DB2 performance tuning efforts. 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 24th, 2010 First Look at DB2 9.7 LUW 2009 DB2 Magazine article provides a first look at DB2 9.7 (DB2 LUW), including improvements to DB2 index compression, Oracle compatibility and concurrency. 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. By Dave Beulke, on March 9th, 2010 Index design is one of the most important items or maybe the most important item in database design. Sometimes it is better to enhance the database with more indexes instead of trying to fix the application SQL. Tuning SQL is always good but tuning many SQL statements takes too much time. When time is tight . . . → Read More: Many New Index Options in DB2 – Version 9 DB2 Performance Features – Part 19 By Dave Beulke, on December 3rd, 2009 While talking with clients and friends at the recent conferences, I noticed that everyone seemed to like the blog entries I’ve done about the DB2 performance features of DB2 v9 for z/OS. Some have even implemented some of the features previously mentioned and have already reduced their costs and overall processing elapsed times. So, with . . . → Read More: DB2 Performance Features in DB2 V9 for z/OS — Part 11 By Dave Beulke, on February 25th, 2009 Make sure that you are using the correct database design to improve DB2 performance: Use partitioning for robust tables that play central parts in the processing to help ease locking and encourage parallelism. Also leverage database partitioning for large tables (over 500,000 rows) which might benefit from spreading out the I/O to different partitions and . . . → Read More: DB2 Performance Summary Part 2 By Dave Beulke, on January 28th, 2009 The trail for the hunter of performance problems leads from the DB2 table to its indexes. As I went deeper into this DB2 performance jungle, I discovered more interesting artifacts. DB2 IndexSince the table I talked about in the last post was typical of other tables in other applications in the company, it made . . . → Read More: The Effect of Indexes on DB2 Performance By Dave Beulke, on January 21st, 2009 Once you have reviewed the overall system for the aspects that we have discussed over the last few months, it’s time to drill down into your more critical transactions and processes. Critical transactions are those frequently executed transactions that are using excessive CPU or I/O resources. For this analysis using a performance monitor is necessary . . . → Read More: Taking Advantage of Relational Technology Part 4 | |