Hi Gary,

in v6 expiration puts a row in the summary table for every node, plus a
summary
row for the whole process.  Here is output from a script which displays
rows from summary.
As you can see, some of the elapsed times are 0 -

Activity     Target           Start Time      End Time        Elapsed
(hh:mm:ss)    Gigs   Examined    Affected
------------ -------------    ------------    ------------
------------------- ------  ---------   ---------
EXPIRATION   node1            02-09-07.21     02-09-07.21     00:00:07
0.00        111         111
EXPIRATION   node2            02-09-07.21     02-09-07.21     00:00:07
0.00        145         145
EXPIRATION   node3            02-09-07.21     02-09-07.53     00:32:11
0.00     129775      129775
EXPIRATION                    02-09-07.21     02-09-07.53     00:32:11
0.00     129775      129775
EXPIRATION   node4            02-09-07.21     02-09-07.22     00:01:04
0.00       3164        3164
EXPIRATION   node5            02-09-07.21     02-09-07.26     00:05:50
0.00      22557       22557
EXPIRATION   node6            02-09-07.21     02-09-07.21     00:00:00
0.00        145         145
EXPIRATION   node7            02-09-07.21     02-09-07.21     00:00:08
0.00        387         387
EXPIRATION   node8            02-09-07.21     02-09-07.21     00:00:09
0.00        522         522
EXPIRATION   node9            02-09-07.21     02-09-07.21     00:00:00
0.00        387         387


To select the summary row add 'and entity is null' to the where clause.


Best regards,

Bill Colwell
Draper Lab



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lee, Gary D.
Sent: Wednesday, February 09, 2011 2:12 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Tsm 6.22 server script problem.

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