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):
- Download the following from Passport Advantage
- 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) - 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
- 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)
- 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 -
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. - 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. - Verify the installation by using:
AIX, Linux: /usr/local/bin/db2ls
Windows: From a command window: reg query hklm\software\ibm\db2\currentversion - 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. - 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" - Install the recommended fix levels of latest GSKIT by referring to SDS 6.4 recommended fixes table.
- Install or Update Security Directory Server V6.4.0.25:
- 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*
- Extract the 6.4.0.25 (or later fix pack) with the command (adjust the file name for later fix packs):
- 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
- Extract the 6.4.0.25 (or later fix pack) with the command (adjust the file name for later fix packs):
- 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
- Extract the 6.4.0.25 (or later fix pack) with the command (adjust the file name for later fix packs):
- 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.
- AIX:
- Verify the contents of SDS global ldapdb.properties file in <sds64_install_location>/etc/ folder:
- 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
- Verify the ldapdb.properties file contents:
- 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
- Verify the ldapdb.properties file contents:
- 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
- Using a command window
- AIX:
- 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:
- Upgrade an instance of a previous version (V6.3 / V6.3.1) to SDS 6.4 instance:
- Remote system migration
- Same system migration from V6.3 / V6.3.1 (with DB2 9.7) requires
a. Upgrading to SDS 6.4 using DB2 10.5:
- Follow SDS 6.4 Documentation to install SDS 6.4 base level along with DB2 10.5
- Install latest recommended fixes for SDS 6.4, DB2 10.5, GSKit, and Java SDK
(important step as there are migration-related fixes are not available in base levels)
- Only after these steps, use idsimigr tool to upgrade V6.3 / V6.3.1 instance to SDS 6.4 along with DB2 10.5
b. Then, update DB2 10.5 to DB2 11.5 (Read the next step for details)
- 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"}]
Was this topic helpful?
Document Information
Modified date:
11 August 2022
UID
ibm16551818