IBM Support

LDAP (IBM Tivoli Directory Server) Fails to Start

Troubleshooting


Problem

Attempts to start any/all LDAP server instances fails reporting with message sequence GLD040B rc -456, GLD040A, GLD0416 and SQL0456. Both the GLD040B rc 456 and the SQL0456 pointed to QGLDRSDX already existing. Resolution is to drop the QGLDRSDX function.

Resolving The Problem

Attempts to start any or all LDAP server instances fails reporting with message sequence GLD040B rc -456, GLD040A, GLD0416 and SQL0456. Both the GLD040B rc 456 and the SQL0456 pointed to QGLDRSDX already existing. Resolution is to drop the QGLDRSDX function.

Here is an example of the error message highlighting the SQL function already exists:

SQL0456 Diagnostic 30 09/11/11 10:33:53.470978 QSQPROC QSYS *STMT
From user . . . . . . . . . : QSECOFR
From module . . . . . . . . : QSQPROC
From procedure . . . . . . : CLEANUP
Statement . . . . . . . . . : 45045
To module . . . . . . . . . : QSQPROC
To procedure . . . . . . . : CLEANUP
Statement . . . . . . . . . : 45045
Message . . . . : Specific name QGLDRSDX in QDIRSRV already exists.

Resolution in this case was to drop the existing QGLDRSDX function:
Identify whether you are using SYSTEM or SQL naming.

Issue the STRSQL command, press F13, Option 1, then check Naming convention. It will be either *SYS or *SQL:

o If *SYS , press F12 to get back to the SQL statement entry screen and run the following command:
DROP SPECIFIC FUNCTION QDIRSRV/QGLDRSDX

o If *SQL, run the following command:
DROP SPECIFIC FUNCTION QDIRSRV.QGLDRSDX

Once you have done this, you should exit SQL mode (F3, Option 1) and try starting the LDAP instance again (i.e. STRTCPSVR *DIRSRV).

Dropping the existing function will either allow the LDAP instance to start or get further in the startup process to the next issue.

The following PTFs permanently resolve the issue by using "CREATE OR REPLACE FUNCTION" instead of "CREATE FUNCTION" on the SQL statement executed by the IBM Tivoli Directory Server at startup.

APAR documenting this issue: SE71452
PTFs were generated for all current OS versions:
IBM i 7.4: 5770SS1-SI70236
IBM i 7.3: 5770SS1-SI70189
IBM i 7.2: 5770SS1-SI70235

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"}]

Historical Number

610054932

Document Information

Modified date:
18 December 2019

UID

nas8N1011360