IDUG Meeting featuring IDUG 2012 Speakers

SIRDUG Meeting March 22nd, 2012

SIRDUG is very pleased to announce that the first 2012 SIRDUG meeting on March 22nd, will feature several speakers who will be presenting at the IDUG DB2 Tech Conference in Denver, Colorado.

The IDUG DB2 Tech Conference in Denver, Colorado will be held, May 14th through 18th. If you are not able to attend this year's IDUG North America Conference, this is your opportunity to catch a piece of the action. For details about the IDUG DB2 Tech Conference in Denver, Colorado click here

Meeting Details

WHEN? Thursday, March 22, 2012

WHERE? IBM Office (10330 David Taylor Drive, Charlotte, NC) See directions below

COST? $20 cash or check, in advance or at the door.
We do not accept credit cards. We are working on a way to accept Paypal and credit cards, so stay tuned for upcoming announcements.

Tentative Meeting Agenda

Meeting Agenda 

 8:00 -  8:50 - Registration - Coffee, Danish, and Networking
 8:50 -  9:00 - SIRDUG announcements and speaker introductions 
 9:00 - 10:15 - Tony Andrews (Themis) - "Advanced Query Tuning with IBM Data Studio for Developers" (Cross-Platform)
10:15 - 10:30 - Mid-Morning Break
10:30 - 12:00 - Tony Andrews (Themis) - "Advanced SQL, Working with Complex Queries"  (Cross-Platform)
12:00 -  1:00 - Lunch
 1:00 -  2:10 - Charles Lewis - "DB2 10 Time Travel Data (aka Temporal Tables)" (DB2 for z/OS)
                Roger Sanders - "Everything You've Always Wanted To Know About Database Cloning (But Were Afraid To Ask) ?" (DB2 for LUW)
 2:10 -  2:25 - Mid-Afternoon Break
 2:25 -  3:35 - Dan Alion - "Let's Study-O Data Studio, Daddy-O" (Cross-Platform)
                Paul Turpin - "What Is Happening in My Package Cache?" (DB2 for LUW)
 3:35 -  3:45 - SIRDUG business , Adjourn


To pre-register please use our new online registration form at:
meeting registration form
email and give us your name and company. If you are not already on our distribution list and wish to be, include your email address and phone number.

If you do not wish to continue receiving these occasional notices, please indicate that in your registration email.

Pre-registration must be completed by Midnight, Friday, March 16th. We need to provide a list of attendees to IBM security, so we need everyone to pre-register. Please feel free to invite others from your company (just make sure they pre-register as well). If you know others in your company who are interested in attending future SIRDUG events, please encourage them to become members of our distribution list (we just need their names, email addresses and phone numbers).

Registration Note
SIRDUG will be calling or emailing a confirmation for each person who pre-registers by the deadline. If you have pre-registered and have not received a confirmation by the day after the deadline, please notify us as your registration may not have been received.

If you have not pre-registered by the deadline, you may pre-register after the deadline or register at the door, but the availability of presentation handouts and lunch can not be guaranteed and confirmations will not be sent.

Directions to IBM Office (10330 David Taylor Drive, Charlotte, NC) :

The address for GPS should be 10330 David Taylor Drive, Charlotte, NC

North bound on I-77 (from the Rock Hill direction)
North bound on I-77 (from the Rock Hill direction): Turn right onto I-85 North and follow next directions.

On I-85
On I-85 (coming from either direction): Take exit 45B onto Harris Blvd. West. Turn Right at 2nd stop light onto David Taylor Drive. Go to 10330 David Taylor Drive.

South bound on I-77
South bound on I-77 (from the Statesville direction) Turn left onto Harris Blvd. East (exit 18) Go approximately 6.3 miles to the 10th stop light (counting the one at top of I-77 ramp) Turn Left onto David Taylor Drive. Go to 10330 David Taylor Drive.

Presentations for Download

To download Getting Started with IBM Data Studio for DB2 (Version 3.1) (10 MB)
click here

To download IBM Data Studio for DB2 (Version 3.1) and to get information about the product click here

To download Tony Andrews' "Advanced Query Tuning with IBM Data Studio for Developers" (5 MB) click here

To download Tony Andrews' "Advanced SQL, Working with Complex Queries" (5 MB) click here

To download Dan Alion's "Let's Study-O Data Studio, Daddy-O" (23 MB) click here

To download Charles Lewis' "DB2 10 Time Travel Data (aka Temporal Tables)" (2 MB) click here

To download Roger Sanders "Database Cloning" (2 MB) click here

To download Paul Turpin's "What Is Happening in My Package Cache?" (8 MB) click here

Tony Andrews's Biography

Tony Andrews has more than 23 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and has also served as a database analyst. For the last 10 years, Tony has been splitting his time between performance and tuning consulting engagements along with training. His main focus is to teach today’s developers the ways of RDMS application design, development and SQL programming -- always with a special emphasis on improving performance. He is a current IBM Champion, and regular speaker at many user groups, IDUG NA, and IDUG EMEA.

You can see a few minutes of one of Tony's Advanced SQL classes by clicking here

Title: "Advanced Query Tuning with IBM Data Studio for Developers"

This track is for the DB2 for z/OS development professional who desires to understand the fundamental issues associated with performance for SQL applications. Emphasis is placed on new considerations for the latest releases of DB2 and the use of IBM Data Studio as an optimization tool.

Objective 1: Learn how to use the information provided by IBM Data Studio to improve the performance of DB2 applications.
Objective 2: Learn the different Access Paths preseted by IBM Data Studio
Objective 3: Learn why optimization filter factors are so important and how statistics play a role in them. See where they get externalized in IBM Data Studio.
Objective 4: Learn how to use and navigate through the IBM Data Studio tool for SQL tuning.
Objective 5: See the new V9 optimization techniques, predicate types, and statistics using IBM Data Studio.

Title: "Advanced SQL, Working with Complex Queries"

Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this session is for you! We’ll look at some of the features in the latest releases of DB2 that allow us to solve even more business and performance problems.

• Review of Joins, Subqueries, Nested Table Expressions, Common Table Expressions
• Quota Queries for Ranking and Top 10 List
• OLAP Ranking Functions
• Solving Complex Problems with SQL. Evaluating Options
- Looking at multiple ways to get the same answer
- Looking at Intersect and Except for solutions
• Merge Statement – what did it do?
• New SQL
-Currently Committed, Skip Locked Data, Uncommitted Reads
-Extended Null Indicators
-Stored Procedures ‘With Return to client’
-Select From Update, Insert, Delete

Charles Lewis's Biography

Charles Lewis is a Sr. Certified DB2 Advisor for System z with IBM's East Region Client Technical team. He has broad experience as an application developer and database consultant with more than 33 years of IBM experience. He has worked extensively in DB2 application design, capacity planning, and performance tuning. In his current assignment he helps customer plan and implement the latest versions of DB2 for z/OS.

Title: "DB2 10 Time Travel Data (aka Temporal Tables)"

One of the new features in DB2 10 for z/OS is the support for temporal tables and versioning. Starting in DB2 10 new-function mode, one can define temporal attributes for a table and enable versioning of the table's data. These new attributes provide a lot of flexibility in how you can query data based on periods of time.

Paul Turpin's Biography

Paul Turpin is a senior database administrator for a software development company specializing in financial applications. He specializes in DB2 for LUW on large systems. He enjoys exploring new features and functionality in DB2. He has spoken at IDUG North America, IDUG Europe, SHARE, IBM’s Information on Demand conference, and several RUGs. Paul currently serves on the IDUG Board of Directors. He was one of IBM's inaugural Information Champions.

Title: "What Is Happening in My Package Cache?"

What goes on in the package cache is often a mystery. Performance of SQL can be dramatically impacted by the package cache, so understanding how it works is very important. There are package cache administrative views, package cache event monitors and other DB2 tools that help us determine what is really going on in the package cache.
Objective 1: What is the package cache?
Objective 2: Are package cache inserts, lookups, or overflows bad?
Objective 3: Oops, I flushed my package cache, now what happens?
Objective 4: How to use the package cache table functions
Objective 5: How to use the package cache event monitors

Roger Sander's Biography

Roger E. Sanders is the President of Roger Sanders Enterprises, Inc. and a Senior Consultant Corporate Systems Engineer with EMC Corporation. He has been working with DB2 for Linux, UNIX, and Windows since it was first introduced on the IBM PC (as part of OS/2 1.3 Extended Edition) and is the author of twenty-one books on DB2 and one book on ODBC. For the past nine years, Roger has authored the Distributed DBA column in IBM Data Management Magazine (formerly DB2 Magazine) and over a fourteen-year period he has written tutorials and articles for IBM's developerWorks website as well as for publications like Certification Magazine and IDUG Solutions Journal, presented at several International DB2 User's Group (IDUG) and regional DB2 User's Group (RUG) conferences, taught classes on DB2 Family Fundamentals and DB2 Database Administration (DB2 for Linux, UNIX, and Windows), and participated in the development of seventeen DB2 Certification Exams. In 2008, 2009, 2010, and 2011, Roger was recognized as an IBM Information Champion; in 2010 he was recognized as an IBM developerWorks Contributing Author and in 2011, he was recognized as an IBM developerWorks Professional Author.

Title: "Everything You've Always Wanted To Know About Database Cloning (But Were Afraid To Ask) ?"

There are a variety of business needs in which access to production or near-production data is required – development, testing, and report generation, to name a few. And in many cases, these needs can be fulfilled by creating and using a clone of a production database, rather than the production database itself. This presentation discusses some of the advantages of database cloning and it examines a variety of methods that are available for cloning production DB2 for Linux, UNIX, and Windows databases.
Objective 1: When it can be advantageous to clone a production database.
Objective 2: How to use DB2’s data movement utilities to facilitate database cloning.
Objective 3: How to use DB2’s backup and recovery utilities to clone a database.
Objective 4: How to clone a database by copying files and changing the DB2 metadata stored in them.
Objective 5: How to clone a database using the disk-based replication technology that is available from most storage vendors.

Dan Alion's Biography

Dan has over 30 years of software development and management experience. The past 18 years he has been involved in the development of statistical reports and monitoring applications for check processing, and more recently ACH processing, systems. Dan presented “DB Trigger Hints and Tips” at IDUG 2002 and “DB2 Triggers: Coding for Performance” at IDUG 2005. Currently he is technical leader of a small group developing monitoring applications, and he often directly contributes to DB2 database design and programming tasks.

Title: "Let's Study-O Data Studio, Daddy-O"

Data Studio is chrome-plated and souped up with Eclipse! Cruise with me through Data Studio-ville and learn how to efficiently navigate DB2 databases on LUW and zOS servers. Get ready to race your command-line techies for pink slips! You will know how to create database objects, generate DDL, view/modify table contents, run SQL, and tune SQL (w/ optional Query Tuner). Data Studio is already capable of making you a productive user quickly, this session will fill in a few gaps further reducing the learning curve.

Objective 1: Data Studio Introduction and Eclipse Orientation:
Briefly discuss Data Studio versions, prerequisites, download, and installation. Then spend a few minutes of orientation on how to use and navigate in Eclipse.
Objective 2: Overview of Data Studio Perspectives:
Discuss the purpose of each of the Data Studio Eclipse perspectives, and the specific functions provided by each perspective.
Objective 3: Learn to use Data Studio functions against zOS and LUW databases:
Step through how to use many of the functions in each perspective using numerous screen shots, and provide pointers to prevent confusion in a few areas.
Objective 4: IBM Optim Query Tuner:
Describe the additional function provided by separately purchased product IBM Optim Query Tuner, and walk through tuning examples.
Objective 5: Additional Considerations:
Cover additional tips on the use of Data Studio, and resolution to some of the problems that may be encountered.

SIRDUG Home Page

Last Update: March 22, 2012

Copyright © 2012 SIRDUG Inc. All rights reserved.