IDUG Preview Session featuring Robert Catterall, and Roger Sanders

SIRDUG Meeting March 5th, 2004

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 Robert Catterall, Roger Sanders, Sally Mir, Danny Null and Paul Turpin offer 2004 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 how "stored procedures are going mainstream". Roger Sanders has now authored 7 UDB books! Roger will be showing us "Developing and Using Stored Procedures". Sally Mir will be showing us a method of moving a large application from one mainframe to another without reloading the data. Danny Null will be showing us how to use the Resource Limit Facility (RLF) to deal with dynamic SQL in the z/OS world. Paul Turpin will be giving us a look at how we can "Make Bad Performance Disappear!"

This year's IDUG North American Conference will be in Orlando, FL on May 9 through 13th. 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, March 5, 2004

WHERE? IBM Harris Blvd facility

COST? $20 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 - "Stored Procedures Go Mainstream "
10:15 - 10:35 - Mid-Morning Break
10:35 - 11:50 - Parallel sessions
      * Roger Sanders: Developing and Using Stored Procedures(DB2 for
        Linux, UNIX, and Windows track)
      * Sally Mir:  You Can't Get There From Here...Or Can You? (DB2
        for z/OS track) 
11:50 -  1:00 - Lunch
 1:00 -  2:15 - Parallel sessions
      * Paul Turpin: Make Bad Performance Disappear!(DB2 for Linux,
        UNIX, and Windows track)
      * Danny Null:  A Spoon Feeding of Resource Limit Facility (RLF)
        (DB2 for z/OS track) 
 2:15 -  2:35 - Mid-Afternoon Break  and chat with speakers
 2:35 -  2:45 - Brief SIRDUG business session 
 2:45 -  3:30 - Certification Info Session with Roger Sanders.  
         Register to win a copy of his most recent certification guide!
 3:30 -  4:00 - Networking, Adjourn

Registration

To pre-register please email registration@sirdug.org and give us your name, company, 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, Midnight, Monday, February 28th. 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. Go through gate (tell them that you are here for a SIRDUG meeting). 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.

Robert Catterall's Abstract

Title: "Stored Procedures Go Mainstream"

Not so long ago, DB2 for z/OS stored procedures were a fringe element of many an organization's application infrastructure. Now, they're practically commonplace. In this session, I'll describe the benefits of stored procedure utilization. I'll also provide information on how they work (i.e., what goes on "under the covers"), along with recommendations on stored procedure coding, definition, and management.

Bullet Points:
1. From interesting to indispensable
2. From CALL to execution and back
3. Code 'em up and move 'em out
4. Get the definition right
5. Effective stored procedure management

Presentation Platform: DB2 for z/OS

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.

Roger Sanders' Abstract

Title: Developing and Using Stored Procedures

Abstract:
Although DB2 Universal Database has provided support for stored procedures since it first arrived on the PC platform (as Database Manager), significant changes in the way stored procedures are supported have been made in each release. This presentation is designed to walk a developer through the basic steps that must be followed in order to create and use DB2 Universal Database 8.1 stored procedures. Emphasis will be placed on developing stored procedures using C++. Examples for calling stored procedures using embedded SQL, DB2ís Call Level Interface (CLI), and JDBC APIs will also be provided.

Presentation Outline:
I.  Stored Procedures and the DB2 Universal Database Client/Server Environment
    A.   A Normal DB2 Client/Server Application
    B.   A DB2 Client/Server Application that Uses a Stored Procedure
    C.   Advantages of Using Stored Procedures
    D.   Types of Stored Procedures Available
II. Creating an SQL Stored Procedure
    A.   Basic Format of an SQL Stored Procedure
    B.   The Development Center
    C.   The CREATE PROCEDURE (SQL) Statement
III.  Creating an External Stored Procedure
    A.   Basic Format of an External Stored Procedure
    B.   Steps Used to Create an External Stored Procedure
    C.   Steps Used to Make an External Stored Procedure Useable
    D.   The CREATE PROCEDURE (External) SQL Statement
IV.   Invoking a Stored Procedure From a Client Application
    A.   Basic Format of a Client Application
    B.   The CALL SQL Statement
    C.   Calling a Stored Procedure Using Embedded SQL, DB2 CLI, and JDBC
V.  Guidelines to Follow When Implementing Stored Procedures
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. Sally worked with a team of DB2 systems programmers and DBAs at Wachovia to develop and implement the process to move a large application from one mainframe to another without taking a large outage. When she is not performing her DBA duties at work, occasionally she can be seen performing on the opera stage, as she possesses a Master's Degree in Vocal Performance from the Cincinnati Conservatory of Music.

Sally Mir's Abstract

Title: You Can't Get There From Here...Or Can You?

How do you move a large DB2 application from one mainframe to another, rename all of its databasesí datasets, and change the table qualifiers without unloading, recreating the tables, and then reloading the data? A company merger presented just such a dilemma to the DB2 staff at Wachovia Bank. This presentation will outline some of the creative, and perhaps unconventional, methods we used to accomplish the task.

Bullet Points:
1. Defining the scope of what needed to be done
2. Evaluating all the options
3. Moving and renaming the subsystem
4. Changing dataset names and table qualifiers
5. Other application considerations

Presentation Platform: DB2 for z/OS

Danny Null's Biography

Started as an Assembler and COBOL programer in 1986, became MVS Performance and Tuning Analyst 1989, moved into DB2 as an assistant to the DB2 SYSTEMS PROGRAMMER, spent the last 8 years as a DBA. The last two years at MetLIfe in Greenville, SC.

Danny Null's Abstract

Title: A Spoon Feeding of Resource Limit Facility (RLF)

Poorly written or performing dynamic SQL can chew up hours of expensive CPU Resource. This presentation will give you direction to using RLF to control thoses queries and even prevent many of them for ever hitting the queue. The best part is RLF is free, as it comes with DB2.

Bullet Points:
1. RLF Infrastructure
2. RLF Control Table
3. Explain (Still a great tool)
4. Return Codes
5. Recommendations

Presentation Platform: DB2 for z/OS

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

Paul Turpin's Abstract

Title: Make Bad Performance Disappear!

Sometimes performance tuning can yield spectacular results. This presentation talks about a specific project we actually saved a million dollars in four hours with some performance tuning. Without discussing specific vendor tools, the presentation explains how these amazing results were achieved. The presentation shows several ideas for improving any application's performance, including use of Design Advisor.

Bullet Points:
1. Meet a performance hog
2. Performance tweaks that yield big improvements
3. Learn what an explain is and why it matters
4. Design Advisor is an amazing tool!
5. UNIX performance tools for your toolbox

Presentation Platform: DB2 for Linux, UNIX, Windows

IDUG NA 2004 Discount Information

Have you taken a DB2 certification exam? Would you like to get a BIG discount on the IDUG North American Conference 2004? If you subscribe to the DB2 Information Management Software Today newsletter, you probably already know where Iím going with this discussion. If you donít subscribe, then you owe it to yourself to check it out at: http://www.ibm.com/software/data/db2infonews/

This is from the DB2 Information Management Software Today newsletter (January 22 Edition): ďGet a Discount on Your IDUG North America Conference Attendance Fee For a limited time, you may be eligible for great savings on your IDUG conference fee. If you are a certified DB2 professional or a DB2 certification candidate you are eligible for discounts from $50 to $900 on your 2004 IDUG conference registration fee. All you need to do is register online using the appropriate source code by April 9.

For the complete details on this discount offer, visit: http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B33"

Toward the bottom of that webpage you will find the following: ďDiscount attendee fee for first-time IDUG attendees that are Certified DB2 Professionals
If you are a Certified DB2 Professional and you have NOT previously participated in IDUG, you are entitled to a discount conference attendance fee of $995 USD-- nearly a 50% savings! This offer is valid only until the conference advance registration deadline of April 9, 2004, and is effective only on online registrations. Please use source code NA150A during the registration process. All registrants who use these offers will be validated with the IBM professional certification team to ensure eligibility. To register online, or for more information please visit: http://conferences.idug.org/namerica/2004/index.cfm.

Discount attendee fee for first-time IDUG attendees that are DB2 Professional Certification Candidates
If you are working toward becoming a Certified DB2 Professional, but have tested unsuccessfully and you have NOT previously participated in IDUG, you are entitled to a discount conference attendance fee of $1250 USD-- over a 30% savings! This offer is valid only until the conference advance registration deadline of April 9, 2004, and is effective only on online registrations. Please use source code NA150L during the registration process. All registrants who use these offers will be validated with the IBM professional certification team to ensure eligibility. To register online, or for more information please vist:
http://conferences.idug.org/namerica/2004/index.cfm.

Discount attendee fee for repeat IDUG attendees that are Certified DB2 Professionals
If you are a Certified DB2 Professional and you have previously participated in IDUG, you are entitled to a $50 USD discount off your conference attendance fee. This offer is valid only until the conference advance registration deadline of April 9, 2004, and is effective only on online registrations. Please use source code CERNA04 during the registration process. All registrants who use these offers will be validated with the IBM professional certification team to ensure eligibility. To register online, or for more information please visit: http://conferences.idug.org/namerica/2004/index.cfm.Ē

If you arenít on the DB2 certification path, but the above announcements attracted your attention, take a look at: http://www-306.ibm.com/software/data/education/cert/.
This will direct you to information about the certifications that are available, plus some great (and much of it is FREE) study materials.

If you don't qualify for the certification discounts, then you may want to know about the early bird discount of $145 if you register by April 9th and an additional $50 discount for being a member of a RUG (SIRDUG qualifies as a RUG). You can download the RUG coupon by Clicking here


SIRDUG Home Page

Last Update: March 4, 2004

Copyright © 2003 SIRDUG Inc. All rights reserved.