Hi,

I would use the following approach:

Find the tape volumes that have been written during last backup or
migration:

select volume_name from volumes where last_write_date >
timestamp('2002-12-06','02:00:00')
  and last_write_date < timestamp('2002-12-06','08:00:00')

This example gives you all the tape volumes that have been written between 2
and 8 o'clock
(ISO date/time format). Use QUERY SQLSESSION to see the format SQL needs.

Now you could scan all those tapes (x, y, z) using

select node_name, filespace_name, file_name from contents where
volume_name='x'
  and file_size>1073741824

You would have to do this for every volume listed by the first select.

I'm not sure if you could combine all found volumes into one select.
Eventually this leads to a 'full table scan' and therefore takes forever
(Any SQL Gurus out there?).

select node_name, filespace_name, file_name from contents where volume_name
in ('x','y','z')
  and file_size>1073741824

These selects take a lot of CPU - so be careful.

Kind regards
Thomas Rupp
Vorarlberger Illwerke AG
Mail:   thomas dot rupp at illwerke dot at






------------------------------------------------------------------------------------------
Dieses eMail wurde auf Viren geprueft.

Vorarlberger Illwerke AG
------------------------------------------------------------------------------------------