May 28, 2007
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-Performance-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.Database-Brothers.com)
IBM DB2 GOLD Consultant
Trackback Pings
TrackBack URL for this entry:
http://www.ibmdatabasemag.com/blog/main/archives/2007/05/who_wants_to_le.html
« So tired I could be trashed | Main | DB2 LUW Performance: Average Result Set Size (ARSS) »
This is a public forum. CMP Media and its affiliates are not responsible for and do not control what is posted herein. CMP Media makes no warranties or guarantees concerning any advice dispensed by its staff members or readers.
Community standards in this comment area do not permit hate language, excessive profanity, or other patently offensive language. Please be aware that all information posted to this comment area becomes the property of CMP Media LLC and may be edited and republished in print or electronic format as outlined in CMP Media's Terms of Service.
Important Note: This comment area is NOT intended for commercial messages or solicitations of business.