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