I found the following query to check the db backup throughput
select activity, ((bytes/1048576)/cast((end_time - start_time) seconds as decimal(18,13))*3600) "MB/Hr" from summary where activity='FULL_DBBACKUP' and days(end_time) - days(start_time)=0
Under tsm v 6 I am getting
ANR0162W Supplemental database diagnostic information: -1:42911:-419 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0419N A decimal divide operation is not valid because the result would
have a negative scale. SQLSTATE=42911
Any suggestion on either fixing it or another query to check the throughput will be appreciated.
Thank you
Al
select activity, ((bytes/1048576)/cast((end_time - start_time) seconds as decimal(18,13))*3600) "MB/Hr" from summary where activity='FULL_DBBACKUP' and days(end_time) - days(start_time)=0
Under tsm v 6 I am getting
ANR0162W Supplemental database diagnostic information: -1:42911:-419 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0419N A decimal divide operation is not valid because the result would
have a negative scale. SQLSTATE=42911
Any suggestion on either fixing it or another query to check the throughput will be appreciated.
Thank you
Al