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
