Who Wants to Learn about DB2 LUW Performance?


Posted by Scott on April 7, 2009, 8:03 pm
in General ( DB2 Performance)

When Kim Moutsos contacted me about the opportunity to blog for DB2 Magazine, I was thrilled. What better way, I thought, could there be to help DB2 users improve the performance and security of their databases than to blog about these topics?

I told Kim that one of the first things I'd like to do would be to teach online excerpts from my IDUG Education Seminar "DB2 LUW Performance Diagnosis Lab".

So, let's get started.

In this class, participants bring snapshots and performance data from event monitors to the class on laptops. In this blog, you have the benefit of not having to carry a laptop to class and not having to pay $495! But, you will still need to prepare by collecting some performance data from your DB2 LUW databases.

The instructions you need to prepare can be obtained from www.database-brothers.com/db2mag/GettingReady-IBMDB2LUW-Performan ce-Diagnosis-Lab.pdf This PDF contains commands that you should run to prepare to analyze your database. I suggest you choose a database that you would like to have perform better - better meaning having greater efficiency and throughput, and possibly supporting more users on the same hardware.

I'll be back to blog again in a couple days. We'll begin by covering some key performance metrics that will help you understand the nature, health, and efficiency of your database.

Best regards,
Scott Hayes

President & CEO, DBI ( www.DBIsoftware.com )
IBM DB2 GOLD Consultant

Post from : http://www.dbisoftware.com/blog/db2_performance.php
Printed from : http://www.dbisoftware.com/blog/db2_performance.php?id=93