I ported the following script from my tsm server v5.5.4  to the 6.2.2 server.
Wanted to compare expiration performance between the two servers.
However, script errors out with the following message.
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
).


------------ script follows ----------------


select activity, cast ((end_time) as date) as "Date", -
(examined/cast ((end_time-start_time) seconds as decimal (18,13)) *3600) -
"Objects Examined Up/Hr" from summary where -
activity='EXPIRATION' and days (end_time) -days (start_time)=0


Thanks for any help.



Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

 

Reply via email to