IBM Support

IBM Security Directory Server V6.4 Support for DB2 V11.5

How To


Summary

How to install DB2 V11.5 (latest recommended fix pack) to use with IBM Security Directory Server V6.4.

Objective

This document describes installation procedures for DB2 11.5 (with latest recommended fix pack) to use with IBM Security Directory Server V6.4.

Environment

IBM Security Directory Server 6.4.0.25
DB2 11.5.7

Steps

IBM Security Directory Server V6.4.0.25 (and later fix packs) supports DB2 Server 11.5.7 (or later fix packs).
  • Security Directory Server (SDS) V6.4.0.0 base images do not include DB2 11.5 inside the ISO image.
  • SDS V6.4 eAssemblies on Passport Advantage are updated to include the following DB2 11.5 activation parts:
    • IBM® Db2® Standard Edition Activation - Restricted Use: G01LWML - DB2_SE_Restricted_Activation_11.5.zip
    • IBM® Db2® OEM High Capacity Activation - Restricted Use: CC9WGML - DB2_OHC_Restricted_Act_11.5.zip.
  • DB2 11.5.7 (or later fix packs) must be downloaded from Fix Central to install DB2 11.5 Server Edition.
Here is the procedure for installing DB2 11.5.7 (or later fix pack) to use with IBM Security Directory Server V6.4.0.25 (or later fix pack):
  1. Download the following from Passport Advantage
    1. SDS 6.4 (SDS 6.4 base level ISO images: (Note: If you have a working SDS 6.4 instance with DB2 10.5, then skip this step)
      Refer to the platform-specific tables for the Passport Advantage part numbers of SDS 6.4: AIX, Linux, and Windows.
      Also, download "      CN4VJML - IBM Security Directory Server, Version 6.4 Premium Feature Activation Package for all operating systems" (sds64-premium-feature-act-pkg.zip)
    2. Download necessary DB2 11.5 Activation Parts for SDS:
      For license activation, download the following activation parts from Passport Advantage:
      IBM® Db2® Standard Edition Activation - Restricted Use: G01LWML -       DB2_SE_Restricted_Activation_11.5.zip
      IBM® Db2® OEM High Capacity Activation - Restricted Use: CC9WGML - DB2_OHC_Restricted_Act_11.5.zip
  2. Download the required DB2 Universal or Server Fix Pack for DB2 11.5.7 or later by referring to the location:  Download DB2 Fix Packs by version.
    At the time of writing this document, the DB2 11.5.7 special build provided by this DB2 Security Bulletin was used: https://www.ibm.com/support/pages/node/6528672.
    Examples of the file names used: 
    AIX: special_13495_v11.5.7_aix64_universal_fixpack.tar.gz
    Linux x86_64: special_13495_v11.5.7_linuxx64_universal_fixpack.tar.gz
    Linux s390x (on z Systems): special_13495_v11.5.7_linux390x64_universal_fixpack.tar.gz
    Windows x64: special_13495_v11.5.7_ntx64_universal_fixpack.exe
  4. Transfer all the files to your target system that is going to function as SDS/DB2 system. After transfer unpack the files:
    AIX: gunzip -c special_13495_v11.5.7_aix64_universal_fixpack.tar.gz | tar -xf -
    Linux x86_64: tar -zxf special_13495_v11.5.7_linuxx64_universal_fixpack.tar.gz
    Linux s390x: tar -zxf special_13495_v11.5.7_linux390x64_universal_fixpack.tar.gz
    Windows x64: Double-click special_13495_v11.5.7_ntx64_universal_fixpack.exe from Windows File Explorer and extract to a folder such as C:\Temp\DB2v11.5.7.special.
    Contents of compressed file are extracted to a folder called "universal" that contains all the required files to proceed with DB2 installation.
  5. Install DB2 on a SDS/DB2 system referring to https://www.ibm.com/docs/en/db2/11.5?topic=servers-db2-installation-methods:
    Here are some typical examples to install DB2
    cd <path>/universal
    AIX: ./db2_install -y -f NOPCMK -f NOTSAMP -p SERVER -b /opt/IBM/db2/V11.5
    Linux: ./db2_install -y -f NOPCMK -f NOTSAMP -p SERVER -b /opt/ibm/db2/V11.5
    Windows: Launch "setup" from "universal" folder as Administrator. Select "Install a Product". Under the DB2 Version 11.5.7.0 Server Editions section, click "Install New" button. Accept the license terms, use typical installation type to install DB2 Server Edition. Fill the required installation folder and complete the installation.
  6. Verify the installation by using:
    AIX, Linux: /usr/local/bin/db2ls
    Windows: From a command window: reg query hklm\software\ibm\db2\currentversion
  7. Now extract the DB2 11.5 activation parts:
    AIX and Linux:
    unzip DB2_SE_Restricted_Activation_11.5.zip
    unzip DB2_OHC_Restricted_Act_11.5.zip
    Windows: Right-click each .zip file and select "Extract All" option 
    All contents are extracted to the folders std_o and hc.
  8. Apply the DB2 11.5 Standard and High Capacity licenses:
    AIX: 
    /opt/IBM/db2/V11.5/adm/db2licm -a <path>/std_o/db2/license/db2std_o.lic
    /opt/IBM/db2/V11.5/adm/db2licm -a <path>/hc/db2/license/db2hc.lic
    /opt/IBM/db2/V11.5/adm/db2licm -l
    Linux:
    /opt/ibm/db2/V11.5/adm/db2licm -a <path>/std_o/db2/license/db2std_o.lic
    /opt/ibm/db2/V11.5/adm/db2licm -a <path>/hc/db2/license/db2hc.lic
    /opt/ibm/db2/V11.5/adm/db2licm -l
    Windows: From Start menu - Open the "DB2 Command Window - Administrator" for the DB2 11.5.7 installation copy.
    db2licm -a <path>\std_o\db2\license\db2std_o.lic
    db2licm -a <path>\hc\db2\license\db2hc.lic
    db2licm -l

    Also, remove the unwanted trial license of db2aese or db2dec
    db2licm -r db2aese
    db2licm -r db2dec

    Final license when viewed by using db2licm -l:
    Product name:                     "DB2 Standard Edition"
    License type:                     "Restricted"
    Expiry date:                      "Permanent"
    Product identifier:               "db2std"
    Version information:              "11.5"
    Features:
    IBM DB2 Performance Management Offering:              "Not licensed"
    IBM DB2 OEM High Capacity Feature:                    "Licensed"
  9. Install the recommended fix levels of latest GSKIT by referring to SDS 6.4 recommended fixes table.
  10. Install or Update Security Directory Server V6.4.0.25:
    1. AIX:
      • Extract the 6.4.0.25 (or later fix pack) with the command (adjust the file name for later fix packs):
        gunzip -c 6.4.0.25-ISS-ISDS-AIX-IF0025.tar.gz | tar -xf -
      • For systems with existing installations of SDS 6.4.0.x (where x is less than or equal to 24) update to SDS 6.4.0.25:
        cd <path>/6.4.0.25-ISS-ISDS-AIX-IF0025
        ./idsinstall -u -f    # Review and accept license terms then all the packages are updated.
      • For systems with new SDS installation, SDS license review and acceptance and Install SDS 6.4.0.25:
        cd <path>/6.4.0.25-ISS-ISDS-AIX-IF0025/license
        ./idsLicense              # Review and accept the license terms.
        cd ../images
        installp -acXgYd . idsldap.license* idsldap.clt* idsldap.msg64.en_US idsldap.srv* idsldap.web*
        # optionally you can install more language packs by including idsldap.msg64.<lang> in the same command.
      • Verify by using:
        lslpp -L idsldap*
         
    2. Linux x86_64:
      • Extract the 6.4.0.25 (or later fix pack) with the command (adjust the file name for later fix packs):
        tar -zxf 6.4.0.25-ISS-ISDS-LinuxX64-IF0025.tar.gz
      • For systems with existing installations of SDS 6.4.0.x (where x is less than or equal to 24) update to SDS 6.4.0.25:
        cd <path>/6.4.0.25-ISS-ISDS-LinuxX64-IF0025
        ./idsinstall -u -f    # Review and accept license terms then all the packages are updated.
      • For systems with new SDS installation, SDS license review and acceptance and Install SDS 6.4.0.25:
        cd <path>/6.4.0.25-ISS-ISDS-LinuxX64-IF0025/license
        ./idsLicense              # Review and accept the license terms.
        cd ../images
        rpm -ihv idsldap-license* idsldap-clt* idsldap-msg64-en* idsldap-srv* idsldap-web*
        # optionally you can install more language packs by including idsldap-msg64-<lang>* in the same command.
      • Verify by using:
        rpm -qa | grep -i idsldap
         
    3. Linux s390x:
      • Extract the 6.4.0.25 (or later fix pack) with the command (adjust the file name for later fix packs):
        tar -zxf 6.4.0.25-ISS-ISDS-Linuxz-IF0025.tar.gz
      • For systems with existing installations of SDS 6.4.0.x (where x is less than or equal to 24) update to SDS 6.4.0.25:
        cd <path>/6.4.0.25-ISS-ISDS-Linuxz-IF0025
        ./idsinstall -u -f    # Review and accept license terms then all the packages are updated.
      • For systems with new SDS installation, SDS license review and acceptance and Install SDS 6.4.0.25:
        cd <path>/6.4.0.25-ISS-ISDS-Linuxz-IF0025/license
        ./idsLicense              # Review and accept the license terms.
        cd ../images
        rpm -ihv idsldap-license* idsldap-clt* idsldap-msg64-en* idsldap-srv* idsldap-web*
        # optionally you can install more language packs by including idsldap-msg64-<lang>* in the same command.
      • Verify by using:
        rpm -qa | grep -i idsldap
         
    4. Windows:
      • For the first-time installation on Windows, it is required to install the DB2 10.5 provided by the SDS 6.4.0.0 iso just for the SDS 6.4 installation to complete successfully. Refer to this document on how to install SDS 6.4.0.0 on Windows: https://www.ibm.com/docs/en/sdse/6.4.0?topic=installation-starting-launchpad
      • Right-click 6.4.0.25-ISS-ISDS-WinX64-IF0025.zip file from Windows File Explorer and choose "Extract all".
      • Refer to this document on how to update to SDS 6.4.0.25 (or later fix pack) on Windows: https://www.ibm.com/docs/en/sdse/6.4.0?topic=strategy-installing-fix-packs-installation-manager
      • On Windows, double check fix levels of GSKIT by using command prompt:
        reg query hklm\software\ibm\gsk8\currentversion
        Verify that CryptVersion and Version are showing required GSKit fix level.
        If required, reinstall GSKit 8 by referring to SDS 6.4 recommended fixes table.
         
  11. Verify the contents of SDS global ldapdb.properties file in <sds64_install_location>/etc/ folder:
    1. AIX:
      • Verify the ldapdb.properties file contents:
        cat /opt/IBM/ldap/V6.4/etc/ldapdb.properties
      • Expected output:
        currentDB2InstallPath=/opt/IBM/db2/V11.5
        currentDB2Version=11.5.7.0
    2. Linux:
      • Verify the ldapdb.properties file contents:
        cat /opt/ibm/ldap/V6.4/etc/ldapdb.properties
      • Expected output:
        currentDB2InstallPath=/opt/ibm/db2/V11.5
        currentDB2Version=11.5.7.0
    3. Windows:
      • Using a command window
        cd <sds64_install_location>\etc
        For example,         cd C:\Program Files\IBM\ldap\V6.4\etc
        type ldapdb.properties
      • Find the current DB2 11.5.7 installation path and version information by opening a "DB2 command window as Administrator".
        If you have multiple copies of DB2, use the correct DB2 11.5 installation copy from start menu to open "DB2 command window as Administrator". Run the command:
        db2level
      • Update contents of ldapdb.properties file by using a notepad as shown:
        currentDB2InstallPath=<supported_db2_install_location>
        currentDB2Version=<supported_db2_version_level>

        Example:
        currentDB2InstallPath=C:\Program Files\IBM\SQLLIB
        currentDB2Version=11.5.7000.2644
  12. Optionally install SDS provided "premium feature activation package" either from the SDS 6.4.0.0 iso file or from "sds64-premium-feature-act-pkg.zip" file:
    • Either mount the sds64 iso file or extract sds64-premium-feature-act-pkg.zip file.
    • AIX: 
      cd <path>/entitlement
      installp -acXFYd . idsldap.ent64
    • Linux:
      cd <path>/entitlement
      rpm -ihv --force --nodeps idsldap-ent64-6.4.0-0*rpm
    • Windows: Refer: https://www.ibm.com/docs/en/sdse/6.4.0?topic=manager-installing-premium-feature-activation-package-installation
Next Steps after successful DB2 V11.5.7 and SDS 6.4 installation:
  1. Create and configure a new SDS 6.4 instance
  2. Upgrade an instance of a previous version (V6.3 / V6.3.1) to SDS 6.4 instance:
  3. On an existing SDS 6.4 instance with DB2 10.5 or 11.1, upgrade the DB2 to 11.5 using "idsdbmigr" tool provided by SDS 6.4 (in sbin folder of SDS 6.4 installation)
    • Stop ibmslapd and ibmdiradm processes for the SDS 6.4 instance.
    • Upgrade DB2 instance associated with SDS 6.4 instance and its database to 11.5 level from 10.5 or 11.1 level:
      idsdbmigr -I <sds_instance_name> -N <db2_11.5_install_location>

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVJJU","label":"IBM Security Directory Server"},"ARM Category":[{"code":"a8m0z0000001hpzAAA","label":"Install"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"6.4"}]

Document Information

Modified date:
11 August 2022

UID

ibm16551818

Page Feedback