Setting general connection properties

This section describes how to configure general connection properties. For an explanation of how to configure advanced connection properties, see Setting advanced connection properties.

To add an IBM DB2 for z/OS target endpoint to Qlik Replicate:

1. In Tasks view, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog. Then click the New Endpoint Connection button.
2. In the Name field, specify a display name for your IBM DB2 for z/OS endpoint. This can be any name that will help to identify the endpoint being used.
3. Optionally, in the Description field, enter a description.
4. Select Target as the endpoint Role.
5. Select IBM DB2 for z/OS as the endpoint Type.

6. Configure the following properties:

   • Server (system): The host name or IP address of the DB2 database server.

     Information noteIf the Server is a parallel SysPlex and data sharing members reside on multiple LPARs, the host address may specify a DVIPA - a Dynamic Virtual IP Address (to utilize the system redundancy and load-balancing in Replicate processing). In this case, the port numbers must be identical for all members.
   • Port: The port through which to access the database. The default is 50,000.
   • Location: The Location should be the DB2 location name defined during the installation. This should be a relational database management system under z/OS, which can be either a subsystem or a group connection. This is the logical name which serves applications in order to designate resources managed by this system, either using the SQL CONNECT instruction, or placing it as a qualifier of a table (preceding the schema name). To see the location name, use the “-DIS DDF” DB2 command (option 7 under the DB2I panel in ISPF), or look in message DSNL004I in the job log of the <ssid>MSTR address space.
   • User Name: The User name of an authorized user of the specified IBM DB2 for z/OS database. For a list of the permissions that need to be granted to this user, see Permissions.
   • Password: The Password for the specified user.
   • Use SSL: Expand the Security section to view or set SSL options. Select Use SSL to connect to the DB2 database server using SSL.
     • Hostname validation: Select to validate the host name against the host name in the server certificate.
     • CA path: Provide the full path to the CA file in PEM format.

7. Click Test Connection to make sure that Replicate is able to establish a connection to the specified location and then (if the connection is successful), either click Save or modify the settings in the Advanced tab.