High Performance Application Design on Db2 z/OS

Duration: 3.0 days

Method: Instructor led, Hands-on workshops

Price: $1800.00

Course Code: DB1051

Audience

Db2 Developers, Database Administrators, Db2 Project Leaders and Analysts, and Application Personnel who will be designing, coding, and implementing Db2 Databases and Application Systems.

Description

Implementing logical database and physical design on Db2 for z/OS requires an understanding of the inner workings of this platform and an understanding of the application processing the data. Learn and discuss some of the things to consider when making this transition in this action packed course. Application design is as critical a part of high performance design as the logical and physical aspects of a database application. Design considerations for high performance will involve logical design, physical design, and application considerations. This is a great course for developers and others to understand everything involved to get peak performance.

Prerequisites

DB1000 or equivalent experience

Topics

I. Logical Modeling
- Conceptual Design Overview
  - Entity Relationship Model
  - Normalization
  - ER Mapping - Detail Example
  - Transaction Analysis - Transaction Maps
  - Process/Entity Matrix
- Major Design Issues
II. Composite Logical Design
- Table and Column Design
- Table Structure
- Tables
  - Create Syntax
  - Table Column Formats
  - Date/Time Formats
  - Character String Formats
  - Graphic String Formats
  - NULL Characteristics
  - Alter Tables
  - Referential Integrity
  - Table Check Constraints
  - Potential Problems
  - Check Constraints
- Referential Integrity
- Normalization / Denormalization
- Db2 Views
III. Db2 Physical Design
- Physical Components
- Partitioning Choices
- Storage Groups
- “Classic” Partitioning
  - Index Controlled
  - Table Controlled
- Universal Partitioning
  - Partition by Range
  - Partition by Growth
- Secondary Indexes
  - NPSI
  - DPSI
- Adding & Rotating Partitions
- INDEX STRUCTURE
- INDEXES
  - Index Processing
  - Create INDEX Syntax
IV. Access Paths and Performance Tuning
- Software Levels
- Stage 1 and Stage 2 Predicates
- Db2 Access Paths
  - Table Space Scans
  - Index Scans
  - Non Matching Index Processing
  - Matching Index Processing
  - Multiple Index Processing
  - Index Only Processing
- Sort Activity
- What Explain Doesn’t Say
- How to read the Visual Explain
- How to Navigate IBM Data Studio
V. Db2 Application Design
- Mass Delete Processing Choices
- Mass Insert Processing Choices
- Performance – What to Focus on
- Mass Processing Tuning Tips
VI. Db2 Temporal and Archive Tables
- Temporal System Tables
- Temporal Business Tables
- V11 Transparent Archive Tables
VII. Locking Strategies and Application Concurrency
- What is Concurrency
- Transaction Locks
- Db2 Locks
- Bind Options
- Isolation Options
- Currentdata
- Lock Table
- Skipped Locked Data
- Currently Committed Processing
- Concurrency Guidelines
VIII. Workshops
- IBM Data Studio Overview
- Explain Workshops
- Temporal Table Workshops
- Archive Table Workshops