DB2 Data Links Manager Quick Beginnings

Installing DB2 Data Links Manager on AIX Using the db2setup Utility

The db2setup utility is the recommended method for installing all DB2 products on UNIX-based operating systems. This utility can perform all of the tasks required to install DB2 Data Links Manager. If you prefer not to use the db2setup utility, see Manually installing DB2 Data Links Manager Using SMIT.

To install and configure DB2 Data Links Manager using the db2setup utility:

1. Log in as a user with root authority. In DCE-DFS environments, you will also need to dce_login as DLMADMIN.
2. Insert and mount your product CD-ROM.
3. Change to the directory where the CD-ROM is mounted by entering the cd /cdrom command where cdrom is the mount point of your product CD-ROM.
4. Enter the ./db2setup command. After a few moments the DB2 Setup Utility window opens. Follow the on-screen instructions to begin the installation process.

   The db2setup utility automatically generates an installation log in /tmp/db2setup.log. If you want to generate a trace file to record any installation errors in greater detail, enter the ./db2setup -d command. This generates a trace file in /tmp/db2setup.trc.

5. Press Tab to move between available options and fields. Press Enter to select or deselect an option. Selected options are denoted by an asterisk.

   When you select to install a DB2 product, you can choose the product's Customize option to view and change the optional components that will be installed.

   If you are installing in a DCE-DFS environment, one node in the cell will contain the DLFM_DB and must be set up as the DB2 server. All other nodes on which Data Links Manager is installed must be set up as DB2 clients for the DLFM_DB.

Actions Performed by the db2setup Utility

After installation is complete and before you exit the db2setup utility, you can select View Log to review the installation process. You can also review the /tmp/db2setup.log file for more detailed information. If you ran the ./db2setup -d command to capture any installation errors, you can review the trace log in /tmp/db2setup.trc.

The following actions are performed by the db2setup utility:

Installation directory

DB2 Data Links Manager and DB2 Universal Database are installed in the /usr/lpp/db2_07_01 directory. DB2 Data Links Manager uses DB2 UDB to maintain logged information for the linked files.

Group and user IDs

A group ID (gid) and user ID (uid) are created for the DB2 Data Links Manager Administrator (DLMADMIN), if you selected to do so during installation. In the DCE-DFS environment, ensure that the uid, user name, gid, and group name match the DCE identity which was created for DLMADMIN.

Instance creation

An instance for the Data Link File Manager is created. The default instance, associated with the default group and user ID, is called DLFM.

Registry variables

The following registry variables are set:

   DLFM_PORT=port_number
   DLFM_LOG_LEVEL=LOG_ERR
   DB2_RR_TO_RS=ON
   DB2_HASH_JOIN=ON
   DLFM_INSTALL_PATH=$HOME/sqllib/bin
   DLFM_INSTANCE_NAME=instance_name
   DB2INSTANCE=DLFM_INSTANCE_NAME
   DLFM_BACKUP_DIR_NAME=$HOME/dlfmbackup   //JFS only
   DLFM_BACKUP_DIR_NAME=/:/dlfmbackup      //DCE-DFS only
   DLFM_BACKUP_TARGET=LOCAL
   DLFM_FS_ENVIRONMENT=file_system

where:

• port_number is the port number reserved for the Data Links File Manager.
• instance_name is the name of the Data Links File Manager instance.
• file_system is NATIVE in JFS environments or DFS in DCE-DFS environments. The default setting is NATIVE.

PATH variables

The following variables are set in the DB2 Data Links Manager Administrator's db2profile or db2cshrc script file:

   (for bash, Bourne, or Korn shell)
   export PATH=$PATH:$HOME/sqllib/bin:$HOME/sqllib/adm:$HOME/sqllib/misc
   (for C shell)
   setenv PATH=${PATH}:${HOME}/sqllib/bin:${HOME}/sqllib/adm:${HOME}/sqllib/misc
 

To run the DB2 Data Links Manager Administrator's db2profile or db2cshrc script file each time this user logs on to the system, add the following entry to the DB2 Data Links Manager Administrator's .profile script file:

   . INSTHOME/sqllib/db2profile (for bash, Bourne, or Korn shell)
   source INSTHOME/sqllib db2cshrc (for C shell)

where INSTHOME is the home directory of the DB2 Data Links Manager Administrator.

Virtual File System number

In JFS environments, the following entry is added to the /etc/vfs file:

   dlfs  12  /usr/lpp/db2_07_01/bin/dlfs_mnthlp /usr/lpp/db2_07_01/bin/dlfs_fshelper

If the vfs number 12 is already in use, the db2setup utility will specify a different number between 8-15 for use by the Virtual File System (VFS).

DB2 database DLFM_DB created

In DCE-DFS environments, a single DLFM_DB database is created on the DLFM server node. On the DLFM client nodes, a remote database catalog entry to the DLFM_DB is created.

In JFS environments, a DLFM_DB database is created on the node containing DB2 DataLinks Manager.

DCE-DFS pre-start registration for DMAPP

In a DCE-DFS environment, a data manager application (DMAPP) is installed. This DMAPP prevents file renaming and deletion. DB2 Data Links Manager can only start if the DMAPP is up and running, and the DMAPP has to be started as part of DFS start-up. This is accomplished by installing a DFS pre-start script. The db2setup utility does this for you by performing the following actions:

1. The db2setup utility checks if /opt/dcelocal/tcl/user_cmd.tcl exists. If it does not exist, the db2setup utility creates it.
2. The following line is added to /opt/dcelocal/tcl/user_cmd.tcl:

      set pre_start_dfs "/usr/bin/dlfsdmap_prestart.dfs"
   

3. A link is created from $HOME/sqllib/adm/dlfsdmap_prestart.dfs to /usr/bin/dlfsdmap_prestart.dfs.