ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Vantage DB2 threads remain active in DB2


Article ID: 213875


Updated On:


Vantage Storage Resource Manager


When using the CA Vantage for IBM DB2, it can happen that some of the CA Vantage DB2 threads are left un-closed. The result is that there are long DB2 threads still running with DB2 plan VANDB2RM and they need to be cancelled outside of CA Vantage.

How to fix this bug? 


Release : 14.0

Component : CA Vantage Storage Resource Manager


To remove this bug the Labs provided the test APAR LT01004.

This SYSMOD adds the SQL COMMIT statement, and ensures that the DB2 threads are closed.