IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    IT37042

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-05-27

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 May 2022