Course Details

About the course

This course presents the fundamental concepts and programming techniques required to access DB2 for z/OS data through application programs. Students will learn to code programs with embedded SQL and to use a variety of attachment facilities to run those programs against DB2 for z/OS databases. The course includes many hands-on programming exercises which give students the opportunity to develop programming skills, learn good programming techniques and implement programming best practices while accessing DB2 data. Students taking this course should have a basic understanding of relational databases (preferably DB2 for z/OS) and a basic knowledge of SQL.

Upon successful completion of this course, students will be able to:

  • Understand the physical design of a DB2 for z/OS database, and how this design impacts application development
  • Describe key features in DB2 for z/OS which support application development
  • Understand application environments and their connections to DB2 for z/OS
  • Utilize a variety of advanced query capabilities provided by DB2 for z/OS in accessing data via application programs
  • Design, develop, prepare, and deploy both local and remote application programs which access DB2 for z/OS data
  • Leverage traditional and new application development technologies such as C, C++, Java, XML, SOA, and Web Services
  • Recognize and troubleshoot database and application performance issues

To meet these goals, the course covers the following topics:

  • Programming APIs for DB2 for z/OS
    • Overview
      • Application development foundations
      • Creating a simple application in TSO
      • Creating a simple application using RDz toolset
    • Programming Interface
      • Host language interfaces (COBOL, PL/1, etc)
      • CLI/ODBC interfaces
      • JDBC/SQLJ interfaces
    • Preparation and Execution
      • Preparation of programs with embedded SQL, JDBC applications, SQLJ applications, and stored procedures
      • Executing programs under TSO
      • Using DB2I to prepare and run programs
    • Extended Functionality
      • Triggers
      • UDF – user defined functions
      • Stored procedures
    • Running COBOL programs in CICS
  • Exploitation of SQL Functions
    • SQL Deep Dive
      • Physical database design
      • Advanced query design
      • Security and authorization
    • Application Performance Tuning
      • Application performance monitoring techniques
      • Application performance tuning techniques
      • New Database Applications
    • pureXML
      • Application development support for XML
      • SOA and DB2 Web Services
      • Web Services programming using Data Studio
      • pureQuery using Data Studio
      • Spatial data analysis
    • Additional topics to be determined by the instructor

Students taking this course should have a basic understanding of relational databases (preferably DB2 for z/OS) and a basic knowledge of SQL.

An image of a badge

Earn IBM Digital Credentials

A badge demonstrating proficiency with DB2 application programming.

Course title Instructors Timing
Introduction to z/OS and Major Subsystems Instructor Click Here
DB2 Fundamentals Instuctor Click Here
DB2 Fundamentals Instuctor Click Here
DB2 Application Programming Instructor Click Here

Introduction to z/OS and Major Subsystems







Ready to learn with us?

Sign-up Now