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
history programs sometime in the future. You can have it if you want it.
Matt
-----Original Message-----
From: Bill Robb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 7:22 PM
To: [EMAIL PROTECTED]
Subject: SQL for Amount Backed up Daily:
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 backup sessions
per day.
I'm new to SQL, and have been trying to write the command that will show me
the amount backed up, in MB per day, per client. My problem is that my
command only shows me the amount from the last session, not the last 24
hours.
Has anyone ever succeeded at writing such a command?
Thanks.
Bill Robb
