Articles & Content

Archives

The Problem Detective Toolkit (D02)

Topic: DB2 for LUW

Subtopic: 2008



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

OBJECTIVES:

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.



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.