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


    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact