Begin detailed description.
This figure is a flowchart that depicts the difference between ODBC drivers that operate under a driver manager and the Db2® for z/OS® ODBC driver. This description is divided into two sections: the ODBC driver manager environment, and the Db2 for z/OS application environment.
The following table presents the components
of the ODBC driver manager environment and describes the relationship
of those components.
| Component | Relationship |
|---|---|
| Application | Sends output to and receives input from the ODBC driver manager. |
| ODBC driver manager | Manages ODBC driver A, ODBC driver B, and the Db2 ODBC driver. |
| ODBC driver A | ODBC driver for database server A. |
| ODBC driver B | ODBC driver for database server B. |
| Db2 ODBC driver | ODBC driver for the Db2 server. |
| database server A | ODBC driver A connects directly to the local database database server A. |
| Gateway B | Gateway that allows ODBC driver B connect to database server B. A gateway is a piece of software that translates the interface of a database server to the interface of another database server. |
| CAE | The Db2 ODBC driver connects to the Db2 server through CAE (Client Application Enabler). |
| database server B | Is accessed through gateway B. |
| Server for Db2 | Is accessed through CAE. |
| DB2 Connect | Allows the server for Db2 from the ODBC driver manager environment to connect to Db2 for z/OS. |
The following table presents the components
of the Db2 for z/OS application
environment and describes the relationship of those components.
| Component | Relationship |
|---|---|
| Application | Sends output to and receives input from the Db2 for z/OS ODBC driver. |
| Db2 for z/OS ODBC driver | Sends output to and receives input from the ODBC application. Communicates with the Db2 for z/OS subsystem. |
| Db2 for z/OS subsystem | Processes statements issued by the ODBC driver and sends back results. Connects to remote database servers inside or outside the Db2 for z/OS application environment |
| Db2 for z/OS, SQL/DS, Db2 for iSeries, or other DRDA database servers | The local Db2 for z/OS subsystem accesses data that the application requests from other data sources. |
| DB2 Connect | Allows clients from the ODBC driver manager environment to connect to Db2 for z/OS servers. |
End detailed description.