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!
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.
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
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.
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 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.
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 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.
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 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.
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 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.
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 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
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
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".
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
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.