I use this in an Access DB that is linked via ODBC.
SELECT Sum([SUMMARY-NYC].BYTES) AS SumOfBYTES, [SUMMARY-NYC].ENTITY,
First([SUMMARY-NYC].ADDRESS) AS FirstOfADDRESS, Sum([SUMMARY-NYC].FAILED) AS
SumOfFAILED, Min([SUMMARY-NYC].START_TIME) AS MinOfSTART_TIME,
Max([SUMMARY-NYC].END_TIME) AS MaxOf
Bill,
I also run 4.1 on OS390. I have found that activating the
ACCOUNTing records to work the best. I take the SMF records and go through
them with a SAS program. It was pretty quick to write. I run it everyday
and put the summarized records in a SAS DB so I can put together some
hist
On the site www.coderelief.com I published a select statement I use to followup
the amount of data backuped up every night. You can take a look. If you have any
comments feel free to mail me.
Michel Engels
Bill,
I use the following SQL commando to display a nodes backup amount for the last
(and in our case longest possible) backup window.
select substr(entity, 1, 16) as "Node", sum(bytes) #Bytes, sum(examined) -
#Examined from adsm.summary -
where (upper(activity)='BACKUP' and upper(substr(entity,
Consider activating the accounting records feature on your TSM server.
There is a lot of information to be had from the accounting records.
Another alternative would be to look at the SUMMARY table on the TSM
server.
Regards,
Andy
Andy Raibeck
IBM Tivoli Systems
Tivoli Storage Manager Client De
We parse the Activity log and extract the data that way.
(using Perl)
Cheers, Suad
--
On Wed, Apr 18, 2001 at 07:22:09PM -0400, Bill Robb wrote:
> Folks...
>
> I'm running TSM 4.1 on an S390 server, and have 85 clients divided into two domains
>- Novell and AIX. Many of the clients run multiple
