DB2 Developer's Guide comes Alive

Session Number: 373
Track: Educational Seminars
Session Type: Podium Presentation
Primary Presenter: Craig S Mullins [http://www.craigsmullins.com]
Time: Apr 29, 2013 (08:30 AM - 05:00 PM)
Room: Curacao 1&2

Speaker Bio: Craig S. Mullins is a data management strategist, researcher, and consultant.

He is president and principal consultant of Mullins Consulting, Inc.
He is a principal with SoftwareOnZ, a mainframe software distributor.
He is the publisher and editor for The Database Site.

Craig has more than two decades of experience in all facets of database systems development including developing and teaching DB2 and SQL Server classes, systems analysis and design, database administration and system administrator, and data analysis and modeling. He has worked with DB2 for z/OS since Version 1 and has experience working with other database technology including Microsoft SQL Server, Sybase and IMS. Craig has
worked in multiple industries including manufacturing, banking, commercial software development, education, research, utilities, and consulting.

Craig was appointed as an IBM Information Champion in 2009, 2010, and 2011.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Application Design, Implementing New DB2 Releases and Features
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, New Users
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), SQL and XML Features, SQL and XML Performance, Triggers, Stored Procedures, UDFs
Objective 1: A performance tuning roadmap for managing DB2 application, database and system performance. Learn SQL coding and tuning techniques, guidance for database optimization and reorganization, coverage of buffer pool settings and parameters for performance.
Objective 2: Logical and physical database design recommendations for DB2, so you can build and maintain effective DB2 databases immediately. Includes discussion of standards, logical to physical translation, data types, nulls and more.
Objective 3: Coverage of the newer features added to DB2 in recent versions that can boost application performance, such as REOPT enhancements, plan management, multi-row FETCH and index on expressions.
Objective 4: Tips and guidelines for writing efficient and effective DB2 SQL.
Objective 5: Coverage of the new features added in DB2 version 10. Some of the features to be previewed will include hash access, index include columns, efficient caching of dynamic SQL statements with literals, temporal data and time travel queries, and much more.

Abstract:  The material is based upon DB2 Developer’s Guide, the best-selling DB2 for z/OS book on the market. The book, and the course, have both been fully updated for DB2 10 for z/OS. Additionally, the course material will contain references to sections of the book for students to find additional material on each topic after the sessions.