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
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
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.
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 firstname.lastname@example.org 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).
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.
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 (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.
To download Getting Started with IBM Data Studio for DB2 (Version 3.1) (10 MB)
To download IBM Data Studio for DB2 (Version 3.1) and to get information about the product
To download Tony Andrews' "Advanced Query Tuning with IBM Data Studio for Developers" (5 MB)
To download Tony Andrews' "Advanced SQL, Working with Complex Queries" (5 MB)
To download Dan Alion's "Let's Study-O Data Studio, Daddy-O" (23 MB)
To download Charles Lewis' "DB2 10 Time Travel Data (aka Temporal Tables)" (2 MB)
To download Roger Sanders "Database Cloning" (2 MB)
To download Paul Turpin's "What Is Happening in My Package Cache?" (8 MB)
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
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 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.
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 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.
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 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.
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 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.
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.