DB2 - Problem description
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) |