| By Dave Beulke, on December 13th, 2011 While recently speaking at the Minneapolis, Milwaukee and Chicago DB2 User Groups, it was really nice to hear all the opinions and different points of views on DB2 10 from all my familiar friends. It was only a couple of years ago when a friend told me their company had decided to get off the . . . → Read More: Analytics Is the Answer: Three Reasons Your Business Needs DB2 z/OS Analytics By Dave Beulke, on October 25th, 2011 The IBM Information on Demand (IOD) conference is going on right now and there are several IBM product announcements that are available at the IBM web site addressing the big data explosion, cloud social and analytic business trends. These announcements unveil another great step forward over the competition in all of these areas. The new . . . → Read More: IOD, IBM Trends and Budget Planning for DB2 10 Migration and Performance By Dave Beulke, on October 11th, 2011 As everyone gets ready for the DB2 migration to Version 10 there are many things that need to get done to start implementing the system and application enhancements. Below are another three more items to do ahead of the schedule so your company, systems and applications can leverage the features as soon as you start . . . → Read More: DB2 Migration to DB2 10: Another Three More Items to Ensure your DB2 Performance 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 May 17th, 2011 The annual North American IDUG Conference was held in Anaheim, California a couple of weeks ago where the latest and greatest information about DB2, and a lot of material on DB2 10, was unveiled. The technical experiences discussed at IDUG with DB2 for z/OS and LUW from many user companies are great because the knowledge . . . → Read More: DB2 10 for z/OS: Planning for the New DB2 10 Features By Dave Beulke, on May 10th, 2011 The annual North American IDUG conference was held in Anaheim, California last week where the latest and greatest information about DB2 was unveiled. The IDUG Board of Directors and especially the Conference Planning Committee did a great job providing qualified users, consultants and IBM developers as speakers to discuss their technical experiences with DB2 for . . . → Read More: DB2 10 for z/OS the Belle of the Ball – The IDUG Recap By Dave Beulke, on April 26th, 2011 Table Space Clustering Design for Your DB2 Data WarehouseLast week we talked about the partitioning choices, options and considerations. This week we’ll talk about the other important aspect of table space design, clustering. The clustering of the data can have a huge impact . . . → Read More: DB2 Temporal Table: Table Space Clustering Design for Your DB2 Data Warehouse By Dave Beulke, on April 19th, 2011 Table Space Design for Your DB2 Data WarehouseLast week we talked about the types of table spaces possible for our large temporal table. The new table partitioning by range (PBR) was chosen because of its many performance advantages. The ability to separate I/O . . . → Read More: DB2 Temporal Table: Table Space Design for Your DB2 Data Warehouse By Dave Beulke, on April 12th, 2011 DB2 Table Space Design ChoicesIn the previous weeks we talked about getting started with a DB2 temporal table and the DB2 DSNZPARMs that will affect your DB2 data warehouse performance. This week we’ll start to design the implementation of the DB2 temporal table . . . → Read More: DB2 Temporal Table: Table Space Design for Your DB2 Data Warehouse 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 | |