home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral courses » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » Linux - UNIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » Db2 for z/OS » Db2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Data Science, Big data and analyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
Db2 10 for z/OS: changes and new features

This new two-day course introduces and discusses the changes and new features of Db2 10 for z/OS. It provides a technical overview, and discusses areas of potential advantage for the new features.

On successful completion of this course attendees will be able to:

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested ? Please contact ABIS.

Intended for

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.

Background

A working knowledge of Db2 facilities and features.

Main topics

Introduction; Improved efficiency; Migration flexibility; Performance improvements; Continuous availability improvements; Improved concurrence; Reduced catalog contention; Virtual storage relief; Security enhancements; Temporal tables & period data versioning; pureXML enhancements.

Reduced CPU usage; Improved optimization 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 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.

Improved row and column access control; Finer granularity with administrative privileges; Support for new z/OS security features.

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 schema validation; Consistency checking; Increased support for binary and date and time XML data

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 paths; Migration steps; Migration considerations.

Training method

Instructor-led training.

Duration

2 days.

Course leader

RSM Technology.

Reviews

     
Good overview of DB2V10 (, )
     
goede bruikbare informatie. (, )
     
informatief, voegt voor mij veel toe. (, )
     
voldeed aan de verwachting (, )
     
prima! (, )
     
Voldoet perfect aan de verwachtingen (, )
     
Goede cursus om bewust te worden van nieuwe mogelijkheden. (, )
     
veel informatie, maar erg nuttig en toepasbaar in onze situatie (, )
     
Bon cours qui donne un aperçu et ouvre les portes pour aller voir plus loin par nous-mêmes. (, )
     
Iets te complex voor de korte cursus duur. (, )

Refresh this page to see other comments.


SESSION INFO AND ENROLMENT