DB2 for VM Concepts and Application Programming

LENGTH OF COURSE:
5 Days

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

PREREQUISITES: Knowledge of a text editor, a programming language and an understanding of basic programming concepts. COBOL programming examples are included throughout the course.

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 VM application using a common programming language.
KEY HIGHLIGHTS:

  • DB2 VM Overview
    • DB2 VM and Data Objects
    • Tables, DBSPACE
    • Simple, Partitioned, and Segmented Table Spaces
    • Storage Pools, Databases, Indexes
    • Systems Objects and DB2 Catalog
    • Migrating from other data systems
  • DB2 Data Types & NULLS
  • SQL DML and DDL
    • SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING, UNION
    • CREATE, ALTER, DROP
  • Advanced SQL
    • Nulls & Boolean Operations
    • Valued Logic
    • Built-In Functions
    • Join
  • DB2 Interactive SQL
  • Preparing the DB2 Application Program
    • Precompile of Program
    • BINDing Packages
    • UPDATE STATISTICS
    • Embedded SQL Concepts
    • SQL Coding & Embedded SQL
    • Singleton vs. Cursor Processing


  • Program Structure
    • Host Variables and Structures
    • Null Processing
    • SQLCA
    • Program Aids
    • WHENEVER
    • Recovery
    • Locks, Lock Table, Timeout
    • Deadlock
  • Security
    • GRANT/REVOKE
  • Dynamic SQL
    • Static vs. Dynamic SQL
    • SQL Statement Processing
    • 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
    • System Performance and Infrastructure


  • EXPLAIN Facility
    • COST_TABLE
    • PLAN_TABLE
    • REFERENCE_TABLE
    • STRUCTURE_TABLE
  • Database Design, Modeling and Referential Integrity
    • Overview and Terminology
    • RI Rules
    • DDL
    • PRIMARY AND FOREIGN KEYS
    • DML Restrictions
    • DB2 - Enforced vs. User-Enforced
  • Batch Considerations
  • Locking and Concurrency
  • DB2 VM Utilities & Recovery
FROM OUR STUDENT EVALUATIONS...
"No negatives at all. This course was exceptional."

Ed Wilbourne
Anne Arundel County Government

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