Baltimore / Washington DB2 Users Group
Archived
BWDB2UG z/OS Educational Session

Dan Luksetich

When? Wednesday, March 12, 2008, 9:00AM-3:30PM (registration at 8:30)

Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered: $225
At-the-door: $325

Meeting Schedule:

  8:30 - 9:00 Registration
 
  9:00 - 10:15 SQL and DB2 for z/OS Database Performance Analysis and Techniques
  Dan Luksetich; Yevich, Lawson, & Associates
 
 

This seminar will introduce SQL performance basics and filtering, and provide those skills necessary to analyze and improve SQL statements for performance. In addition, advanced SQL will be highlighted along with its performance impact and its use to improve performance. The proper monitoring of systems and SQL will be presented so that the most important SQL will be tuned first. The impact of advanced database objects, such as stored procedures, user-defined functions, triggers and constraints will be discussed in regards to performance. Techniques for the simulation and testing of performance concepts will be presented along with advanced database table and index design for performance.

For more details, see SQL and DB2 for zOS Database Performance Analysis .

 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 SQL and DB2 for z/OS Database Performance Analysis and Techniques (cont.)
  Dan Luksetich; Yevich, Lawson, & Associates
 
  11:45 - 12:45 Lunch
 
  12:45 - 2:00 SQL and DB2 for z/OS Database Performance Analysis and Techniques (cont.)
  Dan Luksetich; Yevich, Lawson, & Associates
 
  2:00 - 2:15 Break
 
  2:15 - 3:30 SQL and DB2 for z/OS Database Performance Analysis and Techniques (cont.)
  Dan Luksetich; Yevich, Lawson, & Associates
 

To pre-register, you can 1) use PayPal or 2) mail a check.

1) To pay via PayPal, simply click the link below and follow the directions; then send us an email to let us know the names of everyone in your group who will be attending.

2) To pay by check, mail the check with attendee and company name to:

The Baltimore/Washington DB2 Users' Group
P.O. Box 18554
BWI Airport, Maryland 21240

All pre-registrations must be received by Friday, March 7th, 2008.

Directions to the Sheraton Columbia Hotel
Generate directions via Google Maps
From Baltimore and North
Take I-95 South and exit Rt. 175 West (exit 41B). Travel 6 miles on 175 West. After crossing Rt. 29, go through 5 lights. After the 5th light, make first left onto Wincopin Circle. The Sheraton Columbia Hotel and Conference Center is located at the end of the Wincopin Circle, on the lake.
From Washington and South
Take I-495 East to I-95 to Rt. 32 West. Travel 3 miles North to Rt. 29 North. Travel 2 miles on Rt. 29 North to Broken Land Parkway (exit 18B). Follow signs for Columbia Town Center to Little Patuxent Parkway. Turn right and go through 3 lights. Wincopin Circle is on the right. Go to second entrance of Wincopin Circle and turn right. The Sheraton Columbia Hotel and Conference Center is located at the end of Wincopin Circle, on the lake.
Speaker Backgrounds
Dan Luksetich is a senior DB2 DBA. He works as a DBA, application architect, presenter, author, and teacher. Dan has been in the information technology business for over 22 years and has worked with DB2 for over 17 years. He has been a COBOL and BAL programmer, DB2 system programmer, DB2 DBA, and DB2 application architect. His experience includes major implementations on z/OS, AIX, and Linux environments. He is co-author of DB2 9 for z/OS Database Administration Certification Study Guide.
Have a topic?
The Baltimore/Washington DB2 Users' Group welcomes suggestions for topics of interest for future meetings. Drop us a line if you have a particular topic you feel would be of interest. If you would like to share, then volunteer as a speaker and gain the satisfaction of helping other DB2 professionals benefit from your experiences.