A fix is available
APAR status
Closed as program error.
Error 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
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * fixed in db2_v111m4fp7 * ****************************************************************
Problem conclusion
fixed in db2_v111m4fp7
Temporary fix
Comments
APAR Information
APAR number
IT36374
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-03-26
Closed date
2021-07-01
Last modified date
2021-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022