Connecting to DB2

This section describes the clients used by DataMagic to connect to DB2, and how to install these clients.

For details about each client, see the IBM web site.

For details about the DB2 client versions supported by DataMagic and the database versions to which DataMagic can connect, access the following URL and check the website:

URL: https://www.hulft.com/en/

 

This section describes how to install a DB2 client, using DB2 Application Development Client as an example. For details about how to install other clients, see the IBM website and corresponding IBM manuals.

 

(1) Installation procedure

This section describes how to install a client, using AIX as an example. Set up the client as follows:

Preparation for installation

  • Obtain DB2 Application Development Client.

    For details about how to obtain DB2 Application Development Client, see the IBM web site.

1. Log in

Log in as a root user.

2. Prepare the work directory to be used during installation.

# pwd
/tmp
# mkdir insttmp
# ls
insttmp

3. Extract the DB2 client module.

# tar xvf client module.tar

4. Prepare the environment in which the graphical user interface (GUI) can be used to perform the installation.

Specify the environment variable used to display the graphical user interface. If you are logged in to X Window System as an install user, this task is not necessary.

When using sh:

# DISPLAY=xxx:0
# export DISPLAY

When using csh:

# setenv DISPLAY xxx:0

5. Extract the client module, and then move to the adcl.dbcs directory that was created.

# cd adcl.dbcs/

6. Start ./db2setup.

The installation dialog box is displayed in the screen where you specified the DISPLAY environment variable.

# ./db2setup

DBI1190I db2setup is preparing the DB2 setup wizard. This wizard describes how to set up the program.

7. Follow the instructions of the Installation Wizard to install the program.

Installation Type

: Standard

Instance creation

: Number of bits supported by the DataMagic for UNIX/Linux version to be used

Instance owner

: User that uses DataMagic for UNIX/Linux to perform processing

(2) Setting up the environment

Specify the environment variable for using the client.

The environment variable must be specified by the user who runs DataMagic.

When using sh:

# . [DB2-client-installation-directory]/sqllib/db2profile

When using csh:

# source [DB2-client-installation-directory]/sqllib/db2cshrc