DB2 Temporal Data: Three More Reasons the Ultimate Server, z/OS, Leads the Industry

Having just designed and implemented a 22-billion-row data warehouse on DB2 z/OS I have seen first-hand the incredible performance of DB2 Version 9 with a z/10 configuration take report processes from 37 hours to minutes or sub-second response time. Within the new DB2 10 z/OS enhancements, the DB2 temporal data capabilities and the new accelerator . . . → Read More: DB2 Temporal Data: Three More Reasons the Ultimate Server, z/OS, Leads the Industry

DB2 10 Temporal Tables: Three Analysis Points for DB2 Performance

When I designed and implemented my first data warehouse for E.F. Hutton back in 1988, I quickly understood that the quality of the data answers were the most important measure of success. The quality was measured in terms of the completeness, timeliness, and how quickly the user could go from question to answer. DB2 10 . . . → Read More: DB2 10 Temporal Tables: Three Analysis Points for DB2 Performance

DB2 Temporal Tables Performance: Three Critical Null in DB2 Column Considerations

When designing your DB2 temporal table make sure the column null-ability definitions are properly analyzed for your application. Defining a DB2 column as null able can be a tricky issue when dealing with computing, totaling and understanding the value of your data.

Even though I personally prefer to have data values and avoid nulls within . . . → Read More: DB2 Temporal Tables Performance: Three Critical Null in DB2 Column Considerations

DB2 Temporal Tables Performance: Three Important Modeling Considerations

In previous blog entries I have talked about how to set up your DB2 temporal tables and how DB2 10 handles the temporal considerations nicely through the SYSTEM_TIME and BUSINESS_TIME definitions. Understanding all the implications of DB2 temporal or DB2 bi-temporal tables is something that you need to model properly to understand the implications of . . . → Read More: DB2 Temporal Tables Performance: Three Important Modeling Considerations

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 Temporal Tables Improving Performance Again

While talking to friend of mine, I learned that DB2 10 Temporal Tables continue to be a big incentive to migrate as soon as possible to DB2 10 either from DB2 Version 9 or even DB2 Version 8. DB2 Temporal Tables can dramatically improve performance of your applications that are already maintaining timestamps or dates . . . → Read More: DB2 10 Temporal Tables Improving Performance Again

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 Temporal Tables – Getting Started

Getting Started with Temporal Tables

To 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