More reporting problems or something else?

Server TSM 5.1.5.2
Client TSM 5.1.5.4

Here is a strange phenomenon. Don't ask me why I say that when these days it
seems we all have em. The client is a Domino server with exclusions for the
nsf files, which is working. However it looks like when running this query
it comes back with some interesting numbers. I've run this on a few of our
other Domino clients, all running the same client level as this one and
these do not have any reporting problem.

The other interesting number is the elapsed time. There is quite a
difference in these. Hopefully when the 5.1.6.1 fix comes out I can move up
and all these reporting problems will go away.

>From the server activity log:
01/08/03 19:37:22     ANE4952I (Session: 110663, Node: CP-ITS-DOMWEB01)
Total
                       number of objects inspected:   21,858

01/08/03 19:37:22     ANE4954I (Session: 110663, Node: CP-ITS-DOMWEB01)
Total
                       number of objects backed up:    2,367

01/08/03 19:37:22     ANE4958I (Session: 110663, Node: CP-ITS-DOMWEB01)
Total
                       number of objects updated:          0

01/08/03 19:37:22     ANE4960I (Session: 110663, Node: CP-ITS-DOMWEB01)
Total
                       number of objects rebound:          0

01/08/03 19:37:22     ANE4957I (Session: 110663, Node: CP-ITS-DOMWEB01)
Total
                       number of objects deleted:          0

01/08/03 19:37:22     ANE4970I (Session: 110663, Node: CP-ITS-DOMWEB01)
Total
                       number of objects expired:      2,324

01/08/03 19:37:22     ANE4959I (Session: 110663, Node: CP-ITS-DOMWEB01)
Total
                       number of objects failed:           0

01/08/03 19:37:22     ANE4961I (Session: 110663, Node: CP-ITS-DOMWEB01)
Total
                       number of bytes transferred:  2.28 GB

01/08/03 19:37:22     ANE4963I (Session: 110663, Node: CP-ITS-DOMWEB01)
Data
                       transfer time:                   58.50 sec

01/08/03 19:37:22     ANE4966I (Session: 110663, Node: CP-ITS-DOMWEB01)
Network
                       data transfer rate:        40,981.27 KB/sec

01/08/03 19:37:22     ANE4967I (Session: 110663, Node: CP-ITS-DOMWEB01)

                       Aggregate data transfer rate:        414.79 KB/sec

01/08/03 19:37:22     ANE4968I (Session: 110663, Node: CP-ITS-DOMWEB01)
Objects
                       compressed by:                   53%%

01/08/03 19:37:22     ANE4964I (Session: 110663, Node: CP-ITS-DOMWEB01)
Elapsed
                       processing time:            01:36:20




>From this query:
/************************************************/
/* Script that reports all the objects that are */
/* backed up for a node X                       */
/* The X parameter that has to be given is the  */
/* nodename                                     */
/************************************************/
set sqlmathmode round
set sqldatetimeformat usa
select substr(cast(avg(end_time-start_time) as varchar(17)),3,8) as elapsed,
-
    cast(avg(affected) as decimal(7,0)) as "Avg Obj", -
  case -
    when avg(bytes) > 1073741824 then -
         cast(cast(avg(bytes)/1073741824 as decimal(7,3)) as varchar(24))||'
Gb' -
    when avg(bytes) > 1048576 then -
         cast(cast(avg(bytes)/1048576 as decimal(7,3)) as varchar(24))||'
Mb' -
    when avg(bytes) > 1024 then -
         cast(cast(avg(bytes)/1024 as decimal(7,3)) as varchar(24))||' Kb' -
    else cast(cast(avg(bytes) as decimal(7,3)) as varchar(24)) -
  end as "Avg Bytes" -
  from summary -
  where activity='BACKUP' and -
     entity=upper('$1') and -
     successful='YES'


ELAPSED                 Avg Obj     Avg Bytes
-----------------     ---------     ------------------
04:51:43                   3596     53.210 Gb

Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:    <mailto:gillg AT saic DOT com> gillg AT saic DOT com
Phone:  (858) 826-4062
Pager:   (877) 905-7154