home 
 
 
 
ennl
 
Home
A propos
Services
Cours
Ressources
Contacts
MyABIS
C
Tous les coursbalkjeGénéralités » Introduction HW & SW » Soft skills » Cycles completsSystèmes d’exploitation » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad et iPhone iOSBases de données et middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Big data et analyticsDéveloppement d’applications » Méthodiques et techniques » TOGAF » PRINCE2 » Agile et Scrum » Les langages de programmation » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesGestion de système » ITIL » SecuritybalkjeEn pratiqueInscriptions 
Cette page n'est pas disponible en français.
DB2 10 for z/OS: changes and new features

Objectives

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:

  • 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.

Main topics

  • Summary 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.

 

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.

Training method

Instructor-led training.

Course leader

RSM Technology.

Duration

2 days.

Schedule

Il n'y a pas de sessions publiques a ce moment. Nous organisons volontièrement un cours en entreprise ou une session publique supplémentaire (en cas d'un nombre suffisant de participants). Intéressé ? Veuillez contacter ABIS.

Reviews

     
Veel info, snel tempo (, )
     
Toch weer wat opgestoken over de nieuwe mogelijkheden. (, )
     
Goed, vond het oefenen nuttig. (, )
     
Iets te complex voor de korte cursus duur. (, )
     
Nuttig (voor zover applicatief) Goed om eens te horen (systeem) (, )
     
informatief, voegt voor mij veel toe. (, )
     
Good overview of DB2V10 (, )
     
Voldoet perfect aan de verwachtingen (, )
     
Nuttige informatie. Wel voor : GEN. Niet alles bruikbaar op dit moment (, )
     
prima! (, )

Rafraîchissez cette page pour voir d'autres commentaires.