|
Problem IT36853
|
Status: Closed |
DB2AGENT REPORTED SQLD_PARM ERROR WHEN TRYING TO FIND/FIX TCB WITH OBJECTID=0
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
The following is reported in db2diag.log:
2021-04-14-15.20.35.422521-240 I132653241A2383 LEVEL:
Severe
PID : 64160164 TID : 42412 PROC :
db2sysc 0
INSTANCE: NODE : 000 DB :
APPHDL : APPID:
AUTHID : HOSTNAME:
EDUID : 42412 EDUNAME:
FUNCTION: DB2 UDB, data management, sqldAllocEmptyTCB, probe:1
RETCODE : ZRC=0x8704002F=-2029780945=SQLD_PARM "PARAMETER ERROR"
DIA8544C An invalid data type was encountered, the
value was "".
MESSAGE : Request to allocate TCB for ObjectID 0
DATA #1 : poolID, PD_TYPE_SQLD_POOL_ID, 4 bytes
0x00000000
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x090000005AFC80E4
sqldAllocEmptyTCB__FP8sqeAgentPP8SQLD_TCBiN23UlN23T6UiT10_T3T6 +
0x164
[1] 0x090000005AFDB8E8
sqldFixTCB__FP8sqeAgentiN32PP8SQLD_TCBUiT7 + 0x12B8
[2] 0x090000005B05F640
sqldLockTableFixTCB__FP8sqeAgentUsT2UcUliN26N25T6PCcT6T12_T6P14S
QLP_LOCK_INFOPP8SQLD_TCBUiT18_ + 0x1D0
[3] 0x090000005D156840
sqldScanOpen__FP8sqeAgentP14SQLD_SCANINFO1P14SQLD_SCANINFO2PPv +
0x810
[4] 0x090000005ADF4340 open__16sqlrlCatalogScanFv + 0x4D0
[5] 0x090000005ADFA850 fetchOneRow__16sqlrlCatalogScanFv +
0xB0
[6] 0x090000005BE62B7C
sqlraERTGetVarinfoFromCatalog__FP8sqlrr_cbiP11sqlrrstringN23PUcP
P12sqlrg_var_pd + 0x2CC
[7] 0x090000005BE65728
sqlraDatabaseERTGetValue__FP8sqlrr_cb16sqlraERTCategoryPvP10sqlz
_valuePb + 0x12F8
[8] 0x090000005CB400D0
IPRA.$sqlrr_rds_common_pre1__FP14db2UCinterfaceiT2Ui + 0x44D0
[9] 0x090000005CB3A138
sqlrr_sql_request_pre__FP14db2UCinterfaceUiiP16db2UCprepareInfoP
15db2UCCursorInfo + 0x3C8
[10] 0x090000005CFF47B8 sqlrr_rollback__FP14db2UCinterface +
0x78
[11] 0x090000005BF8C5F8
sqljsRollbackBeforeConnectReset__FP14db2UCconHandle + 0x4C8
[12] 0x090000005BF9140C
IPRA.$sqljsCleanup__FP8sqeAgentP14db2UCconHandle + 0x13CC
[13] 0x090000005BF84AF4
IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xB94
[14] 0x090000005BF8275C
sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x33C
[15] 0x090000005A211DE8 RunEDU__8sqeAgentFv + 0xBC8
[16] 0x090000005A1D80C0 EDUDriver__9sqzEDUObjFv + 0x2F0
[17] 0x090000005A0EED74 sqloEDUEntry + 0x364
[18] 0x09000000005ABFE8 _pthread_body + 0xE8
[19] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.6 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.6 or later *
**************************************************************** |
| Comment |
Upgrade to Db2 11.5.6 or later |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.05.2021
24.06.2021
28.06.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
