DB2 LUW Performance: IDUG Ed Seminar Z06 Preparation Instructions

Dear DB2 LUW Professional,

I invite and encourage you to attend my Education Seminar, Z06: DB2 for LUW Performance Analysis and Tuning Workshop, at IDUG NA 2010 in Tampa Florida. Without exception, I've never before put so much effort into preparing a full day seminar. In this class, you will receive over three dozen SQL Snapshot commands to help analyze YOUR database. Together, we will learn about what to measure, we will discover the problems and "opportunities for improvement" in your database, we will discuss solutions, and you will return to your office fully equipped to make measurable performance improvements.

IDUG NA 2010 Conference Logo, Click for Details

In terms of preparation for this class, here's what you will want to do to optimally prepare:

  1. Make copy tables of SYSIBMADM snapshot views and some catalog tables (CREATE LIKE)
  2. INSERT INTO copy table SELECT * FROM original table or view
  3. EXPORT TO IXF file SELECT * FROM copy tables
  4. Binary transfer the IXF files to a laptop running DB2 LUW (Express-C (free DB2) will suffice)
  5. IMPORT FROM IXF file REPLACE_CREATE INTO local copy of tables on laptop
All of the SQL commands provided to you during the class will reference the schema name IDUGCONF. The rest of this blog post contains the specific commands that you can use to prepare for the class. When you return back to your office with electronic copies of the SQL Snapshots, all you will need to do is change IDUGCONF to SYSIBMADM and you'll be ready to analyze your databases locally!

This should be a $5,000 course. IDUG is making Ed Seminars available "for a song" relatively speaking - only $425 with a conference badge or just $475 for the seminar alone. Click the IDUG logo above to register now! Early registration ends 26 March 2010.

[ more.. ]

DB2 LUW Performance: SQL Snapshots, IDUG, and Solid State Disk

OH WOW! Right now I am slapping myself on my back so hard that it hurts! In an earlier blog post on I/O Optimization and Solid State Disk (SSD), I referenced a recent IBM DM Magazine article and discussed an improved weighting formula for determining which tablespaces would benefit most from SSD storage. WELL, I just created a masterpiece SQL Snapshot command that implements best practices weighting factor calculations for SSD! This SQL Snapshot command is amazing...

[ more.. ]

DB2 LUW Performance Diagnostics and Tuning Lab at IDUG

DB2 LUW Database Professionals: If you can only get budget to attend ONE class this DECADE, I strongly encourage you to do whatever it takes to get yourself enrolled in my NEW Ed Seminar DB2 for LUW Performance Analysis and Tuning Workshop being given at IDUG in Tampa, Florida, on 10 May 2010.

For this lab, you should bring with you copies of SYSIBMADM Snapshot Catalog Views (detailed instructions and scripts will be provided separately). In this lab, you will receive dozens and dozens and dozens of SQL Snapshot commands (on CDROM) to analyze your database's performance data, you will learn what the numbers and metrics mean, and you will graduate fully equipped to conquer amazing performance tuning miracles for your organization...

[ more.. ]

Page :  1