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 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

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

Talking with people at the DB2 Washington DC-Baltimore user group meeting was very interesting. Surveying the group showed that everyone was planning to perform DB2 migration to DB2 10 as soon as possible. Everyone was excited about the DB2 10 performance features and especially the cost savings offered through its new features and functionality.

. . . → Read More: DB2 Migration to DB2 10: Three More Items to Ensure your 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

DB2 Migration to DB2 10-Three Critical Performance Items to Help You Prepare

When you and your management start to talk about your DB2 migration to Version 10, start planning immediately because the DB2 migration path never has enough time for all that needs to be done. Regardless of when you start there are normal operations, everyday issues and, of course, lately earthquakes and hurricanes to make your . . . → Read More: DB2 10 Migration-Three Critical Performance Items to Help You Prepare

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 Tables – Capturing a Snapshot of Your Business

DB2 offers application designers new functionality for their data warehousing requirements. The new DB2 10 Temporal Tables provide a way to have a snapshot in time of the status of customers, orders or any other type of business situation. DB2 Temporal Tables, with their built in functionality, automatically understand the business time or system time . . . → Read More: DB2 Temporal Tables — Capturing a Snapshot of Your Business

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