April 4 SIRDUG Educational Seminars Featuring Dan Luksetich
WHEN? April 4 (Friday)
WHERE?
Dave & Buster's
This is located in the Concord Mills Mall, right off I-85.
For detailed directions click here
COST? $210 cash or check, per day, at the door.
We do not accept credit cards.
April 4
Featured Speakers - Dan Luksetich
8:00 - 9:00 - Registration - Coffee, Danish, and Networking
9:00 - 9:10 - Announcements
9:10 - 10:20 - Dan Luksetich - SQL and DB2 for z/OS Database Performance Analysis and Techniques
10:20 - 10:40 - Break
10:40 - 11:50 - Dan Luksetich - SQL and DB2 for z/OS Database Performance Analysis and Techniques
11:50 - 12:50 - Lunch
1:00 - 2:10 - Dan Luksetich - SQL and DB2 for z/OS Database Performance Analysis and Techniques
2:10 - 2:40 - Break
2:40 - 3:50 - Dan Luksetich - SQL and DB2 for z/OS Database Performance Analysis and Techniques
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, March 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.
8361 Concord Mills Boulevard
Concord, NC
(704)979-1700
I-85 to Exit 49
Concord Mills Blvd. 2 miles from Lowe's Motor Speedway,
10 miles north of downtown Charlotte, and 17 miles from Charlotte Douglas
International Airport.
You can get a better map at the
Concord Mills Mall site.
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. This includes:
Application design, Database administration, Complex SQL, SQL tuning, DB2 performance
audits, Replication, Disaster recovery, Stored procedures, UDFs, and triggers. He is a
certified DB2 DBA and application developer, and the author of several DB2 articles and
books.
Educational Seminar Details
Database are growing at extreme rates, and with ever increasing
transaction volumes and complexity it is most important to have the
proper design in place and tested prior to implementation. Once the
database is implemented it may be accessed via many different ways
(mainframe, intranet, Internet), and you have to be able to track and
report on application performance in a complex environment. This seminar
will introduce the participant to SQL performance basics and filtering,
and give the user the skills to analyze and improve SQL statements for
performance. In addition, the participant will be introduced to advanced
SQL, and the impact on performance, as well as the ability to use advance
SQL for performance improvement. The proper monitoring of systems and SQL
will be presented so that the most import SQL will be tuned first. The
impact of advanced database object 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.
Areas Addressed:
-SQL Access Paths
-Filtering in SQL Statements
-Different Types of Predicates (Indexable, Stage 1, Stage 2)
-Filter Factor
-Improving the Performance of SQL
-Promoting Predicates
-Advanced SQL and Performance
-Using Advanced SQL for Performance
-Advanced Database Objects and Performance
-Proper Performance Monitoring
-Use of DB2 Explain
-Simulation of Performance Concepts
-Performance Testing
-Table and Index Design Tips for Performance
If you have any links that you would like to see on our pages,
send SIRDUG an EMAIL using our mail box below.
SIRDUG Home Page
Last Update: February 28, 2008
Copyright © 2008 SIRDUG Inc. All rights reserved.