This course presents the new features and enhancements of Db2 for z/OS 13. It also provides details on each enhancement and insight into consideration and usage.

• Db2 Function Levels and APARs

• Modes and Prerequisites for Migration

• Availability and Scalability Features

• Performance Enhancements

• Application Management and SQL Changes

• AI and SQL Data Insights

• Security and Auditing

• Db2 Utility Enhancements

• Instrumentation and Serviceability

.

This class teaches how to design, create and maintain Db2 z/OS databases. It covers logical and physical modeling in order to design and normalize a relational Db2 database. It also teaches how to define Db2 objects: databases, storage groups, table spaces, tables(temporal, archive, MQTs, clone), indexes, and views. Development and implementation of maintenance utilities and backup and recovery practices are also covered.

This course teaches how to install, migrate and administer Db2. System components such as logs, BSDS and catalog/directory are detailed. Topics regarding storage, memory, CPU, specialty engines and performance and tuning are covered from a systems perspective.

With every new release of Db2 we look to see what features will allow us to improve the capabilities and performance of our existing applications as well as the availability of our data. We also have to plan to utilize new features in our development efforts. This presentation takes a look at the features in Db2 12(+ FLs) and 13, that will improve our performance and provide us with maximum data availability as well as advanced application development. We will be focusing on features (including those in the most current function level) that can be utilized by DBAs and application programmers.

This seminar will discuss many issues surrounding alternative table and index designs for performance and availability current with Db2 13 for z/OS. We will look at many different alternatives to help design tables and indexes for the best performance possible for the type of application process and how to achieve high availability. There are many issues to consider for high volume insert and update transactions, and a balancing act to be achieved for responsiveness to readers. We will also look at issues with designing VLTBs (Very Large Tables) and XVLTBs (eXtremely Large Tables) – the rules have changed! Index issues such as minimizing indexes, using NPSIs or DPSIs, and using indexes for best possible performance will be discussed.

This course is a certification preparation course intended to help you take the Db2 12 for z/OS Administrator Exam – C1000-078. All topics addressed in the exam will be covered as well as hints and tips on taking the exam.

This seminar will cover many best practices for our applications in order to achieve performance and reduce CPU in Db2 z/OS. Many techniques to minimize overhead and locking will be explored. We will take a look at techniques for coding efficient SQL and minimizing the amount of data we bring back to process in our applications via optimal predicates, less repetition and better use of indexes. We will also look at how to best utilize the dynamic statement cache and to use it in performance tuning efforts along with several Explain tables.

This seminar provides a review of the basics of data sharing, its implementation and various aspects of performance. Data sharing was introduced to allow multiple Db2 subsystems running on multiple z/OS systems to concurrently read or write shared Db2 databases. Data sharing in a parallel sysplex environment allows for extended processing, improved availability, and design flexibility. Db2 data sharing brings many new issues to the table such as coupling facilities, sysplex timers, group buffer pools, and global locking.

We will cover all of the components necessary for operating in a data sharing environment, how Db2 uses these components and how they implemented. There are also many considerations with performance and recovery that must be considered when operating in a data sharing environment.

This seminar covers how to define and develop a methodology for collection/storage of critical performance data for trending, analysis and troubleshooting efforts. Evaluate identified cost/CPU savings opportunities and better troubleshooting capabilities and better design for anticipated workload increases.

With every new release of Db2 we look to see what features will allow us to improve the capabilities and performance of our existing applications as well as the availability of our data. We also have to plan to utilize new features in our development efforts. This presentation takes a look at the features in Db2 12(+ FLs) and 13, that will improve our performance and provide us with maximum data availability as well as advanced application development. We will be focusing on features (including those in the most current function level) that can be utilized by DBAs and application programmers.