Using DRDA to connect to database repositories and data sources

You can use the Direct DRDA Connection to establish a connection to Db2® database 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.

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. In the Repositories view, on the Data Sources tab, right-click the data source that you want to work with and select Properties.
  2. From the JDBC Driver list of the Connection Parameters page, select Direct DRDA Connection. The connection will be used to access the database that hosts the data source.
  3. In the JDBC URL list specify the URL that points to the database that hosts the data source.
    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 resulting URL string is added to the JDBC URL list.
  4. Click Advanced to specify Direct DRDA Connection string properties and their values to be used for the database that hosts the data source tables.

    See Direct DRDA Connection properties for more information.

  5. 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.
  6. Continue specifying the data source parameters.