DB2 Advanced Topics

 
  

Objectives:

 

 This course concentrates on application programming and performance aspects of DB2. The cursist will also learn how to use the DB2 catalog and plan tables in order to improve performance.

Subjects covered:
  • DB2 objects
  • Cursor programming
  • Dynamic SQL
  • Stored Procedure concepts
  • DB2/MVS Performance
  • DB2 Utilities
  • Physical Data Management
  • Commit Processing and Locking Strategies
  • Performance considerations
  • Referential and Explain feature
  • DB2 Utility program overview

Participants:

 DB2 Programmers, Analysts and Administrators

Prerequisites:

 DB2 programming experience.

Remarks:

 None

Teaching method:

 Classical, with examples and practical exercises.

Course duration:

 3 days

Cost:

 1050,- EUR excl. tax

Register for course: