|
Problem IT21710
|
Status: Closed |
REMOVE LICENSE CHECKING FROM THE CONNECTION CREATION LOGIC ON SERVER SIDE TO IMPROVE PERFORMANCE
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
The performance of creating connection can be impacted by
license checking code. When it's happened, a lot of db2agent
may have the following similar stack waiting on a lock (not
transaction lock):
0x00007F2240741375
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0385
0x00007F2240740F7C ossDumpStackTraceV98 + 0x002c
0x00007F224073D04D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00fd
0x00007F2246C67D14 sqlo_trce + 0x0404
0x00007F2246CF1E4E sqloDumpDiagInfoHandler + 0x010e
0x00007F224BF7E7C0 address: 0x00007F224BF7E7C0 ; dladdress:
0x00007F224BF6F000 ; offset in lib: 0x000000000000F7C0 ;
0x00007F224BF7DFAD __nanosleep + 0x002d
0x00007F224071E9AC ossLockGetConflict + 0x01dc
0x00007F2244117094 _Z19NetlsRequestLicensejPcS_PlS_ + 0x0314
0x00007F224411609B _Z15LicGetAccessKeyjPhPjPlbPi + 0x01cb
0x00007F2244118172 sqllcConnectUser + 0x01c2
0x00007F2244CF30A6 sqloSqlcConnectUser + 0x0086
0x00007F2244CF3009 sqloLicConnectUser + 0x0069
0x00007F2243D62685
_ZN14sqeApplication13AppStartUsingEP8SQLE_BWAP8sqeAgentccP5sqlca
Pc + 0x20c5
0x00007F2243D576F9
_ZN14sqeApplication13AppLocalStartEP14db2UCinterface + 0x05b9
0x00007F2243F76EE0 _Z11sqlelostWrpP14db2UCinterface + 0x0040
0x00007F2243F75E05 _Z14sqleUCengnInitP14db2UCinterfacet +
0x06f5
0x00007F2243F746F9 sqleUCagentConnect + 0x04c9
0x00007F22440863B6
_Z18sqljsConnectAttachP13sqljsDrdaAsCbP14db2UCinterface + 0x00b6
0x00007F224404BAFE
_Z16sqljs_ddm_accsecP14db2UCinterfaceP13sqljDDMObject + 0x03ce
0x00007F224403F2D8
_Z17sqljsParseConnectP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCint
erface + 0x0058
0x00007F224403FB1C
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x036c
0x00007F2244039DE0 address: 0x00007F2244039DE0 ; dladdress:
0x00007F2240C64000 ; offset in lib: 0x00000000033D5DE0 ;
0x00007F224403843C address: 0x00007F224403843C ; dladdress:
0x00007F2240C64000 ; offset in lib: 0x00000000033D443C ;
0x00007F2244035499 address: 0x00007F2244035499 ; dladdress:
0x00007F2240C64000 ; offset in lib: 0x00000000033D1499 ;
0x00007F224403508B _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T
+ 0x00eb
0x00007F2243D3A406 _ZN8sqeAgent6RunEDUEv + 0x0c96
0x00007F2245526737 _ZN9sqzEDUObj9EDUDriverEv + 0x00f7
0x00007F2244CF82D1 sqloEDUEntry + 0x0301
0x00007F224BF767B6 address: 0x00007F224BF767B6 ; dladdress:
0x00007F224BF6F000 ; offset in lib: 0x00000000000077B6 ;
0x00007F223FABDD6D clone + 0x006d
The lock holder has the following similar stack:
0x00007F2240741375
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0385
0x00007F2240740F7C ossDumpStackTraceV98 + 0x002c
0x00007F224073D04D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00fd
0x00007F2246C67D14 sqlo_trce + 0x0404
0x00007F2246CF1E4E sqloDumpDiagInfoHandler + 0x010e
0x00007F224BF7E7C0 address: 0x00007F224BF7E7C0 ; dladdress:
0x00007F224BF6F000 ; offset in lib: 0x000000000000F7C0 ;
0x00007F224BF7D292 address: 0x00007F224BF7D292 ; dladdress:
0x00007F224BF6F000 ; offset in lib: 0x000000000000E292 ;
0x00007F224BF78634 address: 0x00007F224BF78634 ; dladdress:
0x00007F224BF6F000 ; offset in lib: 0x0000000000009634 ;
0x00007F224BF784A6 pthread_mutex_lock + 0x00b6
0x00007F224C19DD8C address: 0x00007F224C19DD8C ; dladdress:
0x00007F224C18C000 ; offset in lib: 0x0000000000011D8C ;
0x00007F223F7E0F9B address: 0x00007F223F7E0F9B ; dladdress:
0x00007F223F7E0000 ; offset in lib: 0x0000000000000F9B ;
0x00007F224C199E46 address: 0x00007F224C199E46 ; dladdress:
0x00007F224C18C000 ; offset in lib: 0x000000000000DE46 ;
0x00007F223F7E133C address: 0x00007F223F7E133C ; dladdress:
0x00007F223F7E0000 ; offset in lib: 0x000000000000133C ;
0x00007F223F7E0F01 dlopen + 0x0031
0x00007F22455EA01F ifor_slnk_load_library + 0x002f
0x00007F22455CA5E5 ifor_shlib_soft_vector_load + 0x005f
0x00007F22455CA6D5 address: 0x00007F22455CA6D5 ; dladdress:
0x00007F2240C64000 ; offset in lib: 0x00000000049666D5 ;
0x00007F22455CB844 ifor_ls_shlib_lum_node_name + 0x002b
0x00007F22455CBD83 ifor_get_node_name + 0x0019
0x00007F22455CB938 ifor_init_job_info + 0x00bc
0x00007F22455BE723 lum_extended_request_license + 0x05d8
0x00007F22455BF753 lum_request_license + 0x0107
0x00007F22455BBDC7 netls_extended_request_license + 0x00d5
0x00007F2244116F07 _Z19NetlsRequestLicensejPcS_PlS_ + 0x0187
0x00007F224411609B _Z15LicGetAccessKeyjPhPjPlbPi + 0x01cb
0x00007F2244118172 sqllcConnectUser + 0x01c2
0x00007F2244CF30A6 sqloSqlcConnectUser + 0x0086
0x00007F2244CF3009 sqloLicConnectUser + 0x0069
0x00007F2243D62685
_ZN14sqeApplication13AppStartUsingEP8SQLE_BWAP8sqeAgentccP5sqlca
Pc + 0x20c5
0x00007F2243D576F9
_ZN14sqeApplication13AppLocalStartEP14db2UCinterface + 0x05b9
0x00007F2243F76EE0 _Z11sqlelostWrpP14db2UCinterface + 0x0040
0x00007F2243F75E05 _Z14sqleUCengnInitP14db2UCinterfacet +
0x06f5
0x00007F2243F746F9 sqleUCagentConnect + 0x04c9
0x00007F22440863B6
_Z18sqljsConnectAttachP13sqljsDrdaAsCbP14db2UCinterface + 0x00b6
0x00007F224404BAFE
_Z16sqljs_ddm_accsecP14db2UCinterfaceP13sqljDDMObject + 0x03ce
0x00007F224403F2D8
_Z17sqljsParseConnectP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCint
erface + 0x0058
0x00007F224403FB1C
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x036c
0x00007F2244039DE0 address: 0x00007F2244039DE0 ; dladdress:
0x00007F2240C64000 ; offset in lib: 0x00000000033D5DE0 ;
0x00007F224403843C address: 0x00007F224403843C ; dladdress:
0x00007F2240C64000 ; offset in lib: 0x00000000033D443C ;
0x00007F2244035499 address: 0x00007F2244035499 ; dladdress:
0x00007F2240C64000 ; offset in lib: 0x00000000033D1499 ;
0x00007F224403508B _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T
+ 0x00eb
0x00007F2243D3A406 _ZN8sqeAgent6RunEDUEv + 0x0c96
0x00007F2245526737 _ZN9sqzEDUObj9EDUDriverEv + 0x00f7
0x00007F2244CF82D1 sqloEDUEntry + 0x0301
0x00007F224BF767B6 address: 0x00007F224BF767B6 ; dladdress:
0x00007F224BF6F000 ; offset in lib: 0x00000000000077B6 ;
0x00007F223FABDD6D clone + 0x006d
This license checking code is obsolete and does not match
current license model. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod 2 Fix Pack 2 or higher *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : IT11638
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.08.2017
24.10.2017
24.10.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
