suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)