Dan Luksetich
Baltimore/Washington
DB2 Users' Group
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 |
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 7, 2008.
Who?
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.
Meeting
Schedule:
| 8:30 – 9:00 |
Registration |
|
| |
|
|
| 9:00 – 10:15 |
SQL and DB2 for z/OS Database Performance
Analysis and Techniques |
| |
Dan
Luksetich |
| |
|
|
| |
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 |
| |
|
|
| 11:45 – 12:45 |
Lunch |
| |
|
|
| 12:45 – 2:00 |
SQL and DB2 for z/OS Database Performance
Analysis and Techniques (cont.) |
| |
Dan
Luksetich |
| |
| 2:00 – 2:15 |
Break |
| |
|
|
| 2:15 – 3:30 |
SQL and DB2 for z/OS Database Performance
Analysis and Techniques
(cont.) |
| |
Dan
Luksetich |
To be added to our email notification list for future events, please
fill out our contact list form.
|
|
Directions to the Sheraton Columbia Hotel:
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.
For
more
information, contact one of the Board Members
or Volunteers.
(Board
members and
volunteers are employed by various companies. Their work and efforts to
the BWDB2UG are strictly on a volunteer basis. They will respond
to phone calls by the next business day, if possible. If you do not get
a response, please contact another board member.)
|