Hi Eric,

we use the following steps to identify large files in last nights
backup:

Step 1 - Query the volumes used in last nights backup

select volume_name as Volume, stgpool_name as Stgpool,
date(last_write_date) as "Date", - 
time(last_write_date) as "Time" 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 (select stgpool_name from stgpools where
pooltype='PRIMARY')

Step 2 - List all files on volumes returned by Step 1 > x Bytes

select node_name as Node, -
filespace_name as Filespace,-
file_name as Filename,-
file_size as Size -
from contents -
where volume_name='$1' and -
file_size>$2

Or we list the number of files and summarized size per node of a volume.
So you see nodes with a small number of files but lots of gigas backed
up:

select node_name as Node, -
filespace_name as Filespace,-
count(file_name) as Files,-
sum(file_size) as Size -
from contents -
where volume_name='$1' -
group by node_name, filespace_name -
order by files desc

HTH
Thomas Rupp
Vorarlberger Illwerke Aktiengesellschaft ein Unternehmen von illwerke vkw
Rechtsform: Aktiengesellschaft, Sitz: Bregenz, Firmenbuchnummer: FN 59202m
Firmenbuchgericht: LG Feldkirch, DVR 0008753, UID-Nr.: ATU 36737402

Vorarlberger Kraftwerke Aktiengesellschaft ein Unternehmen von illwerke vkw
Rechtsform: Aktiengesellschaft, Sitz: Bregenz, Firmenbuchnummer: FN58920y
Firmenbuchgericht: LG Feldkirch, DVR 0027961, UID-Nr.: ATU 36737304