Configuring the adapter in an AIX/DB2 environment

To configure the adapter on an AIX system, follow these instructions in order:

As DB2 user

  1. Log in to the AIX system with the DB2 user ID used for the instance for Portal Infranet, for example, db2instl.
  2. Enter the following command:
    db2 catalog tcpip node local_DB2_hostname remote remote_DB2_hostname 
     server DB2_instance_portnumber
     
    

    Example:

    db2 catalog tcpip node db2host remote db2host server 50000

  3. Enter the following command:
    db2 catalog database DB_name as DB_name at node DB2_hostname
     
    

    Example:

    db2 catalog database CWPortal as CWPortal at node db2hos

  4. Log off.

As user "pin"

  1. Log in to the AIX system as pin (create a pin user account if necessary).
  2. Copy the file db2profile into user pin's home directory, and add the line ../db2profile to the .profile file to execute the shell script file db2profile before starting the connector.

    The file is located in the directory sqllib, in the home directory of the account that was used to install Portal Infranet for DB2, for example, /home/db2instl/sqllib.

    Copy the file database.bnd from $COSSWORKDS/connectors/Portal/dependencies/config_files/DB2 to user pin's home directory.

  3. Enter the following command:
    db2 connect to DB_name user pin using pin
     
    

    Example:

    db2 connect to CWPortal user pin using pin

  4. Enter the following command:

    dbw bind database.bnd

  5. Enter the following command:

    db2 disconnect all

  6. Add the following line to the .profile file of user pin:
    export DB2DBDFT=DB_name
     
    

    Example:

    export DB2DBDFT=CWPortal

  7. Log off pin.

As user "cwadmin"

  1. Log in to the AIX system as user cwadmin, which is used to start up the connector.
  2. Execute the shell script file db2profile before starting the connector.

    The file is located in the directory sqllib, in the home directory of the account that was used to install Portal Infranet for DB2, for example, /home/db2instl/sqllib.

    Copy the file connector_manager_Portal from $ProductDir/connectors/Portal to $ProductDir/connectors/bin.

  3. Change the directory to $ProductDir/connectors/Portal. In the file start_Portal.sh, change the following line:

    PORTAL_HOME=/opt/portal/6.1

    to an appropriate value:

    PORTAL_HOME=PortalInfranet_home_dir

    Example:

    /opt/portal/6.2

  4. Log off cwadmin.

As user "pin"

  1. Log in to the AIX system as pin.
  2. Copy the Infranet files pcm.jar and pcmext.jar into $ProductDir/connectors/Portal/dependencies. These files are located in the $INFRANET/jars directory of the Infranet server.
  3. Copy the file custom_opcode.h to $INFRANET/include.
  4. Copy the files custom_opcode_mem_map to $INFRANET/lib.
  5. Copy the .profile file into pin's home directory, for example, /home/pin. If necessary, modify the .profile file to reflect the environment variables set in your system. Make any changes using a text editor such as vi. When the environment variables are correct, load them into the system by typing the following command at the command prompt:

    ../.profile

  6. Copy the file fm_crossworlds.so to the $INFRANET/lib directory. This file contains the triggers for the events.
    Note:
    AIX is case-sensitive, so if the files are not found, verify that all directory and file names have the proper case.

    Make sure that the $LIBRARY_PATH variable contains the $INFRANET/lib path so that the system can recognize the .so files.

  7. Make sure that the $LIBRARY_PATH variable contains the $INFRANET/lib path so that the system can recognize the .so files.
  8. Copy the following files into the directory $CW_PORTAL_PATH, for example, /opt/portal/6.2/sys/cm:
  9. Place the pin_notify_cw file in the $INFRANET/sys/test directory. This file contains the names of the connector events. If any events need to be added or deleted, follow the standard format of the file. Note that /event encapsulates all subclasses, such as /event/customer and /event/status.

Copyright IBM Corp. 1997, 2003