Using SQL to help identify ASP.NET orphan IBM i jobs
This article provides a potential way to identify orphan IBM i jobs as a result of Database connection leaks in ASP.NET Web applications. We’ve written before about the perils of orphan IBM i jobs before. This article and video discusses a potential way to identify orphan IBM i jobs and this older article also discusses techniques for avoiding orphan jobs. This article provides some diagnostic help locating the cause of orphan jobs. Orphan jobs are challenging to identify. In a large system with many users, it’s possible that you have some orphan jobs and don’t know it–and don’t care. However, it’s also possible that the occasional orphan job could cause intermittent, hard-to-find problems. […]
