Tuesday, December 30, 2014

monitor DB2 reorg with db2pd + awk

If you want to monitor the progress of reorgs running in db2, you can use the following command:

db2pd -db tmdb -reorgs | awk '$5=="n/a"&&$4!="n/a" {print $2 " : " $9/$10*100 " %"}'

output is:

TABLENAME : Percentage complete %


No comments:

Post a Comment