DB2 - Problem description
Problem IT15210 | Status: Closed |
GLM-LOCK LIST AVAILABLE VALUE FLIP-FLOPS IN A SHORT PERIOD OF TIME | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
In pureScale environment, "GLM-lock list available" value in db2diag.log may jump up and down in miliseconds due to an old cached value in each agent. 2016-01-25-00.43.13.961294+540 E12265A608 LEVEL: Warning PID : 15663322 TID : 186028 PROC : db2sysc 2 INSTANCE: db2inst1 NODE : 002 DB : SAMPLE APPHDL : 2-20867 APPID: 192.168.1.1.38253.160117103453 AUTHID : DB2INST1 HOSTNAME: purescale1 EDUID : 186028 EDUNAME: db2agent (SAMPLE) 2 FUNCTION: DB2 UDB, lock manager, sqlpUpdateMemStatus, probe:611 DATA #1 : Locking memory management: GLM-status normal, all GLM-thresholds resolved. GLM-lock list size = 32456767 GLM-lock list available = 30715515 ..(snip).. 2016-01-25-00.43.13.962041+540 E12874A685 LEVEL: Warning PID : 15663322 TID : 153400 PROC : db2sysc 2 INSTANCE: db2inst1 NODE : 002 DB : SAMPLE APPHDL : 2-13204 APPID: 192.168.1.2.37450.160117052905 AUTHID : DB2INST1 HOSTNAME: purescale1 EDUID : 153400 EDUNAME: db2agent (SAMPLE) 2 FUNCTION: DB2 UDB, lock manager, sqlpUpdateMemStatus, probe:611 DATA #1 : Locking memory management: GLM-memory low. Escalation threshold activated. Remove Sticky Locks threshold activated. Stop Prefetching threshold activated. GLM-lock list size = 32456767 GLM-lock list available = 861338 ..(snip).. 2016-01-25-00.43.13.968445+540 E22988A608 LEVEL: Warning PID : 15663322 TID : 186028 PROC : db2sysc 2 INSTANCE: db2inst1 NODE : 002 DB : SAMPLE APPHDL : 2-20867 APPID: 192.168.1.1.38253.160117103453 AUTHID : DB2INST1 HOSTNAME: purescale1 EDUID : 186028 EDUNAME: db2agent (SAMPLE) 2 FUNCTION: DB2 UDB, lock manager, sqlpUpdateMemStatus, probe:611 DATA #1 : Locking memory management: GLM-status normal, all GLM-thresholds resolved. GLM-lock list size = 32456767 GLM-lock list available = 30715515 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * pureScale users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * This problem is not fixed in 10.1 release but will be fixed * * in a future release. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT13672 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.05.2016 09.02.2017 09.02.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |