IT37042: IN CERTAIN SITUATIONS, AUTHORIZATION ERROR INFORMATION MAY NOT BE LOGGED TO THE DB2DIAG.LOG

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error 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:
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.1.4.7                                          *
  ****************************************************************
  

Problem conclusion

• Upgrade to 11.1.4.7
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IT37032

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP