DB2 Data Warehouse DSNZPARMS Part 2

Reviewing the DB2 Data Warehouse DSNZPARM for z/OS

Last 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

DB2 Data Warehouse DSNZPARMS Part 1

Reviewing the DB2 Data Warehouse DSNZPARM for z/OS

In 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

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

DB2 Temporal Tables – Research Required

DB2 Temporal Tables

It 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

DB2 10 Roadshows provide additional information

DB2 Migrations Get a Push

The 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

IDUG Europe and More DB2 10 Features Coming

IDUG Europe

The 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

IOD Conference Roundup

Oracle to DB2 Conversions

In 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

IOD Happenings: DB2 10, Sybase Goes to DB2 and Cognos

DB2 10 Becomes Available

Last 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

DB2 10 SQL Optimization Preservation for DB2 Performance

Leverage DB2 Version 9 BASIC and EXTENDED Plan Stability Features

Last 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

Maintaining DB2 Query Performance Tuning within DB2 10

Three Things to Do to Retain Your DB2 Query Performance

Everyone 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