New Functions and Features in Db2 13 for z/OS

Code: CV321G


Learn about the new features and enhancements of Db2 13 for z/OS, including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS. Note: This course shall be made available a unit at a time.


This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS. The topic of SQL Data Insights may be of interest to Data Analysts familiar with SQL.


You should have practical experience with Db2 for z/OS and have good knowledge of the functions and usage of Db2 12 for z/OS. The course also gives an overview of all the Db2 12 function levels.


  • Describe selected new features and enhancements of Db2 13 for z/OS
  • Evaluate the usefulness of the new features and enhancements of Db2 13 for z/OS


  • Unit 1. V12 Function Levels Selected Highlights
  • LISTAGG built-in function
  • Key label management for dataset encryption
  • Temporal table enhancements
  • z14 Huffman compression, deprecation of certain objects types
  • REBIND PACKAGE phase-in
  • DROP TABLE enhancement
  • Application granularity for locking limits
  • Support for multi-table tablespace migration to UTS PBG
  • Compression algorithm enhancements
  • Required for migration to Db2 13
  • Unit 2. Migrating to Db2 13
  • Migrating to Db2 13 is consistent with continuous delivery
  • The catalog migration process and input is changed
  • Prerequisites for migrating to Db2 13
  • Function level V13R1M100
  • Coexistence between V12R1M510 members and V13R1M100 members
  • The traditional migration approach
  • Using z/OSMF to migrate a Db2 subsystem
  • Function level summary of features
  • Subsystem parameter changes
  • New subsystem parameters
  • Changes to existing subsystem parameters
  • Removed subsystem parameters
  • Unit 3. Availability and Scalability
  • Online deletion of active logs from the bootstrap data set
  • Deleting active logs
  • Deleting active logs without a Db2 outage
  • -SET LOG REMOVELOG command
  • Partition-by-growth to partition-by-range online conversion
  • Considerations for PBG to PBR conversion
  • Requirements for converting tables from PBG to PBR
  • Converting a table from a PBG to PBR partitioning scheme
  • Increased concurrency for ALTER TABLE DATA CAPTURE
  • ALTER TABLE DATA CAPTURE concurrency enhancement
  • Extended common service area improvements
  • Reducing agent local pool below-the-bar storage consumption
  • Storage manager contraction
  • Smarter contraction of DBM1 below-the-bar storage
  • BTB contraction
  • ECSA contraction
  • Database access thread availability improvements
  • Real-time statistics
  • Open data set scalability
  • Increased size of directory table spaces SPT01 and SYSLGRNX
  • Increasing SPT01 and SYSLGRNX table space size
  • Unit 4. Performance
  • Fast index traversal enhancements
  • Index look-aside optimization
  • INSERT enhancements for partition-by-growth table spaces
  • Partition retry process
  • Improved cross-partition search in a descending partition number sequence
  • SORTL enhancements
  • Overview of global lock structure and false contention
  • Reducing the CPU impact in a data-sharing environment when using PBR table spaces with relative page numbers
  • Unit 5. Application management and SQL changes
  • Application timeout and deadlock control
  • Profile table enhancements
  • Enhancing the database object change process
  • Profile table support for the RELEASE_PACKAGE keyword
  • Optimizing DDL processes by using the RELEASE_PACKAGE keyword
  • Selectively disabling high-performance DBATs by using the RELEASE_PACKAGE keyword
  • Migrating distributed applications
  • Unit 6. SQL Data Insights
  • Overview of SQL Data Insights
  • SQL Data Insights use cases
  • Synergy with IBM Z
  • Overview of installing and configuring SQL Data Insights
  • Enabling an AI query
  • Adding AI objects
  • Selecting columns for inclusion
  • Specifying filter values
  • Running AI queries
  • Using the AI_SIMILARITY function
  • Using the AI_SEMANTIC_CLUSTER function
  • Using the AI_ANALOGY function
  • Interpreting AI query results
  • Unit 7. Security
  • Reduced Security Manager contention for Db2 access
  • Plan authorization cache
  • Global authentication cache
  • Improved flexibility in managing plans, packages, and SQL routines
  • Owner type support for packages of SQL procedures and functions
  • Owner type support for packages and plans
  • Db2 support for continuous compliance
  • Read-only archived key Db2 support
  • Unit 8. IBM Db2 for z/OS utilities
  • Utility history (function level 501)
  • Number of SYSUTILITIES rows that are inserted by a utility
  • Cases where utility history is not collected
  • Queries on utility history
  • Enhanced inline statistics with page-level sampling (function level 500)
  • Enhanced space-level recovery (function level 100)
  • REORG INDEX NOSYSUT1 as the default option (function level 500)
  • REPAIR WRITELOG dictionary support (function level 100)
  • Unit 9. Instrumentation and serviceability
  • Index split monitoring enhancements
  • New IFCID 396 trace facility for recording abnormal index splitting
  • New fields for recording and aggregating general index split information
  • Changes to IFCIDs 001 and 003
  • Changes to IFCIDs 365 and 369
  • Enhanced distributed thread monitoring
  • New IFCID 411 trace facility for recording DDF application statistics
  • New IFCID 412 trace facility for recording DDF user statistics
  • Group buffer pool residency time enhancements
  • The STATIME_MAIN subsystem parameter default is now 10 seconds

Price (ex. VAT)

€ 1.640,00 per person


2 days


  •  virtual
  •  02-09-2024 - 03-09-2024
  • register

  •  virtual
  •  28-10-2024 - 29-10-2024
  • register

Delivery methods

  • Classroom
  • On-site (at your location)
  • Virtual (instructor online)


Write us and we will contact you to discuss your requirements
contact us