Re: Restore performance W2K file-server-sql query

Hello John,

Here are sql statements which might be helpful to you.  One catch is these
query display both an active and inactive.

List all the volumes for a given node name and filespace
select node_name, volume_name, stgpool_name from volumeusage where
node_name='ClientName' and filespace_name=='filespacename'

List all the volumes for a give node name
select node_name, volume_name, stgpool_name from volumeusage where
node_name='ClientName'


Sung Y. Lee
E-mail  sunglee AT us.ibm DOT com



                      J M
                      <jm_seattle@HOTMA        To:       ADSM-L AT VM.MARIST 
DOT EDU
                      IL.COM>                  cc:
                      Sent by: "ADSM:          Subject:  Re: Restore 
performance W2K file-server-sql query
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      01/13/2003 02:36
                      PM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






In measuring restore performance, or developing estimates, does anyone have
a SQL Query to show the volumes required to restore all active data for a
client or filespace? This could be useful in developing DR SLA's, building
policies, storage pool design, etc.

Many Thanks,

John






>From: brian welsh <brianwelsh3 AT HOTMAIL DOT COM>
>Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>To: ADSM-L AT VM.MARIST DOT EDU
>Subject: Restore performance W2K file-server
>Date: Mon, 13 Jan 2003 20:31:48 +0100
>
>Hello,
>
>TSM server 4.2.2.8 and AIX 5.1, client Windows 2000 Server SP3 and TSM
>client 5.1, long directorypaths, a lot of (little) files, about 800 GB.
>
>I was wondering how other sites are handling big W2K file servers in case
>of
>a full-restore.
>
>Client 5.1 can use multiple restore sessions, so that's a pro.
>Maybe a seperate DIRMC to restore directories first and then files, or
>something like that?
>Parameters in the dsm.opt?
>
>Everything is welcome.
>
>Thanks,
>
>Brian.
>
>
>
>
>_________________________________________________________________
>Ontvang je Hotmail & Messenger berichten op je mobiele telefoon met
Hotmail
>SMS http://www.msn.nl/jumppage/


_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail