Articles & Content


The DB2 Detective - The Case of the Diligent DBA (E04)

Topic: 2009 NA

Subtopic: DB2 for LUW

DATE: 2009-5-12 (02:45 PM - 03:45 PM)
SPEAKERS: Bill Minor (IBM Canada)

No matter the extent of preparation, it seems that unexpected outages pop up when least expected. As a result, unplanned downtime can cause significant impact to business operations. When misfortune strikes, there are always two predominant questions, "What happened?" and "When will the system be available again?" Mysteries can be resolved by good DB2 Detective work - identifying and circumventing actions that can lead to problems. When unexpected problems do occur, it is vital to be able to act decisively and swiftly. The goal of this session is to introduce database inspection tools and provide insights that can be used to help monitor the integrity and maintain the consistency of your data. I will also provide guidance for salvage, repair and recovery operations that are vital when crisis strikes and time is of the essence.

EXP. LEVEL: Intermediate


To introduce new features in DB2 9.5 which can assist in maintaining data integrity.

To provide an overview of how the db2pd tool can help you monitor and assess the health of your DB2 system.

Learn how to salvage and recover data in time of crisis.

To provide a deeper understanding of DB2 storage architecture and it's limits.

To provide information and insights which can help reduce calls to IBM DB2 Support or at the very least, provide insights that can help expedite the resolution of Service calls which are unavoidable.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.