Hello TSM'ers,

TSM Server 5.5.1.0 on AIX 5.3
3 dual-core processors, 10 GB ram
105 GB database, 23.6% utilized

I have a question about scheduling a database query.

I run a daily query to get the total data archived, and the results
reported do not include the total of all of the data archived.  Last
Sunday a 2.44 TB archive ended at 04:45.  My query ran at 05:39 and
showed 714,412 MB archived.  A query run today of last Sunday's data
shows 2,562,984 MB archived.  It looks like the SUMMARY table is not
updated as quickly as I thought.  Actually, I'd never thought about it -
I thought the summary data would be there instantly.  Does anybody know
how long to wait to get accurate summary data?

Daily scheduled query:
dsmadmc -id=$TSMUSER -password=$TSMPASS "select sum(bytes)/1024/1024 as
MB_per_day from summary where activity='ARCHIVE' and
(current_timestamp-end_time)hours <= 24 hours"

Today's query showing the missing data:
select sum(bytes)/1024/1024 as MB_per_day from summary where
activity='ARCHIVE' and (current_timestamp-end_time)hours >= 48 hours and
(current_timestamp-end_time)hours <= 72 hours and entity='SCSUQORA1'

Daily processing details
Storage pool backups 03:00 - 04:55
Database backups 04:44-04:56 (to file), 05:02-05:34 (to tape)
Expiration 05:36-
Backup summary report 05:39

Thank you,
Jim Schneider