DB2 Tips n Tricks Part 31 – Find Which Application is consuming most log space

How to Find Which Application is consuming most transaction log space

Solution:
db2pd -db dbname -transactions
db2 get snapshot for applications on test|grep -i -e “Application handle” -e “UOW log space used”