Hello,
> I'm looking for a query or sql script that allow me to see what volumes I'll
> need for a restore process. I want to see the volumes before the starting of
> the process.
If your question is concerning nodes you can try to implement the following actions.
We perform this by program in a p
>I'm looking for a query or sql script that allow me to see what volumes I'll
>need for a restore process. ...
This is a frequently asked question. The short answer is that there is no
way for you to obtain such a list.
See topic "Restoral preview" in http://people.bu.edu/rbs/ADSM.QuickFacts
for
Here is what you will need
select distinct node_name,volume_name,stgpool_name
from volumeusage
where node_name='x'
L PROTECTED]
Subject: Re: RESTORE VOLUMES
Gary,
Not SQL, just SQL Queries. It's a much smaller knowledge set. Also, I
agree with the recommendation for learning some kind of scripting language.
Perl, shell script, C. Or VB or Windows Scripting Host. Anything
you can use to automate
eping up on the industry, or, my favorite, golf.
Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail
-Original Message-
From: Gary Swanton [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:43 AM
To: [EMAIL PROTECTED]
Subject: Re: RESTORE VOLUMES
: Friday, 15 February 2002 4:13 AM
To: [EMAIL PROTECTED]
Subject: Re: RESTORE VOLUMES
Hi Garry
CStringArray is a class in MFC (You shlould use ODBC
to connect TSM tables and a Programming language)
If you DO not use C++ or something like it. You have
to use some script editor (PERL...)
I use Norton Dos
Regards
>
> Gary
>
> -Original Message-
> From: ADSM: Dist Stor Manager
> [mailto:[EMAIL PROTECTED]] On Behalf Of
> Michel David
> Sent: Wednesday, 13 February 2002 8:21 PM
> To: [EMAIL PROTECTED]
> Subject: Re: RESTORE VOLUMES
>
> It's possible
>
Gary -
you can get the volume names for the volumeusage table.
Here is a macro to do the select; cut and paste the macro to a file,
then in dsmadmc enter
macro file_name 'NODE_NAME' = 'filespace_name'. The output
will be in the file c:\tsmvolumes.txt.
Hope this helps.
/*
you could try " show voluse " where is the nodename of the client
you want to restore. this would however, tell you every tape that this
client has data on. Which would be more then what you are looking for and
it sounds like you are not using co-location so your list would be quite
larg
Gary,
I understand your frustration at starting out, but the SQL command for this
request is not difficult and has been answered on this list a number of
times. It is difficult to pull that information out with all the activity
and matches that you get, however, so feel free to ask such question
: Wednesday, 13 February 2002 8:21 PM
To: [EMAIL PROTECTED]
Subject: Re: RESTORE VOLUMES
It's possible
Take a look at the ARCHIVES and essentially CONTENTS
table
1) select * from contents where volume_name='vol1'
You will get everything in the volume vol1.
2) Save the info (fil
It's possible
Take a look at the ARCHIVES and essentially CONTENTS
table
1) select * from contents where volume_name='vol1'
You will get everything in the volume vol1.
2) Save the info (file_name) in some CStringArray
3) Sort your info to restore according to the volumes
Good luck.
Michel
--- G
12 matches
Mail list logo
