Using Windows and UNIX APIs › Windows Encyclopedia API › Considerations for Remote Database Access › Remote DB2 Access

Remote DB2 Access

To access the Host Encyclopedia from a Windows workstation, install and configure DB2 Connect according to IBM's Universal Database documentation. DB2 Connect must be installed on:

• The client workstation
• z/OS as the server system

The z/OS DB2 database administrator must authorize a DB2 collection for binding API DBRM packages to the Host Encyclopedia tables.

Note: Verify the DB2 remote access is established using the DB2 Command Center before using the CA Gen APIs. This query lists the models in the Host Encyclopedia:

connect to <DB2 database subsystem> user <TSO user ID>
select model_name from <encyclopedia table owner ID>.dmdl
terminate

1. Open a DB Command window and enter the following commands in the DB2 CLP window:

   >cd %iefcsgen%\..\cse_mvsdb2
   >db2 connect to <DB2 subsystem ID> user <your TSO user ID>
   >db2 bind @mvsbind.lst blocking all sqlerror continue messages bind.msg owner <owner> qualifier <qualifier> collection <collection>
   >db2 connect reset
   

2. Close the DB2 CLP window when the work is done.

You will be prompted for your TSO password when the db2 connect command is entered. The entry field is non-display, so your password security is preserved. Enter your password and click the Return key to continue. The values in the angle brackets, < >, are replaced with owner, qualifier, and collection values that were established when the Host Encyclopedia was installed. You can get these values from your Host Encyclopedia Administrator or DB2 Administrator.