IBM Support

IC77996: SQLOSPAWNANDWAITFORPASSWORDCHECKEXE MAY REPORTS FALSE DEADLOCK MESSAGES IN DB2CKPWD

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • sqloSpawnAndWaitForPasswordCheckExe  may report false messages (
    deadlock, out of memory ) in db2diag.log
    
    like
    
    2000-00-00-00.00.00.000000+000               LEVEL: Severe
    
    PID     : 11111111111        TID  : 111         PROC : db2ckpwd
    0
    INSTANCE: xxxxxx              NODE : 000
    
    EDUID   : 111                  EDUNAME: db2sysc 0
    
    FUNCTION: DB2 UDB, oper system services,
    
    sqloSpawnAndWaitForPasswordCheckExe, probe:130
    
    MESSAGE : ZRC=0x800F006A=-2146500502=SQLO_BAD_USER "Bad User"
    
              DIA8117C Error with userid "".
    
    CALLED  : DB2 UDB, oper system services, db2ckpw::main
    
    RETCODE : ZRC=0x00000002=2
    
              DIA8002C A deadlock has occurred, rolling back
    transaction.
    
    
    This is happening because of incorrect usage of  ZRC codes
    received from db2ckpw executable in db2 diaglog printing
    function. This messages are not indication of real deadlocks or
    other events and can be safely ignored.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7 Fixpak 6                                  *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 9.7 Fixpak 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77996

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-09

  • Closed date

    2012-11-13

  • Last modified date

    2012-11-13

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

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

    IC84239

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77996

Modified date: 13 November 2012