IDUG Meeting featuring Tony Andrews

SIRDUG Meeting July 22nd, 2010

SIRDUG is very pleased to announce that the next SIRDUG meeting on July 22nd, will feature Tony Andrews of Themis. Tony will present "Top 25+ DB2 Tuning Tips". Tony Andrews has more than 23 years’ experience in the development of IBM DB2 relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and has also served as a DB2 database analyst. His experience has shown that the majorities of performance issues are directly related to poorly coded programs or improperly coded SQL statements. For the last 10 years, Tony has been splitting his time between performance and tuning consulting engagements and DB2/SQL training. His main focus is to teach today’s developers the ways of RDMS application design, development and SQL programming -- always with a special emphasis on improving performance.

Vikram Khatri, the developer of the IBM Data Movement Tool, will be doing a presentation about this tool.

Eric Offenberg will be presenting "A Smarter Approach to Data Security, Privacy and Compliance" in the afternoon.



Meeting Details

WHEN? Thursday, July 22, 2010

WHERE? The Baxter Hood Center (Rock Hill, SC) See directions below

COST? $30 cash or check, in advance or at the door.
We do not accept credit cards. We are working on a way to accept Paypal and credit cards, so stay tuned for upcoming announcements.


Tentative Meeting Agenda

Meeting Agenda

 8:00 -  8:50 - Registration - Coffee, Danish, and Networking
 8:50 -  9:00 - SIRDUG announcements and speaker introductions 
 9:00 - 10:15 - Tony Andrews - "Top 25+ DB2 Tuning Tips" (DB2 for z/OS)
                     Vikram Khatri "IBM Data Movement Tool"  (DB2 for LUW)
10:15 - 10:40 - Mid-Morning Break
10:40 - 11:50 - Tony Andrews "Top 25+ DB2 Tuning Tips" (DB2 for z/OS)
                      Vikram Khatri "IBM Data Movement Tool"  (DB2 for LUW)
11:50 - 12:50 - Lunch
12:55 -  2:00 - Eric Offenberg - "A Smarter Approach to Data Security, Privacy and Compliance" (Cross-Platform)
 2:00 -  2:20 - Mid-Afternoon Break
 2:20 -  3:15 - Eric Offenberg - "A Smarter Approach to Data Security, Privacy and Compliance" (Cross-Platform)
 3:30 -  3:45 - Networking, Adjourn

We are still working on the exact agenda, so what you see may change 
a bit.

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, July 16th. 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 to The Baxter Hood Center:

The Baxter Hood Center
452 S. Anderson Road
Rock Hill, SC 29730
803-981-7100

Less than 2 miles from I-77 & Dave Lyle Blvd intersection (south side of Charlotte).


Presentation for Downlaod

To download Tony Andrews presentation "Top 25+ DB2 SQL Tuning Tips for Developers" click here

To download Vikram Khatri presentation "IBM Data Movement Tool – DBA" click here

To download Eric Offenberg - "A Smarter Approach to Data Security, Privacy and Compliance" click here


Tony Andrews' Biography

Tony Andrews has more than 23 years’ experience in the development of IBM DB2 relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and has also served as a DB2 database analyst. His experience has shown that the majorities of performance issues are directly related to poorly coded programs or improperly coded SQL statements. For the last 10 years, Tony has been splitting his time between performance and tuning consulting engagements and DB2/SQL training. His main focus is to teach today’s developers the ways of RDMS application design, development and SQL programming -- always with a special emphasis on improving performance.

Title: "Top 25+ DB2 Tuning Tips"

Review:
•	The RDMS Optimizers
•	Stage 1 versus Stage 2 predicates
Tuning Tips:
•	Watch out for SQL scalar functions in predicates
•	Watch out for mathematics in predicates 
•	Stay away from Distinct if at all possible 
•	Minimize SQL requests to the RDMS
•	Give prominence to Stage 1 over Stage 2 predicates 
•	No filtering logic within application code (stage 3)
•	Take advantage of DB2 Rowset positioning when using cursors
•	Take advantage of SQL Scalar Fullselects 
•	Watch out for tablespace scans
•	Only code the columns needed 
•	Watch out for any sorts
•	Know how to rewrite ‘In’ versus ‘Exists’ subqueries 
•	Pay attention to data catalog statistics
•	Know the different data statistics needed
•	Hard coding versus using variables
•	Index correlated subqueries
•	Avoid discrepancies with non column expressions
•	Watch out for subqueries involving min and max functions
•	OLTP suggestions
•	Insert with a Select
•	Checking for non existence
•	Left versus Right outer joins
•	V8 SQL Enhancements
•	V9 SQL Enhancements

    Ten steps to tuning a query:  Where to start.


Vikram Khatri' Biography

Vikram S Khatri works for IBM in the Sales and Distribution Division and is a member of the DB2 Migration team. Vikram has 24 years of IT experience and specializes in enabling non-DB2 applications to DB2. Vikram supports the DB2 technical sales organization by assisting with complex database migration projects as well as with database performance benchmark testing.

Title: "Data Movement Tool"

The data Movement Tool is a very simple and powerful tool that enables applications from Oracle to be run on IBM® DB2® Version 9.7 for Linux®, UNIX®, and Windows®. The tool can also be used to move data from various other database management systems to DB2 for Linux, UNIX, and Windows and DB2 for z/OS®. Vikram will be reviewing it in detail.
To view the reference for the tool click here


Eric Offenberg' Biography

Eric has held management positions at Oki Data Americas, Quantex Microsystems, and National Discount Brokers. He holds a Masters of Business Administration with a concentration in Marketing from Rider University and a Bachelor of Arts degree in Communications with a concentration in Public Relations from Rutgers University.

Eric Offenberg, CIPP and WW Industry Sales Lead for IBM, has nearly 13 years of technology marketing and sales experience across various industries. Eric has established himself as a data governance thought leader, who speaks frequently on data management issues to Corporate Executives as well as at industry events and webinars. Eric has been featured at the Harvard University Privacy Summer Symposium and in the UK at the Privacy Laws and Business Conference at Cambridge University, as well as at various CIO Forums

Title: "A Smarter Approach to Data Security, Privacy and Compliance"

A Smarter Approach to Data Security, Privacy and Compliance Data breaches, privacy violations, increasing regulatory requirements. With these all-to-frequent challenges, today’s organizations are recognizing the need to take a more strategic approach to information governance, and protecting data within the enterprise. Securing and protecting data requires a holistic approach, taking into consideration the broad range of data threats. Organizations need to understand these threats and develop a comprehensive strategy to protect that important asset - information.

Threats to your data are growing and changing every day!

In this session, you will learn:
  • To safeguard your data as part of an overall integrated data management strategy
  • How to leverage data discovery techniques to ensure sensitive information is identified and protected
  • How current regulatory requirements impact today’s organizations data privacy and security strategies
  • What areas of concern and vulnerability should be part of your data management strategy
  • Actionable, best practices to ensure data privacy and security throughout the enterprise


SIRDUG Home Page

Last Update: July 27, 2010 , 2010

Copyright © 2010 SIRDUG Inc. All rights reserved.