sreda, 22. januar 2014

Monitor DB2 rollback progress

If you have a large transaction that is in rollback status and you want to know how much of the work is rollbacked then you can use this:
- get AGENT ID for the connection that is in rollback status (db2 list applications show detail)
- run db2 get snapshot for application agentid YOUR_AGENT_ID | grep Work

Ni komentarjev: