DB2 - Problem description
| Problem IC77996 | Status: Closed |
SQLOSPAWNANDWAITFORPASSWORDCHECKEXE MAY REPORTS FALSE DEADLOCK MESSAGES IN DB2CKPWD | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem 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. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 9.7 Fixpak 6 * **************************************************************** | |
| Local Fix: | |
n/a | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
| Solution | |
First fixed in DB2 9.7 Fixpak 6 | |
| Workaround | |
not known / see Local fix | |
| BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC84239 follow-up : | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.08.2011 13.11.2012 13.11.2012 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7. | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.6 |
|