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
Hi TSM Friends.
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.
Likewise I need a query or script that allow me to see what volumes I'll
need for a backup stgpool process. When I
Here is what you will need
select distinct node_name,volume_name,stgpool_name
from volumeusage
where node_name='x'
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
: 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 shudder VB or Windows Scripting Host. Anything
you can use to automate your job creates time
: 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
,
keeping 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
:[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
Take a look at the ARCHIVES and essentially CONTENTS
table
1) select * from contents where volume_name='vol1'
You will get everything
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
---
: 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 (file_name) in some
Sent: Wednesday, February 13, 2002 2:02 AM
To: [EMAIL PROTECTED]
Subject: RESTORE VOLUMES
Hi All,
I am quite new to all things TSM and I have a question
to what I believe is an unrealistic situation.
Presently if, during my role as the TSM administrator I am asked to
perform
.
Gary Swanton [EMAIL PROTECTED]@VM.MARIST.EDU on 02/13/2002
04:01:39 AM
Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: RESTORE VOLUMES
use
Hi All,
I am quite new to all
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.
/*
13 matches
Mail list logo