home 
 
 
 
ennl
 
Home
A propos
Services
Cours
Ressources
Contacts
MyABIS
Tous les coursbalkjeGénéralités » Introduction HW & SW » Cycles completsSystèmes d’exploitation » MVS - z/OS » UNIX - Linux - AIX » VMwareBases de données, systèmes transactionnels et middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence et data warehouseDéveloppement d’applications » Méthodiques et techniques » TOGAF » PRINCE2 » Les langages de programmation » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesGestion de système » ITILbalkjeEn pratiqueInscriptions 
Cette page n'est pas disponible en français.
DB2 for z/OS V9: new features

Intended for

Application developers and designers, and database administrators who want to integrate the new capabilities of DB2 9 in their applications and their database design.

Background

Participants should be familiar with application development and utility support in a DB2 environment, version 8 (see course DB2 for z/OS fundamentals course).

Training method

Classroom instruction.

Course leader

Peter Vanroose.

Duration

1 day.

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.

Objectives

This course describes the new features of DB2 9 for z/OS. It provides a technical overview, and discusses areas of potential advantage for the new features. The course is intended for system and database administrators, application developers and others needing a technical introduction to the new features of DB2 9.

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

  • describe the new features and facilities introduced with DB2 9;
  • identify the features withdrawn from DB2 and relevant to their applications and database setup;
  • identify the new features that would particularly benefit their own installation.

Main topics

  • XML support
  • "XML" as a native data type, with internal performance optimization;
  • Storing XML data; XML storage structure; utility extensions to support XML data.
  • On-line schema evolution
  • Database Definition On Demand; table cloning;
  • additional datatypes;
  • ALTER extensions; REORG enhancements.
  • SQL changes
  • continued enhancement of compatibility with the DB2 family;
  • New data types;
  • support for INTERSECT, EXCEPT, MERGE, and TRUNCATE statements;
  • SELECT from DELETE, UPDATE, and MERGE statements;
  • INSTEAD OF triggers;
  • native SQL stored procedures;
  • enriched text handling functions.
  • Security enhancements
  • Improved database security; enhanced auditing functionality; role based security authorisation.
  • Performance
  • 'Not logged' tablespaces;
  • increased index space sizes; randomized index keys;
  • optimization enhancements; wider use of sparse index and in-memory data caching;
  • better LOB performance; memory improvements.
  • Utilities
  • On-line REBUILD INDEX; REORG enhancements; LOAD improvements.
  • Features removed
  • Simple tablespaces; DB2 managed stored procedures; JDBC/SQLJ driver; DB2 Estimator; Net.data.