Articles & Content

Archives

DB2 LUW Operational Performance Troubleshooting - Finding CPU Bottlenecks. (C12)

Topic: 2011 NA

Subtopic: DB2 for LUW



DATE: 2011-5-5 (02:45 PM - 03:45 PM)
SPEAKERS: Albert Grankin (IBM )

This session will show how to characterize and identify operational performance issues specific to CPU usage contention on DB2 Database Server. We will cover the most used OS and DB2 commands and tools, their outputs analysis. It will also provide case studies based on real customer situations.

EXP. LEVEL: Intermediate

OBJECTIVES:

Learn how to characterize and troubleshoot operational performance issues on database servers, specific to CPU usage bottlenecks.

Learns tools and commands used to monitor/troubleshoot database performance.

Learn how to identify an SQL statement or other database operation that may be using too much CPU.

Learn from real customer situations case studies.

Best practices to reduce CPU usage on database server by applications.



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.