IBM Support

Turning off extended security on Tivoli/DB2 for problematic Microsoft Windows installations

Troubleshooting


Problem

The installation of the Rational Directory Server (RDS) - Tivoli version on Microsoft Windows requires a pre-install of Tivoli and DB2. But these in turn require a number of Windows Users and Groups and a specific set of User Rights Assignments. However at some client sites, the local Group Policy settings may be such that it proves impossible to successfully install the requiredTivoli/DB2 variant. This is particularly prevalent in Microsoft Windows 2003 where additional security settings are possible. This document explains how to check the user rights assignments and, if necessary, to turn off the default DB2 extended security so that the installation can proceed successfully.

Symptom

Installation of RDS fails with errors in the ibmslapd.log file shows an error GLPRDB001E Error code -1 from function: "SQLExecDirect " CREATE TABLE TDSADMIM.LDAP_ENTRY ( EID INTEGER NOT NULL, PEID INTEGER, DN_TRUNC VARCHAR(240), DN VARCHAR(1000), CREATOR VARCHAR(1000), MODIFIER VARCHAR(1000), MODIFY_TIMESTAMP TIMESTAMP, CREATE_TIMESTAMP TIMESTAMP, ENTRYDATA VARCHAR(24004), ENTRYBLOB BLOB(1G) LOGGED, ENTRYSIZE INTEGER, PRIMARY KEY (EID))

[{"Product":{"code":"SS4AKG","label":"Rational Directory Server"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"General Information","Platform":[{"code":"PF033","label":"Windows"}],"Version":"5.1;5.0","Edition":"","Line of Business":{"code":"LOB15","label":"Integration"}},{"Product":{"code":"SSYQQ2","label":"Rational Change"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Directory Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"5.2.0.2;5.2;5.1;5.0","Edition":"All Editions","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSKR2T","label":"IBM Engineering Requirements Management DOORS"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Directory Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.2.0.2;9.2.0.1;9.2;9.1.0.2;9.1","Edition":"All Editions","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSC6Q5","label":"Rational Synergy"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Directory Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1a;7.1;7.0","Edition":"All Editions","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
22 December 2020

UID

swg21416448