Support for Informix

Latest versions	fixlist
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Have problems? - contact us.
Register for free
Contact form

DB2 - Problem description

Problem IT36374	Status: Closed
DB2 HANGS EXECUTING ENV_GET_DB2_EDU_SYSTEM_RESOURCE
product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
db2 hangs executing ENV_GET_DB2_EDU_SYSTEM_RESOURCE. select MEMBER, EDU_ID, EDU_NAME, DB2_PROCESS_ID, TID, KTID, CPU_USER_TIME_MS, CPU_SYSTEM_TIME_MS, RESOURCE_METHOD, RESOURCE_BINDING, RESOURCE_GROUP from table( ENV_GET_DB2_EDU_SYSTEM_RESOURCES ( -2 ) ) as T The query hangs. Db2 instance cannot be stopped and require a restart of the whole machine. db2trc flw file looks like the following: 80062 \| \| \| \| \| \| \| \| \| \| \| \| envGetDB2EduSystemResources entry [eduid 4728 eduname db2agent] 80063 \| \| \| \| \| \| \| \| \| \| \| \| \| sqlerTrustedRtnCallbackRouter entry [eduid 4728 eduname db2agent] 80064 \| \| \| \| \| \| \| \| \| \| \| \| \| sqlerTrustedRtnCallbackRouter data [probe 1] 80065 \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlrwGetWLMTableFunctionMergedResult entry [eduid 4728 eduname db2agent] 80066 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlrkGetWLMTableFunctionResult entry [eduid 4728 eduname db2agent] 80067 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlrwEnvGetDB2EduSystemResourcesBackend entry [eduid 4728 eduname db2agent] 80068 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlogmblkEx entry [eduid 4728 eduname db2agent] 80069 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlogmblkEx mbt [Marker:PD_OSS_ALLOCATED_MEMORY ] 80070 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlogmblkExTrace entry [eduid 4728 eduname db2agent] 80071 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlogmblkExTrace mbt [Marker:PD_SQLOMEM_TRACE_BLOCK_ALLOC ] 80072 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlogmblkExTrace exit 80073 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlogmblkEx exit 80074 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqloGetCPUUsage entry [eduid 4728 eduname db2agent] 80075 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlo_xlatch::getConflict entry [eduid 4728 eduname db2agent] 80076 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlorest entry [eduid 4728 eduname db2agent] 80077 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlorest data [probe 10] 80087 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlorest exit 80088 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlorest entry [eduid 4728 eduname db2agent] 80090 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlorest data [probe 10] 80092 \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| sqlorest exit
Problem Summary:
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * fixed in db2_v111m4fp7 * ****************************************************************
Local Fix:

Solution

Workaround
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * fixed in db2_v111m4fp7 * ****************************************************************
Comment
fixed in db2_v111m4fp7
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	26.03.2021 01.07.2021 01.07.2021
Problem solved at the following versions (IBM BugInfos)

Problem solved according to the fixlist(s) of the following version(s)