Configuring access to RDBMS

You can access data on DB2 for z/OS and distributed databases IBM Big SQL, IBM dashDB, DB2 LUW (Linux, UNIX, and Windows), Microsoft SQL Server, Oracle, and QMF DRDA.

Before you begin

The server and relational database management system (RDBMS) must already be installed.

About this task

The SQL interface for DB2 provides seamless, real-time controlled access to RDBMS data. It allows ODBC, JDBC, and web clients to access RDBMS data in a relational model by using simple SQL-based queries. This interface can be used with traditional client/server applications, desktop productivity tools that use ODBC, JDBC, and two-tier and three-tier web implementations. Using the interface, applications can use standard ODBC or JDBC facilities to make SQL requests directly to RDBMS. The result is a relational result set, with no host programming required.

To configure and verify access to data in a RDBMS, perform the following tasks.

Procedure

  1. Enable the RDBMS access method in the Data Virtualization Manager configuration member.
    See Modifying the DRDA configuration member.
  2. Configure access to the database.
    • IBM DB2 for z/OS

      Configure DB2 to use either the Distributed Relational Database Architecture (DRDA) access method or the Resource Recovery Services attachment facility (RRSAF) access method.

      See Configuring access to IBM Db2 for z/OS.

    • Distributed databases, including Big SQL, dashDB, DB2 LUW, Microsoft SQL Server, Oracle, and QMF DRDA.

      Configure the RDBMS to use the Distributed Relational Database Architecture (DRDA) access method.

      See Configuring access to distributed databases.