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