On Thu, Jun 13, 2002 at 11:33:14AM -0400, Prather, Wanda wrote: >> Is there a SELECT statement that can show me the (total) size of all active >> files? > If any of your clients are doing compression, the values you get from > OCCUPANCY are irrelevant. > There is no place in TSM to query the original file size.
All of our clients use compression, but I don't care how much the files are when they are on the client, I just care how much data I have to lift of tape and send over the network. I guess OCCUPANCY is giving me okay numbers, but from a short look at the table it looks like I have to use some other tables, but which? -- Best Regards Emil S. Hansen - [EMAIL PROTECTED] - ESH14-DK UNIX Administrator, Berlingske IT - www.bit.dk PGP: 109375FA/ABEB 1EFA A764 529E 82B5 0943 AD3B 1FC2 1093 75FA "tjaa men ville disse lister ikke være kedelige hvis vi altid gav hinanden ret med det samme :o)" - Kim Schulz på SSLUG.PROG
msg26740/pgp00000.pgp
Description: PGP signature
