Defining the DB2 access service as a remote server

1. Enter each DB2 access service name in the ASE SYSSERVERS table:

   sp_addserver service_name
   

   where service_name is the name of the DB2 access service you want to set up as a remote server.

   The name is case sensitive and must match the name you used to define the connectivity between ASE and the DB2 access service.

2. Verify that the DB2 access service is successfully defined as a remote server:

   select service_name from sysservers
   

   If data rows return, you successfully defined the DB2 access service as a remote server.

When ASE issues an RPC to a DB2 access service, it attempts to connect using a service name identical to the ASE identifier in the interfaces file.

To support ASE RPC events, perform one of these procedures:

• Define a service within the DB2 access service library using the same name as ASE, or

• Set up service name redirection to redirect the ASE to the appropriate service.