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 predicatesTuning 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.