Another option that may quickly give you some rough information is query filespace.
A spreadsheet with filespace size times percentage full for the pertinent filespaces will give you an estimate of the data involved. This depends also on backup excludes that may be involved. Bob. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Shawn Drew Sent: Friday, April 27, 2012 11:10 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Size of actice data pool ? You can run a preview on the "copy activedata" command.(i.e. copy active data xxx xxxx preview=yes) This should tell you what you want to know. Regards, Shawn ________________________________________________ Shawn Drew Internet guenther_bergm...@gbergmann.de Sent by: ADSM-L@VM.MARIST.EDU 04/27/2012 11:35 AM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject [ADSM-L] Size of actice data pool ? Hi all, given the following setup: TSM 5.5 Primary storage pool of device class FILE Copy ool on LTO -tapes, managed by DRM Primary pool ist copied daily to the copy pool Since the Copy pool is reaching some limitations ( # of tapes, vault capacity) we are thinking about setting up an active data pool and copying the active data pool to the copy pool. The question: How to estimate the size of the active data pool in compared to the primary pool? Is there something like: QUERY OCCUPANCY ACTIVEDATAONLY=YES ? Can it be done with some SQL query? I can geht the numbers (active/inactive) from the backups table, but it does not give the size of the backed up objects. Any hints on this? regards Günther -- Guenther Bergmann, Am Kreuzacker 10, 63150 Heusenstamm, Germany Guenther_Bergmann at gbergmann dot de This message and any attachments (the "message") is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. Please note that certain functions and services for BNP Paribas may be performed by BNP Paribas RCC, Inc. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.