Karla Ross wrote:

I am trying to find the tapes needed to recover only the "active" backups
of a client.  I used the following select command and it gives me a list of
all tapes for all backups of that client.  How can I narrow the search to
just "active" backups?

select volume_name,filespace_name from volumeusage where -
node_name='CLIENT NAME' and stgpool_name='STGPOOL'

Hi,

I am sure I could write one for you but before I do that do you realize
that this will be a massive DB search and suck up a lot of CPU, Memory
and I/O cycles to do this.  This will be a massive search especially if
you have a large number of nodes with a large number of files.  The info
you need is spread across to different tables, contents and backups, so
you will have to generate a list of the active files from the backups
table and then search the contents table for matching volumes.  This is
doable but it will take a long time to run and use  lots of resources.

Are you still interested?

--
Regards,
Mark D. Rodriguez
President MDR Consulting, Inc.

===============================================================================
MDR Consulting
The very best in Technical Training and Consulting.
IBM Advanced Business Partner
SAIR Linux and GNU Authorized Center for Education
IBM Certified Advanced Technical Expert, CATE
AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux
Red Hat Certified Engineer, RHCE
===============================================================================