Profile

e-Catalog

Contact

Search

Cart

IBM DB2 Universal Database 5.0: Diagnostics and Problem Determination

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Database administrators responsible for DB2 databases and data storage

Prerequisites

A basic understanding of DB2 and DB2 fundamentals

Course Aim

To provide DB2 database administrators with the knowledge required to locate and troubleshoot DB2 problems on the client or server

Learning Objectives

Determine the location and cause of problems. Understand the diagnostic tools available. Interpret SQL codes and error messages. Trace problems. Locate problems on clients. Use UNIX diagnostic tools. Troubleshoot common problems.

Topics Covered

Problem determination - Error messages and SQL codes - Diagnostic and service logs - Information resources - Miscellaneous troubleshooting tools Troubleshooting the client - Overview - Determining the problem - Common protocol errors Tracing - Using the DB2 Trace facility - Other tracing options Diagnostic tools - The system error log - The core file - Other UNIX options