IBM Support

The LDAP directory server is unable to connect to the database.

Troubleshooting


Problem

If the DB2 administrative user password for the ITDS database expires, the server will start in configuration only mode or will not start at all if the "-n" is specified during startup.

Resolving The Problem

On ITDS v 6.x, if the server fails to start with Message "GLPRDB004E The LDAP directory server is unable to connect to the database" and the db2cli.log contains the following message:

"SQL30082N Attempt to establish connection failed with security reason "1" ("PASSWORD EXPIRED"). SQLSTATE=08001" then your DB2 administrative user password has expired and it needs to be reset.

On ITDS v5.2 you will see the following message when attempting to start the server "Error code -1 from odbc string:" SQLConnect " ldapdb2b " and the db2cli.log contains the following message:

"SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001" then your DB2 administrative user password has expired and it needs to be reset.

You can reset you DB2 Administrative User Password as follows:

For ITDS v6.x:

1) Verify that the Username and Password are updated and valid on the Operating System.

2) Issue "idscfgdb -I <instance name> -w <new DB2 Admin Password> -n"


    Example:


    # idscfgdb -I ldapdb2 -w newPassword -n
    You have chosen to perform the following actions:

    GLPCDB022I The database administrator password will be reconfigured.
    GLPCDB028I Reconfiguring database password.
    GLPCDB029I Reconfigured database password.

3) Start the ITDS server

For ITDS v5.2:

1) Verify that the Username and Password are updated and valid on the Operating System.

2) Issue "ldapcfg -w <new DB2 Admin Password> -n"


    Example:
    ==> ldapcfg -w db2ldap -n

    You have chosen the following actions:

    The database password will be reconfigured.

    Reconfiguring database password.
    Reconfigured database password.

    IBM Tivoli Directory Server Configuration complete.

3) Start the ITDS server

[{"Product":{"code":"SSVJJU","label":"IBM Security Directory Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.2;6.0;6.1;6.2;6.3;6.3.1;6.4","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21297067