IDUG DB2 Tech Conference EMEA 2011
Clarion Congress Hotel, Prague, Czech Republic
14 - 18 November, 2011

View Printable Version

DB2 10 for z/OS - In Depth (Full Day)

Session Number: 1844
Track: Full Day Seminars
Session Type: Podium Presentation
Primary Presenter: Phil Grainger [Lead Product Manager, DB2 - BMC Software]
Room(s)/
Time(s):

Aquarius => Fri, Nov 18, 2011 (09:00 AM - 05:00 PM)

Speaker Bio: Phil has over 20 years experience of DB2, starting work all those years ago in 1987 with DB2 Version 1.2. Since then he has worked with all versions, including DB2 9 From his beginnings as a DB2 DBA for one of the largest users of DB2 at that time in the UK, through his time at PLATINUM technology and including almost 10 years as Senior Principal Product Manager for CAs line of DB2 solutions, Phil has always been a keen supporter of user groups and is a regular speaker at both CA sponsored and independent events, as well as being a member of the European IDUG Planning Committee and an inductee into the IDUG Volunteer Hall of Fame Phils foc
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Implementing New DB2 Releases and Features
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Database Administrators, Systems Programmers, New Users, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), High Availability (DB2 for z/OS), New Release (DB2 for z/OS), Security (DB2 for z/OS), SQL and XML Performance
Objective 1: All the exciting new stuff in DB2 10 for z/OS, like
Objective 2: ... Migrating from DB2 V8 as well as DB2 9, More automated install, Catalog restructure (to UTS), Deprecation of Plans with DBRMs, old plan_table formats, DB2 Private Protocol, classic partitioned table spaces ...
Objective 3: and ... Out of the box up to 10% cpu savings, Hash access to data, Include columns in indexes, In-line LOBs, Dynamic statement cache improvements, Dynamic SQL stability and the access path repository, On-line schema evolution and deferred alter, Data 
Objective 4: and ... Row and column level access control, Finer administrator privileges, Administrator privileges without data access, New audit abilities, Immediate compression, LISTDEF partition range support, REORG SHRLEVEL CHANGE enhancements, Temporal data, SQL
Objective 5: and ... XML schema validation in z/OS, Multi versioning of XML data, XML update, insert and delete, XML schema as column modifier, CHECK DATA for XML And much MUCH more

Abstract:  The latest in the series of "In Depth" presentations (that started with DB2 version 6!) looks at the latest and greatest release - DB2 10 for z/OS After the excitement of the Unicode catalog in DB2 V8 and XML in DB2 9, DB2 10 almost goes back to the traditional set of enhancements - but don't underestimate what IBM have delivered This full day class will look at all of the new facilities available in DB2 10 We will look at Migration Migrate from DB2 V8 as well as DB2 9 More automated install Catalog restructure (to UTS) Deprecation of Plans with DBRMs, old plan_table formats, DB2 Private Protocol, classic partitioned table spaces Performance Out of the box up to 10% cpu savings Hash access to data Include columns in indexes In-line LOBs Dynamic statement cache improvements Dynamis SQL stability and the access path repository Availability On-line schema evolution and deferred alter Data "as of" last commit Reorg Aux table improvements Recover backout Security Row and column level access control Finer administrator privileges Administrator privileges without data access New audit abilities Productivity Immediate compression LISTDEF partition range support REORG SHRLEVEL CHANGE enhancements Temporal data SQL PL improvements Moving sum and average XML XML schema validation in z/OS Multi versioning of XML data XML update, insert and delete XML schema as column modifier CHECK DATA for XML And much MUCH more ((Of course - this assumes that DB2 10 will be GA by the time of IDUG NA 2011!!))

For questions or concerns about your event registration, please contact support@idug.org