A propos
Tous les coursbalkjeGénéralités » Introduction HW & SW » Soft skills » Cycles completsSystèmes d’exploitation » MVS - z/OS » Linux - UNIX » 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 » Data Science, 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 12 for z/OS: changes and new features

This single-day course introduces the changes and new features of Db2 12 for z/OS. It provides a technical overview, and discusses areas of potential advantage for the new features, as well as caveats and potential problems with new features.

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


Il n'y a pas de sessions publiques à 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.

Intended for

This course is designed for systems and database administrators, application developers and designers, and all other Db2 users needing an introduction to the new release and what it offers.


A working knowledge of Db2 for z/OS.

Main topics

"Advanced triggers" having a full SQL PL body; arrays as global variables; enhanced MERGE statement; DML pagination: OFFSET clause, multi-column predicates; DELETE with FETCH FIRST; new OLAP functions

New faster insert algorithm; automated RUNSTATS runs; optimizer improvements (e.g. for UNION ALL, outer joins, temporal queries, top-n pushdown; adaptive list prefetch)

Transfer ownership of: database, tablespace, table, index, view, stogroup; partition sizes up to 1TB; RTS & some catalog tables can be made temporal

Unicode columns in EBCDIC tables; referential integrity for temporal tables

Optional obfuscation ("wrapping") of the body of an SQL PL procedure, trigger, or function; UNLOAD privilege; resource limit facility for static SQL

XMLMODIFY can now update multiple documents and use the FLWOR notation; enhancements to the functions XSLTRANSFORM and JSON_VAL

New commands (related to function level, to dynamic statement cache, and to statistics collection)

Simplified migration process: gradually enabling new features through "function levels".

Training method

Instructor-led training.


1 day.

Course leader

Peter Vanroose.