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