Check the occupancy table for the node, look for type of "Arch", or
something like that. I'm not at a console right now or I'd know the
exact values...

Curtis Stewart
Systems Engineer
StorageTek
curtis_stewart AT storagetek DOT com
 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Stefan Holzwarth
Sent: Monday, August 08, 2005 9:31 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Select for archive size

Hi *SM-ers,

some time ago i setup a dedicated TSM node for archiving of all kind of
data from different users.
Each archive is generated with an (internal) unique ID in the
description field under the same "archive-node". Sometimes the different
archives come from the same filespace because we use a central
networkshare for collection of files to archive.
Now our users should pay for their archives. So i started searching for
an select statement that gives me the size of an single archive (as in
the gui when you estimate retrieve size).

The problem is that the archives table shows no size information and the
dsmc.exe has no estimate retrieve for automation...

Any ideas?

Kind regards
Stefan Holzwarth