IBM Support

IT34715: MISSING INFORMATION IN DB2DIAG.LOG WHEN USERID AND PASSWORD ARE CORRECT, BUT THE USER IS REVOKED/DISABLED/LOCKED

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When userid/pass are correct, but the user is disabled/revoked
    or locked, we return the following message into db2diag.log:
    
    2020-10-22-14.04.43.604394-240 I13087491A472        LEVEL:
    Warning
    PID     : 16974450             TID : 239362         PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   :
    sample
    APPHDL  : 0-2117
    HOSTNAME: <hostname>
    EDUID   : 239362               EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
    DATA #1 : String with size, 67 bytes
    Password validation for user batchjob failed with rc =
    -2146500316
    
    When userid or password are incorrect, or expired: we see the
    following messages in db2diag.log:
    
    2020-10-22-20.35.18.931385-240 I9223280A469         LEVEL:
    Warning
    
    PID     : 27590856             TID : 164713         PROC :
    db2sysc 0
    
    INSTANCE: db2inst1               NODE : 000           DB   :
    SAMPLE
    
    APPHDL  : 0-60770
    
    HOSTNAME: HOSTNAME
    
    EDUID   : 164713               EDUNAME: db2agent (SAMPLE) 0
    
    FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
    
    DATA #1 : String with size, 66 bytes
    
    Password validation for user batchjob failed with rc =
    -2146500507
    
    
    
    2020-10-22-20.35.18.932215-240 I9223750A530         LEVEL:
    Warning
    
    PID     : 27590856             TID : 164713         PROC :
    db2sysc 0
    
    INSTANCE: db2inst1                NODE : 000           DB   :
    SAMPLE
    
    APPHDL  : 0-60770
    
    HOSTNAME: HOSTNAME
    
    EDUID   : 164713               EDUNAME: db2agent (SAMPLE) 0
    
    FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate,
    probe:160
    
    MESSAGE : Failing connection IP address: local IPC
    
    DATA #1 : String, 16 bytes
    
    application id:
    
    DATA #2 : String with size, 25 bytes
    
    *LOCAL.db2inst1.201023003709
    
    
    we need to add the conditions to cover locked/revoked/disabled
    users as well.
    
    The information about IP address provides clues for customers to
    track down the applications using disabled users.
    

Local fix

  • No Local Fix
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users on DB2 v111m4FP5 and earlier                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * First Fixed in DB2 v111m4FP6                                 *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 v111m4FP6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT34715

  • 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

    2020-10-28

  • Closed date

    2021-03-15

  • Last modified date

    2021-03-15

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

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
16 March 2021