Articles & Content

Archives

DB2 10 Overview - G10

Topic: DB2 for z/OS

Subtopic: 2012



This double session will look at all of the new facilities available in DB2 10 at a very high level

Including, in part 1

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


Then in part 2

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



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.