Using DRDA to connect to database repositories and data sources

You can use the Direct DRDA Connection to establish a connection to Db2® database repositories and data sources.

Before you begin

The Direct DRDA Connection is supported only for DB2 for z/OS® version 9 and later. Do not use it for Db2 LUW or DB2 for iSeries.

About this task

In contrast to JDBC driver libraries, the Direct DRDA Connection is included with QMF and does not require additional driver installation.

You can specify the Direct DRDA Connection when creating a relational data source, shared repository storage, or shared repository connection.

You can enable the use of SSL certificates for the Direct DRDA Connection to make the connection secure.

To specify the Direct DRDA Connection:

Procedure

  1. From the JDBC Driver drop-down list of the connection parameters section, select Direct DRDA Connection. The connection will be used to access the database that hosts the repository storage.
  2. In the JDBC URL list specify the URL that points to the database that hosts the repository storage.
    The templates for the URL can be displayed in the list:
    jdbc:rsbi:db2://{server}:{port}/{database}
    You must specify the server, port, and database information.
    Note: You can also use the Build URL by URL Template window to form the correct string. To do so, click Build URL to open the Build URL by URL Template window. From the JDBC URL drop-down list, select the template. In the table, specify the server, port, and database information and click OK. The result URL string is added to the JDBC URL list.
  3. Click Advanced to specify Direct DRDA Connection string properties and their values to be used for the database that hosts the repository storage tables.

    See Direct DRDA Connection properties for more information.

  4. To bind the direct DRDA package click Bind Packages. The Bind Packages dialog opens.

    In order for Direct DRDA Connection to properly work you must bind Direct DRDA packages when you are connecting to a database for the first time. When the binding operation completes, users can connect to the database by using Direct DRDA Connection. They do not have to bind packages again.

    1. In the Owner ID field you can enter a privileged SQLID with the necessary rights for the binding process, in case a user who establishes a server connection has no administrator privileges for the database. If the value of this field is not specified, the CURRENT SQLID, the user name set in the Set User Information dialog, will be used to perform the installation process.
    2. Click Install to start the installation process.
  5. Continue specifying the relational data source, shared repository storage, or shared repository connection parameters.