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
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.
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.
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.
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.
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
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
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 . . . → Read More: DB2 Performance Summary Part 2
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.
Since 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
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