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 4.37 2003-07-18 21:36:02
00:02:01
NOVNDPS 5.54 2003-07-18 23:30:14 00:03: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 I got 0:00 .
The elapsed processing time is correct on the select command.
For most of nodes I got the correct output like for example NSNEW:
07/18/2003 21:38:03 ANE4952I (Session: 305, Node: NSNEW) Total number of
objects inspected: 32,539
07/18/2003 21:38:03 ANE4954I (Session: 305, Node: NSNEW) Total number of
objects backed up: 79
07/18/2003 21:38:03 ANE4958I (Session: 305, Node: NSNEW) Total number of
objects updated: 0
07/18/2003 21:38:03 ANE4960I (Session: 305, Node: NSNEW) Total number of
objects rebound: 0
07/18/2003 21:38:03 ANE4957I (Session: 305, Node: NSNEW) Total number of
objects deleted: 0
07/18/2003 21:38:03 ANE4970I (Session: 305, Node: NSNEW) Total number of
objects expired: 1
07/18/2003 21:38:03 ANE4959I (Session: 305, Node: NSNEW) Total number of
objects failed: 0
07/18/2003 21:38:03 ANE4961I (Session: 305, Node: NSNEW) Total number of
bytes transferred: 4.37 MB
07/18/2003 21:38:03 ANE4963I (Session: 305, Node: NSNEW) Data transfer
time:
4.55 sec
07/18/2003 21:38:03 ANE4966I (Session: 305, Node: NSNEW) Network data
transfer rate: 983.95 KB/sec
07/18/2003 21:38:03 ANE4967I (Session: 305, Node: NSNEW) Aggregate data
transfer rate: 37.14 KB/sec
07/18/2003 21:38:03 ANE4968I (Session: 305, Node: NSNEW) Objects
compressed
by: 0%
07/18/2003 21:38:03 ANE4964I (Session: 305, Node: NSNEW) Elapsed
processing
time: 00:02:00
Can someone advise why the difference ??????????
Thanks in Advance .......
Regards
Robert Ouzen
Haifa University
Israel
E-mail: rouzen AT univ.haifa.ac DOT il <mailto:rouzen AT univ.haifa.ac DOT il>
|