Date: Thursday December 11, 2014
Place: Giant Super Food Store Community Room, 3301 Trindle Rd , Camp Hill, PA 17011
Reservations: Email: Odessa Fennen - [login to unmask email]<mailto:[login to unmask email]>
Agenda for December 11, 2014
8:30-9:00 Breakfast & Announcements
Sponsored By IBM Corporation
9:00-10:15 "DB2 11 Migration Overview"
Presenter: Charles Lewis, IBM.
This presentation will discuss common challenges of migrating to DB2 11.
10:30-11:45 "DB2 11 Migration Overview - continued"
Presenter: Charles Lewis, IBM Corporation.
Continued part of the first session
11:45 -12:45 Lunch - Sponsored By: IBM Corporation
1:00-2:15 "Archive Transparency in v11"
Presenter: Stan Goodwin, IBM Corporation
Archive Transparency is new for v11 - this will provide an understanding of the feature and uses.
2:30-3:45 "DB2 for z/OS SQL Evolution and Performance for DB2 V10! "
Presenter: Linda Claussen, Themis
Throughout the last several releases of DB2 for z/OS IBM has introduced SQL coding and performance enhancements that are frequently overlooked. This can be achieved by using a multi-solution approach to coding and letting explain tell you which solution is best. The presented case studies in this presentation demonstrates the cost savings and elapsed time improvements when reviewing multiple solutions that produce the same result set to satisfy a given requirement. NOTE: The majority of the SQL coding techniques apply to all DB2 platforms.
1. SQL Evolution
2. Multi-Solution Strategy -A comparison of coding techniques
3. Limiting your trips to DB2 - Good Coding Practices
Database Administrator - Data Engineer III
Analytics & Data Management Practice (AD&M)
HP Enterprise Services
Telephone +1 717.975-5482
Cell +1 717-215-0587
Pager +1 888-323-8935
Email [login to unmask email]<mailto:[login to unmask email]>
225 Grandview Avenue; MS:B2
Camp Hill, PA 17011
2014 IBM Champion
IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate - DB2 10.1 Fundamentals
IBM Certified Database Administrator - DB2 10.1 for Linux/UNIX/Windows
IBM Certified Database Administrator - DB2 9 for z/OS