When prefetcher fails to obtain a free request, then the
database may trap during error handling.
The db2diag.log will contain the following messages:
2010-03-15-11.23.57.895273-240 E189650813A526 LEVEL: Error
(OS)
PID : 3538 TID : 2820 PROC : db2sysc
INSTANCE: svtdbm8 NODE : 000 DB : SAMPLE
APPHDL : 0-39451 APPID:
9.26.98.158.21414.100315143107
AUTHID : SVTDBM8
EDUID : 2820 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, oper system services, sqloCSemV, probe:1
MESSAGE : ZRC=0x83000016=-2097151978
CALLED : OS, -, unspecified_system_function
OSERR : EINVAL (22) "Invalid argument"
2010-03-15-11.23.57.896737-240 I189651340A447 LEVEL: Error
PID : 3538 TID : 2820 PROC : db2sysc
INSTANCE: svtdbm8 NODE : 000 DB : SAMPLE
APPHDL : 0-39451 APPID:
9.26.98.158.21414.100315143107
AUTHID : SVTDBM8
EDUID : 2820 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, buffer pool services, sqlbpfTriggerPrefetch,
probe:1
MESSAGE : ZRC=0x83000016=-2097151978
The stack trace will contain the following:
sqlbLogErr + 0x120
sqlbpfTriggerPrefetch + 0x720
sqldFetchDirect + 0x34b0 |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* If an agent fails to obtain a prefetch request, under some *
* circumstances the error handling may incorrect attempt to *
* deference a NULL request pointer to dump out diagnostic *
* information. *
* *
* When prefetcher fails to obtain a free request, then the *
* *
* database may trap during error handling. *
* *
* *
* *
* The db2diag.log will contain the following messages: *
* *
* *
* *
* 2010-03-15-11.23.57.895273-240 E189650813A526 LEVEL: *
* Error *
* (OS) *
* *
* PID : 3538 TID : 2820 PROC : *
* db2sysc *
* INSTANCE: svtdbm8 NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-39451 APPID: *
* *
* 9.26.98.158.21414.100315143107 *
* *
* AUTHID : SVTDBM8 *
* *
* EDUID : 2820 EDUNAME: db2agent (SAMPLE) *
* FUNCTION: DB2 UDB, oper system services, sqloCSemV, probe:1 *
* *
* MESSAGE : ZRC=0x83000016=-2097151978 *
* *
* CALLED : OS, -, unspecified_system_function *
* *
* OSERR : EINVAL (22) "Invalid argument" *
* *
* *
* *
* 2010-03-15-11.23.57.896737-240 I189651340A447 LEVEL: *
* Error *
* PID : 3538 TID : 2820 PROC : *
* db2sysc *
* INSTANCE: svtdbm8 NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-39451 APPID: *
* *
* 9.26.98.158.21414.100315143107 *
* *
* AUTHID : SVTDBM8 *
* *
* EDUID : 2820 EDUNAME: db2agent (SAMPLE) *
* FUNCTION: DB2 UDB, buffer pool services, *
* sqlbpfTriggerPrefetch, *
* probe:1 *
* *
* MESSAGE : ZRC=0x83000016=-2097151978 *
* *
* *
* *
* *
* *
* The stack trace will contain the following: *
* *
* <StackTrace> *
* *
* ##### Object: *
* *
* /view/db2_v95fp4_sun64_special_22749_special_23438/vbs/engn/li
* libdb2e.so.1 *
* *
* __1cKsqlbLogErr6FiiiiipcpnQSQdDLB_OBJECT_DESC_IIpnNSQdDLB_MAP_
* FO__i_(0x0,0x2,0x18100185,0x1,0x0,0xffffffff3ebf2eec) *
* *
* + 0x120 *
* *
* __1cVsqlbpfTriggerPrefetch6FIIiipnQSQdDLB_OBJECT_DESC_IpnMSQdD
* _GLOBALS_pnPSQdDLB_pfMapCache__ *
* *
* i_(0x870f0000,0x4,0x4,0xffffffff83000016,0xffffffff3ebf2f58,0x
* + 0x720 *
* *
* __1cPsqldFetchDirect6FpnNSQdDLD_DFM_WORK__i_(0xffffffff484d7bf
* 0xffffffff484d7d50,0xffffffff48 *
* *
* 4d7c60,0xffffffff484d7d50,0xffffffff484d7da0,0xffffffff484d7da
* + 0x34b0 *
****************************************************************
* RECOMMENDATION: *
* There cannot be easily avoided in a customer environment *
**************************************************************** |
