Articles & Content


The Problem Detective Toolkit (D02)

Topic: 2008 NA

Subtopic: DB2 for LUW

DATE: 2008-5-19 (11:00 AM - 12:00 PM)
SPEAKERS: Paul Turpin (Wachovia)

One of the most difficult situations a database administrator (DBA) faces is resolving a problem with DB2. The problems can range from minor to catastrophic. DB2 now contains a number of tools to assist the DBA in quickly resolving the issues. Some of the tools are fairly new and aren't fully utilized by most DBAs. This session aims to educate the DBA on these excellent problem tools. The session will also explore common UNIX tools that can be used for researching DB2 problems.

EXP. LEVEL: Beginner,Intermediate


Understanding the diagnostic logs and what information can be gleaned from them.

Using the db2diag tool to dig through the diagnostic log.

Using the the db2pd tool to research issues with DB2 locking and logging.

Using common UNIX tools to gather information about the problems. Some of the UNIX tools are lslpp, vmstat, iostat and topas.

Researching network issues to determine if DB2 is the victim or the perpetrator.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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