{"id":114,"date":"2015-08-23T05:46:25","date_gmt":"2015-08-23T05:46:25","guid":{"rendered":"https:\/\/maximoconcepts.wordpress.com\/?p=114"},"modified":"2015-08-23T05:46:25","modified_gmt":"2015-08-23T05:46:25","slug":"how-to-detect-and-resolve-database-connection-leak","status":"publish","type":"post","link":"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/","title":{"rendered":"How to detect and resolve database connection leak?"},"content":{"rendered":"

There are 2 very detailed posts on IBM DeveloperWorks written by Manjunath about\u00a0database connection leaks – how to detect them and how to resolve them.<\/p>\n

Maximo — How to detect database connection leak<\/a><\/strong>
\nMaximo — How to solve database connection leak<\/a><\/strong><\/p>\n

Here is the crux –<\/p>\n

To free up locked\u00a0database connect in maximo, IBM has introduce 3 new system properties (7.5.0.3 onwards) –<\/p>\n

mxe.db.closelongrunconn<\/strong> – default is false.<\/p>\n

mxe.db.longruntimelimit<\/strong> – default 180 minutes.<\/p>\n

mxe.db.detectlongrunconninterval<\/strong> – default is 30 minutes.\u00a0This is the frequency<\/strong> in which the long running connections are checked.\u00a0Cannot be less then 30 minutes.<\/p>\n

The mxe.db.closelongrunconn<\/strong> property when set to true will close the lost connections if the connections have been held for greater than mxe.db.longruntimelimit<\/strong> time and\u00a0were\u00a0not used by any processes in that time duration.<\/p>\n

\n

To detect database connection leak, turn Maximo dbconnection watchdog logger to INFO and collect the logs for 1-2 days. If there are any connection leaks the logs will show some thing like this –<\/p>\n

[INFO] BMXAA7084I – The DbConnectionWatchDog class has been trying to close the database connection for: 230233001 ms<\/p>\n

DbConnectionWatchDog:Db Connection reference id=436107 SPID=397
\nCreate time:1302986384636
\nLife time:230233001 ms<\/p>\n

The Logger indicates that the\u00a0connection as being held for 230233001 ms i.e. approximately 64 hours.\u00a0By looking in the logs at approximately 64 hours back, one should be able to find the stack trace of where this connection was established<\/p>\n","protected":false},"excerpt":{"rendered":"

There are 2 very detailed posts on IBM DeveloperWorks written by Manjunath about\u00a0database connection leaks – how to detect them and how to resolve them. Maximo — How to detect database connection leak Maximo — How to solve database connection leak Here is the crux – To free up locked\u00a0database connect in maximo, IBM has … Continue reading How to detect and resolve database connection leak?<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11,5],"tags":[],"yoast_head":"\nHow to detect and resolve database connection leak? - Maximo Concepts<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to detect and resolve database connection leak? - Maximo Concepts\" \/>\n<meta property=\"og:description\" content=\"There are 2 very detailed posts on IBM DeveloperWorks written by Manjunath about\u00a0database connection leaks – how to detect them and how to resolve them. Maximo — How to detect database connection leak Maximo — How to solve database connection leak Here is the crux – To free up locked\u00a0database connect in maximo, IBM has … Continue reading How to detect and resolve database connection leak?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/\" \/>\n<meta property=\"og:site_name\" content=\"Maximo Concepts\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-23T05:46:25+00:00\" \/>\n<meta name=\"author\" content=\"Pranjal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pranjal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/\"},\"author\":{\"name\":\"Pranjal\",\"@id\":\"https:\/\/maximoconcepts.com\/#\/schema\/person\/2a0ce61af426d0c4038aeaa51cb0f98b\"},\"headline\":\"How to detect and resolve database connection leak?\",\"datePublished\":\"2015-08-23T05:46:25+00:00\",\"dateModified\":\"2015-08-23T05:46:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/\"},\"wordCount\":246,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/maximoconcepts.com\/#\/schema\/person\/2a0ce61af426d0c4038aeaa51cb0f98b\"},\"articleSection\":[\"Configuration\",\"Technical\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/\",\"url\":\"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/\",\"name\":\"How to detect and resolve database connection leak? - Maximo Concepts\",\"isPartOf\":{\"@id\":\"https:\/\/maximoconcepts.com\/#website\"},\"datePublished\":\"2015-08-23T05:46:25+00:00\",\"dateModified\":\"2015-08-23T05:46:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/maximoconcepts.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to detect and resolve database connection leak?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/maximoconcepts.com\/#website\",\"url\":\"https:\/\/maximoconcepts.com\/\",\"name\":\"Maximo Concepts\",\"description\":\"Concepts Simplified.\",\"publisher\":{\"@id\":\"https:\/\/maximoconcepts.com\/#\/schema\/person\/2a0ce61af426d0c4038aeaa51cb0f98b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/maximoconcepts.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/maximoconcepts.com\/#\/schema\/person\/2a0ce61af426d0c4038aeaa51cb0f98b\",\"name\":\"Pranjal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/maximoconcepts.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/maximoconcepts.com\/wp-content\/uploads\/2015\/08\/dscn4443-2.jpg?fit=516%2C520&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/maximoconcepts.com\/wp-content\/uploads\/2015\/08\/dscn4443-2.jpg?fit=516%2C520&ssl=1\",\"width\":516,\"height\":520,\"caption\":\"Pranjal\"},\"logo\":{\"@id\":\"https:\/\/maximoconcepts.com\/#\/schema\/person\/image\/\"},\"url\":\"https:\/\/maximoconcepts.com\/author\/pranjal\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to detect and resolve database connection leak? - Maximo Concepts","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/","og_locale":"en_GB","og_type":"article","og_title":"How to detect and resolve database connection leak? - Maximo Concepts","og_description":"There are 2 very detailed posts on IBM DeveloperWorks written by Manjunath about\u00a0database connection leaks – how to detect them and how to resolve them. Maximo — How to detect database connection leak Maximo — How to solve database connection leak Here is the crux – To free up locked\u00a0database connect in maximo, IBM has … Continue reading How to detect and resolve database connection leak?","og_url":"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/","og_site_name":"Maximo Concepts","article_published_time":"2015-08-23T05:46:25+00:00","author":"Pranjal","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Pranjal","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/#article","isPartOf":{"@id":"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/"},"author":{"name":"Pranjal","@id":"https:\/\/maximoconcepts.com\/#\/schema\/person\/2a0ce61af426d0c4038aeaa51cb0f98b"},"headline":"How to detect and resolve database connection leak?","datePublished":"2015-08-23T05:46:25+00:00","dateModified":"2015-08-23T05:46:25+00:00","mainEntityOfPage":{"@id":"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/"},"wordCount":246,"commentCount":1,"publisher":{"@id":"https:\/\/maximoconcepts.com\/#\/schema\/person\/2a0ce61af426d0c4038aeaa51cb0f98b"},"articleSection":["Configuration","Technical"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/","url":"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/","name":"How to detect and resolve database connection leak? - Maximo Concepts","isPartOf":{"@id":"https:\/\/maximoconcepts.com\/#website"},"datePublished":"2015-08-23T05:46:25+00:00","dateModified":"2015-08-23T05:46:25+00:00","breadcrumb":{"@id":"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/maximoconcepts.com\/2015\/08\/23\/how-to-detect-and-resolve-database-connection-leak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/maximoconcepts.com\/"},{"@type":"ListItem","position":2,"name":"How to detect and resolve database connection leak?"}]},{"@type":"WebSite","@id":"https:\/\/maximoconcepts.com\/#website","url":"https:\/\/maximoconcepts.com\/","name":"Maximo Concepts","description":"Concepts Simplified.","publisher":{"@id":"https:\/\/maximoconcepts.com\/#\/schema\/person\/2a0ce61af426d0c4038aeaa51cb0f98b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/maximoconcepts.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/maximoconcepts.com\/#\/schema\/person\/2a0ce61af426d0c4038aeaa51cb0f98b","name":"Pranjal","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/maximoconcepts.com\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/maximoconcepts.com\/wp-content\/uploads\/2015\/08\/dscn4443-2.jpg?fit=516%2C520&ssl=1","contentUrl":"https:\/\/i0.wp.com\/maximoconcepts.com\/wp-content\/uploads\/2015\/08\/dscn4443-2.jpg?fit=516%2C520&ssl=1","width":516,"height":520,"caption":"Pranjal"},"logo":{"@id":"https:\/\/maximoconcepts.com\/#\/schema\/person\/image\/"},"url":"https:\/\/maximoconcepts.com\/author\/pranjal\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/maximoconcepts.com\/wp-json\/wp\/v2\/posts\/114"}],"collection":[{"href":"https:\/\/maximoconcepts.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maximoconcepts.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maximoconcepts.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/maximoconcepts.com\/wp-json\/wp\/v2\/comments?post=114"}],"version-history":[{"count":0,"href":"https:\/\/maximoconcepts.com\/wp-json\/wp\/v2\/posts\/114\/revisions"}],"wp:attachment":[{"href":"https:\/\/maximoconcepts.com\/wp-json\/wp\/v2\/media?parent=114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maximoconcepts.com\/wp-json\/wp\/v2\/categories?post=114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maximoconcepts.com\/wp-json\/wp\/v2\/tags?post=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}