Offhand I can't say what the problem is, but it might not hurt to take a
look at the individual SUMMARY table records that pertain to full database
backups. That might lend a clue:

select date(start_time) as "START DATE", -
   time(start_time) as "START TIME", -
   date(end_time) as "END DATE", -
   time(end_time) as "END TIME", -
   bytes -
   from summary -
   where activity='FULL_DBBACKUP'

Then look at those entries pertaining to your time criteria, and see what
they show.

Regards,

Andy

Andy Raibeck
IBM Tivoli Systems
Tivoli Storage Manager Client Development
e-mail: araibeck AT tivoli DOT com
"The only dumb question is the one that goes unasked."
"The command line is your friend"

Hy this is what my script looks like:

set sqlmathmode round
select count(*) as "process", -
case -
when sum(bytes) > 1073741824 then -
cast(sum(bytes)/1073741824 as varchar(24))||'Gb' -
when sum(bytes) > 1048576 then -
cast(sum(bytes)/1048576 as varchar(24))||'Mb' -
when sum(bytes) > 1024 then -
cast(sum(bytes)/1024 as varchar(24))||'Kb' -
else cast(sum(bytes) as varchar(24)) -
end as "Num Bytes", -
activity as "(17h till 17h)act." -
from summary -
where (date(start_time) = current date - 1 day -
and time(start_time) > '17:00') -
or -
(date(start_time) = current date -
and time(start_time) < '17:00') -
group by activity

any ideas yet?