Hi to all
Run this everyday to collect the amount of MB and length of backup nodes.
SELECT ENTITY AS NODE, -
CAST(SUM(BYTES/1024/1024) -
AS DECIMAL(8,2)) AS "MB", -
substr(cast(min(start_time) as char(26)),1,19) as "DATETIME
", -
cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as
char(8)) as "Length " -
FROM SUMMARY -
WHERE ACTIVITY IN ('BACKUP','ARCHIVE') -
and date(Start_time)=current date - 1 days and
time(start_time)>'08:00:00' -
GROUP BY ENTITY -
ORDER BY MB
Here the result:
NODE MB DATETIME
Length
------------------ ---------- ----------------------------------
---------
HIGHLEARN 0.00 2003-07-18 23:00:01
01:12:20
MARVEL 0.00 2003-07-18 18:00:28
00:15:05
NOVMESHEK 0.00 2003-07-18 23:30:13
00:12:06
NOVMINHAL 0.00 2003-07-18 23:50:03
00:26:27
WEB2000 0.00 2003-07-18 23:00:07
00:11:31
NSNEW 854.37 2003-07-18 21:36:02
00:05:01
NOVNDPS 1265.54 2003-07-18 23:30:14
00:15:59
When i run a q actlog begint=-15 s=marvel I got:
07/18/2003 18:15:33 ANE4952I (Session: 250, Node: MARVEL) Total number of
objects inspected: 65,911
07/18/2003 18:15:33 ANE4954I (Session: 250, Node: MARVEL) Total number of
objects backed up: 45
07/18/2003 18:15:33 ANE4958I (Session: 250, Node: MARVEL) Total number of
objects updated: 0
07/18/2003 18:15:33 ANE4960I (Session: 250, Node: MARVEL) Total number of
objects rebound: 0
07/18/2003 18:15:33 ANE4957I (Session: 250, Node: MARVEL) Total number of
objects deleted: 0
07/18/2003 18:15:33 ANE4970I (Session: 250, Node: MARVEL) Total number of
objects expired: 4
07/18/2003 18:15:33 ANE4959I (Session: 250, Node: MARVEL) Total number of
objects failed: 2
07/18/2003 18:15:33 ANE4961I (Session: 250, Node: MARVEL) Total number of
bytes transferred: 1.25 GB
07/18/2003 18:15:33 ANE4963I (Session: 250, Node: MARVEL) Data transfer
time:
620.25 sec
07/18/2003 18:15:33 ANE4964I (Session: 250, Node: MARVEL) Elapsed
processing
time: 00:15:03
As you see the total number of bytes transferred is: 1.25G and on my
select command from summary I got 0:00 .
The elapsed processing time is correct on the select command.
My TSM Server version is 5.1.7.0
Can someone advise why the difference between the tables summary and actlog
??????????
Thanks in Advance .......
Regards
Robert Ouzen
Haifa University
Israel
E-mail: <mailto:rouzen AT univ.haifa.ac DOT il> rouzen AT univ.haifa.ac DOT il
|