Activating the Db2 Connect Unlimited license on a Db2 for z/OS subsystem

These instructions describe how to activate a Db2 Connect Unlimited edition on a Db2 for z/OS subsystem for enabling JDBC connectivity between Data Gate and the Db2 for z/OS source subsystem.

Before you begin

The Db2 Connect license activation is a one-time setup that needs to be performed once for each Db2 for z/OS subsystem prior to connecting it to Data Gate instance(s) later on. For executing the license activation commands, you need to prepare a separate machine, satisfying the following requirements:
  • Running the Linux or Windows operating system
  • Having network connectivity to the Db2 for z/OS subsystems that need license activation
  • Having a recent Java version installed

About this task

Important: This task must be completed before you:
  • Create a Data Gate service instance and connect it to a Db2 for z/OS subsystem.
  • Upgrade an existing Data Gate service instance from 5.1.x.
A Data Gate instance needs to connect to the Db2 for z/OS subsystem that acts as data source for:

For these use cases, Data Gate needs to open JDBC connections that require a valid Db2 Connect Unlimited license activation on the Db2 for z/OS server. Db2 Connect is a product that needs to be purchased separately (see Data Gate system requirements). For activating the license on the Db2 for z/OS server, the Db2 Connect license activation kit is required.

Additional information about Db2 Connect licensing can be found here.

Data Gate supports the following Db2 Connect versions:

Product Name Version eAssembly License Activation Kit Part Number
IBM DB2 Connect Unlimited Edition for System z 12.1 G0CWXEN M0MR7EN

Procedure

  1. On this machine, perform these steps:
    1. Download the Db2 Connect license activation kit from the Passport Advantage website. Detailed instructions can be found in the Db2 Connect documentation. Refer to the table above for the list of supported versions.
    2. Extract the db2connectactivate utility and locate the db2connectactivate.jar java executable and the db2connectactivate.sh / db2connectactivate.bat wrapper scripts for invoking the license activation program.
    3. If you plan to connect to the Db2 for z/OS subsystem via secure port, enable SSL connectivity for db2connectactivate by following the instructions in this support article.
  2. On the machine that was prepared according to the “Before you begin” section above, execute the following steps for each Db2 for z/OS subsystem that you plan to connect to Data Gate (see db2connectactivate reference documentation.
    1. Check if a Db2 Connect license is already installed on the subsystem by executing the db2connectactivate utility using the -checkexisting option as parameter. Example command with placeholder values to be replaced: 
      db2connectactivate.sh -host <DB2_Z_HOST> -port <DB2_Z_PORT> -database <DB2_Z_DB> -user <DB2_Z_USER> -password <DB2_Z_PASSWORD> -checkexisting
    2. If no active license was found, an output similar to this will be returned: 
      [license activator][7021][13452]The DB2 Connect license was not found on the target server.
    3. If a valid license was found, the output will include a version number of the installed license (12.1 in this example): 
      [license activator][7020][13452]The version of the installed DB2 Connect license on the server is :1201
    4. If the license check does not detect a valid license or the returned license version is less than one of the supported versions (table above), activate the license by performing the following steps.
    5. Execute the db2connectactivate without the -checkexisting option. Example command with placeholder values to be replaced: 
      db2connectactivate.sh -host <DB2_Z_HOST> -port <DB2_Z_PORT> -database <DB2_Z_DB> -user <DB2_Z_USER> -password <DB2_Z_PASSWORD>
      On success, the utility will return an output similar to this:
      [license activator][7010][13433]Activation completed successfully.
    6. Verify the installed license version by executing the license check from step 2.a.