Re: Which nodes on a given tape, what maxscr value to use ?
2003-09-05 09:32:12
>Replace $1 with the volume name and this LONG RUNNING query will tell you
>what nodes are on a tape:
>
>select distinct node_name from volumeusage where volume_name='$1'
It may be more expeditious to do 'Query CONtent VolName > os-filename'
and process the report file externally, given the speed of the artificial
SQL layer over the TSM database and that the Query commands are optimized
for the true database. This also provides the opportunity to harvest more
information from the contents spew (number of files, type, filespace, etc.)
without having to perform yet another Select.
Richard Sims, BU
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Which nodes on a given tape, what maxscr value to use ?, Lambelet,Rene,VEVEY,GL-CSC
- Re: Which nodes on a given tape, what maxscr value to use ?, David E Ehresman
- Re: Which nodes on a given tape, what maxscr value to use ?, Jolliff, Dale
- Re: Which nodes on a given tape, what maxscr value to use ?, Lambelet,Rene,VEVEY,GL-CSC
- Re: Which nodes on a given tape, what maxscr value to use ?,
Richard Sims <=
- Re: Which nodes on a given tape, what maxscr value to use ?, Lambelet,Rene,VEVEY,GL-CSC
- Re: Which nodes on a given tape, what maxscr value to use ?, Slaughter, Bill
|
Previous by Date: |
Re: Which nodes on a given tape, what maxscr value to use ?, Lambelet,Rene,VEVEY,GL-CSC |
Next by Date: |
Re: Which nodes on a given tape, what maxscr value to use ?, Lambelet,Rene,VEVEY,GL-CSC |
Previous by Thread: |
Re: Which nodes on a given tape, what maxscr value to use ?, Lambelet,Rene,VEVEY,GL-CSC |
Next by Thread: |
Re: Which nodes on a given tape, what maxscr value to use ?, Lambelet,Rene,VEVEY,GL-CSC |
Indexes: |
[Date]
[Thread]
[Top]
[All Lists] |
|
|