Re: (select volume

Jeff -

The volume_usage table can be queried with sql.  You don't
need to use the unsupported show command.  Try this macro -

/*                                              */
/* macro file to select the volumes that a node */
/* is stored on.                                */
/*                                              */
set sqldatetimeformat i
set sqldisplaymode w
set sqlmathmode r
commit
select distinct 'DATA', copy_type, left(node_name,16), left(volume_name,16), -
                left(stgpool_name,16) -
   from adsm.volumeusage  -
   where node_name = %1 -
     and copy_type in ('BACKUP', 'ARCHIVE') -
     and filespace_name %2 %3 -
     > e:\adsmcv3\sqllists\voluse3

If you cut and paste it to file c:\voluse then run it in dsmadmc like this -

For all filespaces enter: macro c:\voluse 'NODENAME' like '%'
For a specific filespace enter: macro c:\voluse 'NODENAME' = 'filespacename'

Hope this helps,

--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <16E0F6604574D311BFE100902745F0A80A3C3221 AT honts330.homeoffice.wal-mart 
DOT com>, on 09/20/01
In <16E0F6604574D311BFE100902745F0A80A3C3221 AT honts330.homeoffice.wal-mart 
DOT com>, on 09/20/01
   at 11:11 AM, Jeff Bach <jdbach AT WAL-MART DOT COM> said:

>All,

>        I need some quick help,   I need the show command that shows all
>tapes that contain data for a particular node.

>        Can anyone help?
>Jeff Bach
>Home Office Open Systems Engineering
>Wal-Mart Stores, Inc.

>WAL-MART CONFIDENTIAL



>**********************************************************************
>This email and any files transmitted with it are confidential
>and intended solely for the individual or entity to
>whom they are addressed.  If you have received this email
>in error destroy it immediately.
>**********************************************************************
Re: (select volume_usage)
