IBM Support

How to update DB2 10.5 Fix Pack or Special Build for Directory Server

How To


Summary

This document provides procedure to update to DB2 10.5 Fix Pack or Special Build for Directory Server V6.4.

Objective

DB2 10.5 provides fix packs and special builds. This document provides necessary procedure to upgrade existing DB2 10.5 to the latest fix pack or special build.

Environment

  • IBM Security Directory Server V6.4.0.<latest>

Steps

  1. Download the latest fix pack or special build for DB2 10.5.
  2. After download transfer the file to SDS system. Unpack the same on the SDS system.
  3. Stop ibmslapd, ibmdiradm for all Directory Server instances.
  4. Stop DB2 for all instances. Make sure that no DB2 processes are running any more using
    For AIX, Linux and Solaris:
    su - <instance>
    db2 force application all
    db2stop
    ipclean
    exit

    ps -aef | grep -i db2
    For Windows - from Services panel stop all DB2 services.
  5. Find the DB2 10.5 installation folder:
    For AIX, Linux and Solaris:
    /usr/local/bin/db2ls
    For Windows - from a command window.
    db2swtch -l
  6. cd into the extracted folder and installation the fix pack to update existing DB2 10.5 using:
    For AIX, Linux and Solaris:
    ./installFixPack -b <db2_10.5_install_folder>
    For example: ./installFixPack -b /opt/ibm/db2/V10.5

    For Windows:
    Double-click the "setup.exe" file to start the DB2 Setup wizard. The DB2 Setup wizard launchpad opens.
    Click "Install a Product" and the "Install a Product" window displays the products available for installation.
    Click "Work with Existing" to update an existing DB2 copy.
  7. Perform the DB2 fix pack postinstallation steps:
    For AIX, Linux and Solaris:
    cd <db2_install_path>/instance/
    For example: cd /opt/ibm/db2/V10.5/instance/
    ./db2ilist
    ### repeat the following for each instance listed with db2ilist
    ./db2iupdt <instance>
    su - <instance>
    db2 list db directory  ### find the databases associated.
    db2updv105 -d <dbname>  ### repeat for each database - don't run on database alias entries such as ldapdb2b or ldapclgb.
    db2start
    db2 terminate
    db2 CONNECT TO <dbname>

    ### Packages that are already bound return an SQL0719N error (expected). Ignore any errors seen with these bind commands:
    db2 BIND ~/sqllib/bnd/db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE
    db2 BIND ~/sqllib/bnd/@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
    db2 BIND ~/sqllib/bnd/@db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
    db2 terminate
  8. Perform the DB2 fix pack postinstallation steps:
    For Windows:
    From Start menu, DB2 10.5 Section, open "DB2 command window as administrator"

    db2ilist
    set DB2INSTANCE=<instance>
    db2 list db directory  ### find the databases associated.
    db2updv105 -d <dbname>  ### repeat for each database - don't run on db alias entries such as ldapdb2b or ldapclgb.
    db2start
    db2 terminate
    db2 CONNECT TO <dbname>

    ### Packages that are already bound return an SQL0719N error (expected). Ignore any errors seen with these bind commands:
    cd <db2_10.5_install_location>\bnd
    db2 BIND db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE
    db2 BIND @db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
    db2 BIND @db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
    db2 terminate
  9. After successful update the db2level command output includes the fix level and any available "special_<number>" information:
    > db2level | grep tokens    ### for windows replace find with findstr command
    Informational tokens are "DB2 v10.5.0.11", "special_41328"
  10. Proceed to start ibmdiradm and ibmslapd processes.

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":"PF025","label":"Platform Independent"}],"Version":"6.4"}]

Document Information

Modified date:
04 August 2023

UID

ibm16569229