Re: Need help with select command

[Mark D. Rodriguez]

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
===

Re: Need help with select command

[Stapleton, Mark]

From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On 
Behalf Of Karla Ross
>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'

Check the archives in search.adsm.org. This subject has been discussed
thoroughly in the last year. Why exactly do you need this information,
anyway? 

(If you get a select statement that works, be prepared to have it take
hours if not days to run, with a *lot* of database activity.)

--
Mark Stapleton ([EMAIL PROTECTED])
Berbee Information Networks
Office 262.521.5627  

Need help with select command

[Karla Ross]

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'