DB2 - Problem description
Problem IT37042 | Status: Closed |
IN CERTAIN SITUATIONS, AUTHORIZATION ERROR INFORMATION MAY NOT BE LOGGED TO THE DB2DIAG.LOG | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
In certain situations, such as db2start or when updating the database manager configuration file, authorization errors may not log useful diagnostic information from security plugins to the db2diag.log. The only message logged may be a generic error message, indicating that the operation failed. Example command line error: [db2inst1@pate1 ~]$ db2start SQL1366N A security plug-in "IBMLDAPauthclient" processing error occurred on the client. Reason code = "7". Example generic Message: 2021-05-26-11.30.22.930416-420 I2228E847 LEVEL: Warning PID : 21275 TID : 139856316467072 PROC : db2start INSTANCE: db2inst1 NODE : 000 HOSTNAME: MYHOST1 FUNCTION: DB2 UDB, base sys utilities, sqlestrt.C::main, probe:1763 MESSAGE : Error encountered during db2start execution DATA #1 : unsigned integer, 4 bytes 32 DATA #2 : unsigned integer, 4 bytes 0 DATA #3 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1366 sqlerrml: 20 sqlerrmc: IBMLDAPauthclient 7 sqlerrp : SQLESTRT sqlerrd : (1) 0x805C0197 (2) 0x00000197 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Comment | |
Upgrade to 11.1.4.7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.05.2021 17.04.2022 17.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |