Just a guess, but see if end_time = start_time.  That would cause a divide by 
zero situation.

At 02:12 PM 2/9/2011, Lee, Gary D. wrote:
>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
>
>


--
Paul Zarnowski                            Ph: 607-255-4757
Manager, Storage Services                 Fx: 607-255-8521
719 Rhodes Hall, Ithaca, NY 14853-3801    Em: psz1 AT cornell DOT edu