IBM DB2 (4.2)

This section contains information that is specific to the database type IBM DB2.

Supported Functions

The IBM DB2 database can be used with:

  • Database Table Related Functions (APL)
  • Database Collection/Forwarding Agents
  • Prepared Statements (APL)
  • SQL Collection/Forwarding Agents

Preparations

A database driver is required to connect to the IBM DB2 database. This driver must be stored in the Platform. Follow these steps to set up the IBM DB2 driver on the Platform:

  1. Set up a persistent file system.

  2. A driver, provided by your IBM contact, is required to access the IBM DB2 database. This driver must be stored on a host (Platform) that will connect to an IBM DB2 database.

  3. Copy the IBM DB2 files into the directory MZ_HOME/persistent/3pp on the platform-0 pod.

    Example - Copy the IBM DB2 files into the directory

    $ kubectl cp jcc.jar platform-0:/opt/mz/persistent/3pp -n <namespace>
  4. Restart the platform and EC pods.

    Example - Restart the platform and EC pods

    $ kubectl delete pod platform-0 -n <namespace>
  5. Restart the Desktop.