Re: [ADSM-L] Tsm 6.22 server script problem.
2011-02-09 14:30:56
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
|
|
|