Re: restore times
1999-03-17 16:57:33
A better select statement to list the volumes a node is on without
getting duplicates for each filespace is --
/* */
/* macro file to select the volumes that a node */
/* is stored on. */
/* */
set sqldatetimeformat i
set sqldisplaymode w
set sqlmathmode r
commit
select distinct volume_name -
from adsm.volumeusage -
where stgpool_name = '9840APOOL' -
and node_name = %1 -
> e:\adsmcv3\sqllists\voluse3
To run this, store it as a fill in the directory where dsmadmc is,
and then enter "macro <filename> 'NODENAME_IN_CAPS' ".
Then edit the output file \voluse3. Adjust the redirection name
as necessary.
To comment on the thread in general, a Consolidate command would be
a good thing to have. I submitted a SHARE requirement for one 4 years ago when
I wasn't doing collocation. I have since switched to collocation so there are
other
thing I would like development to do first.
I think there is a lot of misconceptions about collocation and how to implement
it.
It will always buy you something on the restore time, but you pay on the
migration
time. You don't need 1 or more tapes for every node. ADSM will double up,
triple up,
etc. as Wanda pointed out.
--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <01BE707E.1928FF60.sorensen AT storsol DOT com>, on 03/17/99
In <01BE707E.1928FF60.sorensen AT storsol DOT com>, on 03/17/99
at 01:57 PM, "John M. Sorensen" <sorensen AT STORSOL DOT COM> said:
>I do have a comment on the SQL query you used to determine
>how many volumes contain data for any client node. It turns
>out that you may be in much better shape than you think!
>The problem with the query is that the number returned
>in count(*) will count every individual filespace
>from a client node as a separate row.
>Here is an example from my server. Client node MELMARJO is
>a Windows 95 client. It backs up 3 filespaces; APPS, USER
>and WINSYS (I have removed some whitespace from the output
>but the text is untouched). This query returns all columns
>defined for the table, so that the upcoming query returning
>the count(*) can be interpreted.
>adsm> SELECT * FROM VOLUMEUSAGE WHERE NODE_NAME='MELMARJO'
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- FW: restore times, (continued)
- FW: restore times, Hilton Tina
- Re: restore times, Dusedau, Stefan
- Re: restore times, Thomas A. La Porte
- Re: restore times, Prather, Wanda
- Re: restore times, Kelly J. Lipp
- Re: restore times, Mapes, Mark
- Re: restore times, Kelly J. Lipp
- Re: restore times, Joel Fuhrman
- Re: restore times, John M. Sorensen
- Re: restore times, Schauerte, Andrew (NM75)
- Re: restore times,
Bill Colwell <=
- Re: restore times, John M. Sorensen
- Re: restore times, Thomas A. La Porte
- Re: restore times, John M. Sorensen
- Re: restore times, Sheelagh Treweek
- Re: restore times, Herve Chibois
- Re: restore times, Michael Abel
- Re: restore times, Dusedau, Stefan
- Re: restore times, Dusedau, Stefan
- Re: restore times, Prather, Wanda
- Re: restore times, Bill Colwell
|
|
|