ADSM-L

Difference output between table summary and actlog

2003-08-03 03:52:04
Subject: Difference output between table summary and actlog
From: Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sun, 3 Aug 2003 10:46:52 +0200
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

<Prev in Thread] Current Thread [Next in Thread>