Configuring DB2 to Accept DRDA Requests

To use XDB Link to access DB2 data on an OS/390 system, have a database administrator (DBA) or the DB2 system administrator configure DB2 to accept DRDA requests as described in the following steps.

To configure DB2 to accept DRDA requests from XDB Link

  1. Complete the DB2 worksheet and ensure that the Distributed Data Facility (DDF) is activated.
  2. Execute one of the following statements to add a record to the DB2 SYSIBM.LUNAMES table (for DB2 Version 5 and later) or to SYSIBM.SYSLUNAMES (for DB2 Version 4 and earlier). These statements enable any remote location (including XDB Link) to access DB2 if a valid user ID and password are supplied.

    For DB2 Version 4 and earlier, execute the following statement:

    INSERT INTO sysibm.syslunames (luname, sysmodename, usersecurity,encryptpswds, modeselect, usernames) VALUES (' ', ' ', 'C', 'N', 'N', ' ');

    For DB2 Version 5 and later, execute the following statement:

    INSERT INTO sysibm.lunames (luname, sysmodename, security_in, security_out, encryptpswds, modeselect, usernames) VALUES (' ', ' ', 'A', 'A', 'N', 'N', ' ');
  3. Execute the following statement to add a record to the DB2 SYSIBM.LOCATIONS table (for DB2 Version 5 and later) or to SYSIBM.SYSLOCATIONS (for DB2 Version 4 and earlier). This statement specifies the local location name for DB2:

    For DB2 Version 4 and earlier, execute the following statement:

    INSERT INTO sysibm.syslocations (location, loctype, linkname, linkattr) VALUES ('your-location-id', ' ', ' ', ' ');

    For DB2 Version 5 and later, execute the following statement:

    INSERT INTO sysibm.locations (location, loctype,   linkname, linkattr) VALUES ('your-location-id', ' ', ' ', ' ');
  4. Cycle DDF to put the updated tables into effect.
Note:

Do not discard the DB2 worksheet when you are finished configuring DB2. It contains information that you will use to configure other parts of XDB Link.