we use a two-step approach to get this information.
After all data has been backed up and migrated to tape
we check the contents of this tapes.
1) Get a list of tapes used during the last backup.
You should change the start and end time and the names of the
tape storage pools.
2) Scan this tapes for files bigger then x bytes.
You should call skript 2 for every tape listed by skript 1.
Parameter 1: volume number
Parameter 2: Filesize in Bytes
select volume_name as Volume,last_write_date -
from volumes where -
last_write_date > timestamp(date(current_date-1 day),'19:00:00') and -
last_write_date < timestamp(date(current_date),'10:00:00') and -
stgpool_name in ('TAPEPOOL','TAPEPOOL2','TAPE_TDP')
select node_name as Node, -
filespace_name as Filespace,-
file_name as Filename,-
file_size as Size -
from contents -
where volume_name='$1' and -
Hope this helps
Von: Coats, Jack [mailto:Jack.Coats AT BANKSTERLING DOT COM]
Gesendet: Mittwoch, 28. April 2004 19:08
An: ADSM-L AT VM.MARIST DOT EDU
I have a problem. I would like to find where some 'extra large' files are
coming from, like what machine, and possibly the path/name.
I notice sometimes in doing a migration etc, that there is a file of over
35G in size. I would like to find any culprets over say, 20G
in round numbers or so.
Any suggested SQL query or other thing I could use to help find the
( Win2K server with TSM 22.214.171.124 and clients from Novell 4.11, AIX 4.3 to
TIA ... Jack