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.

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 .. ]