IDUG Preview Session featuring Robert Catterall, and Roger Sanders

SIRDUG Meeting February 11th, 2005

Featuring: Robert Catterall - IDUG Speaker's Hall of Fame & Roger Sanders, author of several DB2 books.

SIRDUG presents our annual "Sneak Preview" of the IDUG North America Conference. Come hear Dan Alion, Robert Catterall, Roger Sanders, Sally Mir, Paul Turpin and Tink Tysor offer 2005 IDUG conference presentations. Your training budget won't be taking you to IDUG this year? Or you're going, and want to get a peek at coming attractions? Come to SIRDUG and get an early piece of the IDUG action.

Our featured speakers are Robert Catterall of Check Free and Roger Sanders of Network Appliance. As an IBMer, Robert was the recipient of the IDUG Speaker's Hall of Fame award. Now that he works for Check Free, he is an especially popular and highly-qualified User Speaker. Robert will talk to us about speaking Business Intelligenece (BI) in his "Stars, Cubes, Marts, and More: How to Speak BI". Roger Sanders has now authored 9 UDB books! Roger will be teaching us about "Understanding Isolation Levels and Locking". Dan Alion will be presenting "DB2 Triggers: Coding for Performance". Sally Mir will be showing us "Quick, Dirty & Cheap: Using REPAIR to migrate data". Paul Turpin will be giving us a lesson in how we can "Preparing For The Audit" Tink Tysor will be presenting "Recursive SQL - From the Basics".

This year's IDUG North American Conference will be in Denver, Colorado on May 22 through 26th. If you are considering attending this year's IDUG NA conference, make sure you scroll to the bottom of this announcement for some exciting discount information!



Meeting Details

WHEN? Friday, February 11, 2004

WHERE? IBM Harris Blvd facility

COST? $25 cash or check, in advance or at the door.
We do not accept credit cards.


Meeting Agenda

 8:00 -  9:00 - Registration - Coffee, Danish, and Networking
 9:00 - 10:15 - Robert Catterall - "Stars, Cubes, Marts, and More: How to Speak BI"
10:15 - 10:35 - Mid-Morning Break
10:35 - 11:50 - Dan Alion "DB2 Triggers: Coding for Performance"
      
11:50 -  1:00 - Lunch
 1:00 -  2:15 - Parallel sessions 
Sally Mir "Quick, Dirty & Cheap: Using REPAIR to migrate data" (z/OS DB2)
Roger Sanders "Understanding Isolation Levels and Locking" (LUW DB2)

 2:15 -  2:35 - Mid-Afternoon Break  and chat with speakers
 2:35 -  3:45 - Parallel sessions
Paul Turpin "Preparing For The Audit" (LUW DB2)
Tink Tysor "Recursive SQL For Dummies"  (Cross Platform)

 3:45 -  4:00 - Networking, Adjourn

Registration

To pre-register please use our new online registration form at:
meeting registration form
or
email registration@sirdug.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, February 4th. 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 the meeting site:

The meeting is in the IBM Harris Blvd facility

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 Left at 2stop light onto IBM Drive and follow the directions below.

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 Right onto IBM Drive (Don't turn onto the IBM Drive at the 7th stop light).

Once on IBM Drive, Turn Right at 2nd drive. Look for the SIRDUG parking sign on the right side of the road. We are to park in the lower visitor parking lot. Enter the Visitors Lobby and follow the SIRDUG signs to the Cafeteria Conference Room.


Robert Catterall's Biography

Robert Catterall is a database technology strategist at CheckFree Corporation. As part of the Company's Applied Research and Technology group, Robert works to establish corporate-wide standards for the use of database technology in CheckFree applications and systems. Prior to joining CheckFree in February of 2000, Robert spent 17 years at IBM, the last ten of those as a member of the DB2 for OS/390 national technical support team at IBM's Dallas Systems Center. Robert writes the DB2 DBA column that appears in each issue of DB2 magazine, and regularly speaks at local, national, and international user group meetings and conferences. He is a member of the IDUG Speaker's Hall of Fame.

Title: "Stars, Cubes, Marts, and More: How to Speak BI"

Have you ever listened to people using business intelligence (BI) lingo and wondered, "What in the WORLD are they talking about?" Well, wonder no more! In this session, I will explain warehouses, marts, star schemas, snowflakes, cubes, OLAP, and more. I will also talk about our use of DB2 BI technology at CheckFree.

Bullet Points:
1. What is BI?
2. Operational data stores, warehouses, and marts
3. OLAP and cubes
4. Star schemas and snowflakes
5. Leveraging DB2 BI technology at CheckFree

Presentation Category: Experiences using DB2 for data warehousing and business intelligence applications
Presentation Platform: Cross Platform

Roger Sanders' Biography

Roger E. Sanders is a Database Performance Engineer with Network Appliance, Inc. He has been designing and developing database applications for more than 18 years, and he holds 8 professional certifications from IBM. He has written several articles for publications such as DB2 Magazine and IDUG Solutions Journal, authored a DB2 UDB tutorial for IBMís DeveloperWorks Web site, co-authored an IBM Redbook, presented at three International DB2 Userís Group (IDUG) conferences, and is the author of 7 books on DB2 Universal Database.

Title: Understanding Isolation Levels and Locking

Individuals who have taken the DB2 Family Fundamentals (512) exam often tell me they received their lowest scores on the section that covers isolation levels and locking. This implies that these two concepts remain a mystery to a large number of DB2 users. This presentation is designed to take away the mystery and replace it with a solid understanding of the DB2 components that make database concurrency possible.

Bullet Points:
1. Data consistency and database concurrency
2. What isolation levels are and how they are used
3. What locks are and how they are used
4. Locks and performance
5. Designing around isolation levels and locking

Presentation Category: Managing the performance or availability of DB2 and DB2 applications
Presentation Platform: DB2 for Linux, UNIX, Windows

Sally Mir's Biography

Sally Mir is a Lead DB2 DBA and Assistant Vice President at Wachovia Bank in Winston-Salem, North Carolina. She has worked with DB2 since 1990, beginning as an application developer and then as a DBA. When she is not performing her DBA duties at work, occasionally she can be seen performing on the local opera, oratorio and concert stages.

Title: Quick, Dirty & Cheap: Using REPAIR to migrate data

Why bother unloading and loading data when you migrate a table from one subsystem to another? Or when you have to collapse one subsystem into a data sharing group? Or even when you have to clone an entire subsystem? The data already exists in linear VSAM files. There is a way to reuse these files. All it takes is understanding DB2ís internal identifiers, and a few sneaky tricks.

Bullet Points:
1. Understanding DBIDs, PSIDs, OBIDs, and ISOBIDs
2. Producing DDL in the correct sequence
3. Using DB2PLI8 (a free program from IBM)
4. Renaming the VSAM files 5. Executing REPAIR to synchronize DBIDs and PSIDs

Presentation Category: Creative methods for managing DB2 resources
Presentation Platform: DB2 for z/OS

Dan Alion's Biography

Dan has 23 years of software development and management experience. The past 11 years he has been involved in the development of statistical reports and monitoring applications for check processing systems. This work has often involved DB2 database programming. Current development activities include extensive use of triggers to summarize DB2 information for downstream monitoring applications.

Title: DB2 Triggers: Coding for Performance

Since the IDUG 2002 presentation of "DB2 Triggers: Hints and Tips", we have gained experience with the performance of various coding techniques. More recent endeavors use DB2 v8 and take advantage of SQL Procedural Language to streamline trigger code. This case study covers trigger performance issues, including performance testing techniques, EXPLAIN usage, actual run time row insertion rates, and the use of SQL PL.

Bullet Points:
1. Application Overview/Trigger Design
2. Performance Testing Procedure/Tips
3. Coding Techniques/SQL PL Usage
4. EXPLAIN Results
5. Run time Results

Presentation Category: Application development and implementation using DB2
Presentation Platform: DB2 for Linux, UNIX, Windows

Paul Turpins's Biography

Paul Turpin has 18 years experience in information systems, 8 of those working with DB2 on the mainframe. He has been a DBA for 8 years, working with DB2 on the OS/390 platform. For the last 5 years, he has been a DBA working with DB2 on non-OS/390 operating systems, including AIX, Windows NT, Windows 2000, and HP-UX. He holds the following DB2 certifications: - IBM Certified Advanced Database Administrator - DB2 Universal Database DB V8.1 for Linux, UNIX, and Windows; IBM Certified Applications Developer DB2 UDB V8.1 Family; IBM Certified Advanced Technical Expert DB2 - DRDA; IBM Certified Solution Designer - DB2 BI V8

Title: Preparing For The Audit

Sarbanes-Oxley (SOX), HIPAA and Gramm-Leach-Bliley Acts are some regulations, which have heightened data security concerns. Increased exposure of applications to intranets and the internet, cause even more concerns. Many companies are conducting extensive audits of their environments, including databases to ensure data security is adequate. This presentation gives some ideas for preparing for the inevitable audits.

Bullet Points:
1. Permissions and authorities to consider
2. UNIX security considerations
3. Security vulnerabilities
4. Auditing database changes
5. Reports of access

Presentation Category: Creative methods for managing DB2 resources
Presentation Platform: DB2 for Linux, UNIX, Windows

Tink Tysor's Biography

BL "Tink" Tysor, an experienced Database Administrator, SQL developer and Relational Data Modeler with over 32 years of computer experience, has concentrated on DB2 Universal Database for z/OS & OS/390 since 1994, and has been involved in every aspect of Database Management from Conceptual, Logical and Physical Data Modeling, database creation and maintenance, SQL generation and reviews, through performance tuning and data recovery. Tink has served on the North American Conference Planning Committee for IDUG, has spoken at the North American and European IDUG Conferences, and recently Co-authored an IBM REDBOOK "DB2 for z/OS Tools for Database Administration and Change Management".

Title: Recursive SQL For Dummies

Recursive SQL, now available on DB2 UDB for z/OS, is a powerful construct used to solve many business problems. These problems previously required solutions using application logic executing many SQL statements. The basics concepts of successful recursive processing are used to explain recursive SQL. Business problems requiring recursive SQL will be explained, and how it out performs the equivalent application logic.

Bullet Points:
1. What is recursion
2. Coding a successful recursive program
3. Coding successful recursive SQL
4. What problems are candidates for recursive SQL
5. Example recursive SQL and their performance

Presentation Category: Other
Presentation Platform: Cross Platform

IDUG North America 2005 Discount Information

You can download the IDUG 2005 North America Conference RUG coupon by Clicking here


SIRDUG Home Page

Last Update: February 4, 2005

Copyright © 2003 SIRDUG Inc. All rights reserved.