Analytics Is the Answer: Three Reasons Your Business Needs DB2 z/OS Analytics

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

IOD, IBM Trends and Budget Planning for DB2 10 Migration and Performance

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

DB2 Migration to DB2 10: Another Three More Items to Ensure your DB2 Performance

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

Three Essential DB2 Performance Design Points about DB2 Temporal Table Indexes

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

DB2 10 for z/OS: Planning for the New DB2 10 Features

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

DB2 10 for z/OS the Belle of the Ball - The IDUG Recap

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

DB2 Temporal Table: Table Space Clustering Design for Your DB2 Data Warehouse

Table Space Clustering Design for Your DB2 Data Warehouse

Last 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

DB2 Temporal Table: Table Space Design for Your DB2 Data Warehouse

Table Space Design for Your DB2 Data Warehouse

Last 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

DB2 Data Warehouse Table Space Design

DB2 Table Space Design Choices

In 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

DB2 Data Warehouse DSNZPARMS Part 3

Reviewing the DB2 10 Data Warehouse DSNZPARM for z/OS

The 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