ADSM-L

Inconsistency between summary and actlog

2004-01-14 05:51:44
Subject: Inconsistency between summary and actlog
From: Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 14 Jan 2004 12:36:17 +0200
Hello to everyone

Run every day a script to collect the amount and time for clients backup as:

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 current date - 1 days = date(Start_time) and
time(start_time)>'18:00:00' -
   GROUP BY ENTITY -
   ORDER BY MB

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 current date  = date(Start_time) and time(end_time)<'08:00:00' -
   GROUP BY ENTITY -
   ORDER BY MB

The OUTPUT look like:

NODE                        MB             DATETIME
Length
------------------      ----------        ----------------------------------
---------
HIGHLEARN2K            2766.09     2004-01-13 22:30:06
00:10:30
EXCHANGE1             57807.11     2004-01-13 22:07:16
01:38:54

NODE                        MB           DATETIME
Length
------------------   ----------          ----------------------------------
---------
WEB2000_DB                0.13      2004-01-14 03:30:07
00:00:23
EXCHANGE2             23187.05    2004-01-14 01:08:48
00:38:03

This script give almost all my clients but a few are missing but when
running a query actlog the client missing as an output:

01/13/2004 23:04:02  ANE4952I (Session: 23, Node: IBROWSE2)  Total number of
                      objects inspected:   17,827
01/13/2004 23:04:02  ANE4954I (Session: 23, Node: IBROWSE2)  Total number of
                      objects backed up:       67
01/13/2004 23:04:02  ANE4958I (Session: 23, Node: IBROWSE2)  Total number of
                      objects updated:          0
01/13/2004 23:04:02  ANE4960I (Session: 23, Node: IBROWSE2)  Total number of
                      objects rebound:          0
01/13/2004 23:04:02  ANE4957I (Session: 23, Node: IBROWSE2)  Total number of
                      objects deleted:          0
01/13/2004 23:04:02  ANE4970I (Session: 23, Node: IBROWSE2)  Total number of
                      objects expired:          1
01/13/2004 23:04:02  ANE4959I (Session: 23, Node: IBROWSE2)  Total number of
                      objects failed:           0
01/13/2004 23:04:02  ANE4961I (Session: 23, Node: IBROWSE2)  Total number of
                      bytes transferred:     1.07 GB

The node IBROWSE2 is not shown in my summary query ???????

Why is a difference between summary table to actlog table ????????????

Can I run something else to give me a correct result !!!!!!!
Tsm Server version 5.1.8.0 on Windows2000 , Tsm client  version 5.2.2.0

Regards Robert Ouzen
E-mail: rouzen AT univ.haifa.ac DOT il