DB2 UDB for z/OS Application Programming

 LENGTH OF COURSE:
5 Days

DESCRIPTION: This course is designed to guide students in building application programs using DB2 resources in an efficient manner.

PREREQUISITES: Knowledge of TSO/ISPF, a programming language and an understanding of basic programming concepts.

INSTRUCTION TECHNIQUES: A combination of Lecture, Exercises, and Labs (when/where available).

AUDIENCE

Programmers, Analyst, and Managers that need to understand how to design, develop, and code a DB2 application using a common programming language.
KEY HIGHLIGHTS:

  • DB2 Overview
    • DB2 and Data Objects
    • Tables, Table Spaces
    • Simple, Partitioned, and Segmented Table Spaces
    • Storage Groups, Databases, Indexes
    • Systems Objects and DB2 Catalog
  • DB2 Data Types & NULLS
  • SQL DML and DDL
    • SQL, DML, UPDATE, INSERT, DELETE, DDL
  • Advanced SQL
    • Nulls
    • Boolean Operations
    • Valued Logic
    • Built-In Functions
    • Join
  • SPUFI & DB2 Interactive
    • DB2I and SPUFI Main Panel
    • Changing SPUFI Defaults
    • DCLGEN & Usage
  • Preparing the DB2 Application Program
    • Precompile of Program
    • Rebind the Plan
    • Embedded SQL Concepts
    • SQL Coding & Embedded SQL
    • Singleton vs. Cursor Processing


  • Program Structure
    • Program Structure
    • Host Variables and Structures
    • Null Processing
    • SQLCA
    • Program Aids
    • Using DSNTIAR
    • WHENEVER
    • Recovery
    • Locks, Lock Table, Timeout
    • Deadlock
  • Security
  • Dynamic SQL
    • Static vs. Dynamic SQL
    • SQL Statement Processing
    • Dynamic SQL and SQLDA
    • Execute Immediate
    • Prepare and Execute
    • Fixed-List Select
    • Varying-List Select
    • Resource Limit Facility
  • Performance Considerations
    • Execution Components
    • DBAS Subcomponents
    • SQL Processing and Tuning
    • Non-Indexable
    • Indexable Predicates
    • Stage 1 and 2 Predicates
    • SQL Coding Tips
    • Indexes and Filter Factors
    • Sequential Prefetch
    • Joins


  • EXPLAIN Facility
  • Referential Integrity
    • Overview and Terminology
    • RI Rules
    • DDL
    • PRIMARY AND FOREIGN KEYS
    • DML Restrictions
    • DB2 - Enforced vs. User-Enforced
  • Batch
    • TSO Batch
    • Checkpoint/Restart
    • Commits
  • IBM Query Management Facility
  • DB2 Utilities

FROM OUR STUDENT EVALUATIONS...
"The manual material will be useful. Plus, the labs provided useful exposure."

Bruce Daniels
State of Minneapolis

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.