Home About Courses Schedule Services Webinars Contact Search

REST Interface in Db2 for z/OS


Duration: 2.0 days

Method: Instructor led with hands-on.

Price: $1225.00

Course Code: DB1101


Developers and Administrators interested in deploying REST services on Db2 for z/OS.


Db2 is now capable of fielding distributed requests using the REST API that is popular with many distributed applications. This course will teach you to develop, deploy and test these services.


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

  • Code simple RESTful services in Db2 for z/OS
  • Test the services
  • Deploy RESTful services to multiple environments
  • Understand the environment


A working knowledge of Db2 and SQL.


  • I. An overview of REST
    • Data-as-a-service
    • A little bit of HTTP
    • A little bit of JSON
    • Stateless in nature
    • Caching
  • II. Db2 Configuration
    • Db2 installation jobs
    • Db2 catalog tables for REST Services
    • Authorization
  • III. Coding a RESTful Service
    • REST services and Db2 Packages
    • Using Db2ServiceManager
    • BIND / FREE SERVICE Commands
    • Discovering Existing Services
    • Querying the SYSIBM.DSNSERVICE catalog table
  • IV. Testing REST Services
    • In a browser
    • With a Client
    • Command Line
    • In a Program
  • V. Adding Complexity via Stored Procedures
    • A little bit of SQL PL
    • Invoking a Stored Procedure in a REST Service
  • VI. Logistics
    • Change Control and Versioning
    • Documentation
    • Db2 Catalog Entries
  • VII. Monitoring
    • The Runtime Environment
    • Tracing and Instrumentation
    • -DISPLAY RESTSVC command
    • Monitor and Control via Db2 Profiles
    • Tuning