Objectives:
  After completing this course the student should be able to:
  • create relational objects for application development.
  • Use advanced SQL queries to access and manipulate data on DB2 tables.
  • Review and use different methods of improving performance.
  • Understand the DB2 locking strategy for improving concurrency and maintaining data integrity..
  • Use IMPORT, EXPORT and LOAD utilities to manipulate data.
Target Audience:
  Application developers and designers.
Prerequisite:
 
  • Relevant Operating Systems experience.
  • Programming experience (basic skills).
  • Previous experience with relational database systems and SQL.
Format:
  Classroom instruction and review with hands-on workshops.
Duration:
  Three days.

Outline for DB2 UDB Application Design for Performance for UNIX and Windows

Day 1

  • Creating Objects
  • Logical design for performance
  • SQL Review - optional unit
  • Advanced SQL

Day 2

  • Commits and batch programs
  • performance for SQL and Applications
  • Data Access and EXPLAIN
  • The DB2 Optimizer
  • Program BIND Options
  • Stored Procedures - overview

Day 3

  • TRIGGERS, UDT and UDF
  • DB2 LOCKING
  • DB2 Security
  • DB2 Data Management
  • IMPORT/EXPORT/LOAD utilities