DB2 10 for z/OS - In Depth

Date: 
Thursday, 29 maj, 2014 - 09:00 - 16:00
Program: 
z/OS Track
Speaker: 
Phil Grainger

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

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023