Interfaces

There are a variety of ways to interface with DB2 such as with programs using TSO, CAF, CICS, etc. Two of the most common interfaces provided with the DB2 product are DB2I and SPUFI.

DB2I (DB2 Interactive)

The interactive program DB2I can be used to run application programs and perform many DB2 operations by entering values on panels. DB2I runs under TSO using ISPF (Interactive System Productivity Facility) services. To use it, follow the local procedures for logging on to TSO, and enter ISPF. Each operation is controlled by entering the parameters that describe it on the panels provided. DB2 also provides help panels to:

  • Explain how to use each operation

  • Provide the syntax for and examples of DSN subcommands,DB2 operator commands, ...

Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.