Db2 for z/OS Extended Features and Complex Object Administration

Beyond the base table, Db2 supports the creation and management of a wide variety of special purpose object types that can promote the performance and usability of your base tables. These extended features of Db2 are vitally important to the success of your Database design and implementation. Use of the extended features will directly impact the administration of your database. We cover the Creation, usage and management of these “Extended Features” and complex objects.
Db2 for z/OS Database Administration or equivalent knowledge and prerequisites which includes Introduction to Db2 & SQL coding basics and TSO/ISPF, MVS JCL.
3 Days/Lecture & Lab
Db2 Application and System Database Administrators who will be designing and managing Db2 Databases.
  • Introduction
  • Event Based Extensions, Triggers
  • Application Performance Extensions
  • Extensions to the SQL Language
  • Extended Table Types
  • LOBs and XML Data Types
  • Profiles
  • Security Related Objects

Related Scheduled Courses