| 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 March 15th, 2011 Getting Started with Temporal TablesTo figure out the best temporal table design aspects you need to think of the various options and considerations that will affect its performance. The most important aspect for your temporal table is the answers that your applications or . . . → Read More: DB2 Temporal Tables — Getting Started By Dave Beulke, on March 8th, 2011 DB2 Temporal TablesIt is usually pretty easy to quickly implement the new DB2 features. DB2 makes it easy to improve your database performance with a new zParm or table space definition. Unlike most of these new features, however, DB2 temporal tables need research . . . → Read More: DB2 Temporal Tables — Research Required By Dave Beulke, on February 22nd, 2011 DB2 Migrations Get a PushThe IBM DB2 training roadshow was in Washington DC this last week. The presentations provided additional information on the full advantages of System Z and how it continues to lead all platforms in price performance. Different tracks with information about . . . → Read More: DB2 10 Roadshows Provide Additional DB2 Training Information By Dave Beulke, on November 8th, 2010 IDUG EuropeThe focus now turns to the IDUG 2010 European conference in Vienna, Austria. It is always interesting to hear about the different DB2 systems, applications and information technology points of view from all the conference attendees. Last week at the IOD conference the . . . → Read More: IDUG Europe and More DB2 10 Features Coming By Dave Beulke, on November 2nd, 2010 Oracle to DB2 ConversionsIn the previous weeks I’ve talked about how easy it is to transfer your systems from Oracle to DB2. At the IOD conference many Oracle to DB2 conversion companies added their value proposition testimonies. IBM recorded these testimonials by video and audio, documenting . . . → Read More: IOD Conference Roundup By Dave Beulke, on October 26th, 2010 DB2 10 Becomes AvailableLast week on October 22 IBM announced that the DB2 10 for z/OS was now generally available for all clients. I talked with some of the beta customers at the IOD DB2 training conference this week and they further documented all the great savings after installing the new version. I talked . . . → Read More: 2010 IOD DB2 Training Happenings: DB2 10, Sybase Goes to DB2 and Cognos By Dave Beulke, on October 19th, 2010 Leverage DB2 Version 9 BASIC and EXTENDED Plan Stability FeaturesLast week I talked about leveraging the DB2 Version 9 BASIC and EXTENDED plan stability features. I also commented that if you don’t have DB2 9 and are coming from DB2 Version 8 to DB2 10 that you can still save your access plans to . . . → Read More: DB2 10 SQL Optimization Preservation for DB2 Performance By Dave Beulke, on October 12th, 2010 Three Things to Do to Retain Your DB2 Query PerformanceEveryone is really wondering whether the DB2 performance improvement numbers are really true for DB2 10. The answer is a big “YES” according to the majority of the DB2 10 Beta customers. The DB2 performance figures are true and sometimes better than the 5-10% saving . . . → Read More: Maintaining DB2 Query Performance Tuning within DB2 10 | |