|
Problem IC84159
|
Status: Closed |
LICENSE CACHE CHECKING CAN CAUSE SLOW DATABASE CONNECTS FROM CLI APPLICATIONS WHEN MULTIPLE CONCURRENT CLI CONNECTIONS OCCUR |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When there are multiple concurrent CLI connections occurring,
delays may occur in connecting to a database from a CLI
application. The delay in the connection could be caused by
serialization around the ~/sqllib/cfgcache/conlic.bin license
cache file. Non-CLI applications are not affected.
A CLI trace would show long connections times in the SQLConnect(
) function. Note, not all connection times would necessarily be
long. Those that initially acquired the lock on the file would
complete normally. Large DPF environments may be more
susceptible to the problem.
From a db2trc, the long function calls would be around the
sqloflock function (to lock a file) called from within the
sqleuPerformServerActivationCheck code path:
1615919 23.711703015 | | | | | | | | | |
sqleuPerformServerActivationCheck entry
1615923 23.711704648 | | | | | | | | | | |
sqleuCheckLicenseCache entry
1615925 23.711706568 | | | | | | | | | | | |
sqloxltc_app entry
1615926 23.711707517 | | | | | | | | | | | |
sqloxltc_app exit
1615928 23.711708070 | | | | | | | | | | | |
sqleuLoadAndUpdateLicenseCache entry
1615930 23.711709095 | | | | | | | | | | | | |
sqleuSetupLicenseCacheFileName entry
1615931 23.711709728 | | | | | | | | | | | | | |
sqloInstancePath entry
1615932 23.711710186 | | | | | | | | | | | | | |
sqloInstancePath exit
1615934 23.711711910 | | | | | | | | | | | | | |
ossPathExists entry
1615935 23.711712466 | | | | | | | | | | | | | | |
ossPathTest entry
1615937 23.711712925 | | | | | | | | | | | | | | |
ossPathTest data [probe 10]
1615980 23.712051356 | | | | | | | | | | | | | | |
ossPathTest exit
1615981 23.712052138 | | | | | | | | | | | | | |
ossPathExists exit
1615982 23.712053440 | | | | | | | | | | | | |
sqleuSetupLicenseCacheFileName exit
1615983 23.712054651 | | | | | | | | | | | | | sqloopenp
entry
1615984 23.712055720 | | | | | | | | | | | | | sqloopenp
data [probe 30]
1616027 23.712409337 | | | | | | | | | | | | | |
sqloflock entry
9102710 264.157411984 | | | | | | | | | | | | | |
sqloflock exit
9102725 264.166083238 | | | | | | | | | | | | | sqloopenp
exit
9102734 264.166090889 | | | | | | | | | | | |
sqleuLoadAndUpdateLicenseCache data [probe 30]
9102741 264.166094529 | | | | | | | | | | | | |
sqloFileStats entry
9102763 264.166567969 | | | | | | | | | | | | |
sqloFileStats data [probe 200]
9102770 264.167521327 | | | | | | | | | | | | |
sqloFileStats exit
9102772 264.167524589 | | | | | | | | | | | | |
sqlogmblkEx entry
9102776 264.167526244 | | | | | | | | | | | | | |
sqloGetPrivatePoolHandle entry
9102778 264.167527062 | | | | | | | | | | | | | |
sqloGetPrivatePoolHandle exit
9102791 264.167536767 | | | | | | | | | | | | |
sqlogmblkEx mbt [Marker:PD_OSS_ALLOCATED_MEMORY ]
9102799 264.167540608 | | | | | | | | | | | | |
sqlogmblkEx exit
9102811 264.170739275 | | | | | | | | | | | | | sqloread
entry
9102851 264.171176171 | | | | | | | | | | | | | sqloread
exit
9102865 264.174063913 | | | | | | | | | | | | |
sqleuUpdateMemoryCache entry |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All CLI interface users doing concurrent connections to *
* zDB2. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.1.1 *
**************************************************************** |
| Local Fix: |
Rename or remove the ~/sqllib/cfgcache/conlic.bin cache file.
However, the file will be recreated when connections are made to
remote databases. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
From v101 FP1 concurrent connections to zDB2 may not hang due to
server based license checking. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.06.2012
02.11.2012
02.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
