DB2 10 for z/OS: Changes & New Features
Course
In High Wycombe
Description
-
Type
Course
-
Location
High wycombe
-
Duration
2 Days
On successful completion of this course, attendees will be able to: describe the relational concepts and theory, and the advantages of a RDBMS, describe the components of the DB2 system, their function, and how they are controlled, identify the objects used to store DB2 data and the relationships between them, code the SQL statements needed to create and modify DB2 data. Suitable for: All IT professionals who need to understand and work with the DB2 UDB for z/OS.
Facilities
Location
Start date
Start date
About this course
A basic understanding of IT, with some exposure to database technology as a user. Whilst not essential, a knowledge of TSO/ISPF would be beneficial.
Reviews
Course programme
Objectives
On successful completion of this course attendees will be able to:
- describe the new features and facilities introduced with DB2 10
- describe migration possibilities and issues
- identify the changes to commands, utilities and SQL relevant to their own organisation
- identify the new features that would particularly benefit their own installation.
Who Should Attend
This course is designed for systems and database administrators, application developers and designers, and all others needing an introduction to the new release and what it offers.A working knowledge of DB2 facilities and features.
ContentsSummary of DB2 10 for z/OS Changes & Features
Introduction; Improved efficiency; Migration flexibility; Performance improvements; Continuous availability improvements; Improved concurrency; Reduced catalog contention; Virtual storage relief; Security enhancements; Temporal tables & period data versioning; pureXML enhancements.
Performance Enhancements
Reduced CPU usage; Improved optimisation techniques; High performance database access threads; I/O parallelism for index updates; Buffer pool enhancements; Universal tablespace enhancements; Large object & XML streaming enhancements; Non-key columns in unique indexes; Extended SQL procedural language support; Data access enhancements; Log contention reductions; Catalog contention reductions; Workfile enhancements.
Availability Enhancements
Availability Enhancements Online schema change enhancements; Online REORG enhancements; Improved lock avoidance techniques; Partition rotation enhancements; Point-in-time recovery enhancements; Easier addition of active log datasets.
Security Enhancements
Improved row and column access control; Finer granularity with administrative privileges; Support for new z/OS security features.
Distributed Functionality
64-bit ODBC driver support; DRDA support of Unicode for system code pages; Extended indicator variables; Universal language interface module; JDBC & SQLJ driver enhancements.
XML Enhancements
XML schema validation; Consistency checking; Increased support for binary and date and time XML data
SQL Enhancements
Temporal tables; system-period data versioning; Enhanced SQL scalar functions; SQL table functions; Enhanced native SQL procedures; Implicit casting; TIMESTAMP enhancements; Moving sums & averages.
Migration Considerations
Migration paths; Migration steps; Migration considerations.
DB2 10 for z/OS: Changes & New Features