New Functions and Features in Db2 13 for z/OS

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
• -DISPLAY LOG DETAIL command
• -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
• CURRENT LOCK TIMEOUT
• DEADLOCK_RESOLUTION_PRIORITY
• 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