DB2 - Problem description
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) |