April 4 SIRDUG Educational Seminars Featuring Dan Luksetich



Meeting Details

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.


Meeting Agenda

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
  

Registration

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.


Directions to Dave & Buster's:

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 Biography

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


SQL and DB2 for z/OS Database Performance Analysis and Techniques


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.