|
Problem IC96673
|
Status: Geschlossen |
SLOW PERFORMANCE IN SQLHAAMIINCLUSTERENVIRONMENT IN DPF ENVIRONMENTS DUE TO UNNECESSARY FILE LOCKING ATTRIBUTE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
At times e.g. database activation, update of the database config
... DB2 may need to know if the Instance is running in a HA
envionment.
To do this it has a function, sqlhaAmIinClusterEnvironment
If the dbm cfg value CLUSTER_MGR is set, then this function will
open and exclusively lock a HA file that exists in the instance
directory.
In a ( large ) DPF environment, with the instance home directory
mounted, this may lead to long delays as access to the file is
effectively serialized.
A stack trace may show this :
__fcntl + 0x0082
sqloflock + 0x0106
sqloopenp + 0x05ea
HAReg3GetEmPvS0_ + 0x0037
sqlhaGetPolicyR5HARegR16_sqlhaPolicyType + 0x00f9
sqlhaGetPolicyTypeFromSysFileP16_sqlhaPolicyType + 0x0215
sqlhaAmIinClusterEnvironmentPbP9sqlf_kcfd + 0x057c
sqlf_upd_parmP11db2CfgParamP10sqlf_dbcfdPcP13SQLP_LH_PARMSS2_jP5
sqlcaPKcPb + 0x01e6
sqlfIntUpdateDbCfgPKcS0_P6db2CfgP5sqlca + 0x03a4 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DB2 DPF db2haicu users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.7.0.9 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Fixed in DB2 V9.7.0.9 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 08.10.2013
06.01.2014
06.01.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.0.9
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
