Re: restore volumes list. It's possible??

2004-03-25 Thread Christian Bagard
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

restore volumes list. It's possible??

2004-03-24 Thread Jose Antonio Atala Olaechea
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

Re: restore volumes list. It's possible??

2004-03-24 Thread James Lepre
Here is what you will need select distinct node_name,volume_name,stgpool_name from volumeusage where node_name='x'

Re: restore volumes list. It's possible??

2004-03-24 Thread Richard Sims
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: other suggestions: a real answer to your que stion

2002-02-17 Thread Seay, Paul
: 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

Re: RESTORE VOLUMES

2002-02-15 Thread Gary Swanton
: 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

Re: RESTORE VOLUMES

2002-02-15 Thread Alex Paschal
, 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

Re: RESTORE VOLUMES

2002-02-14 Thread Michel David
:[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

Re: RESTORE VOLUMES

2002-02-13 Thread Michel David
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 ---

Re: RESTORE VOLUMES

2002-02-13 Thread Gary Swanton
: 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

Re: RESTORE VOLUMES

2002-02-13 Thread Bill Smoldt
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

Re: RESTORE VOLUMES

2002-02-13 Thread James Healy
. 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

Re: RESTORE VOLUMES

2002-02-13 Thread William F. Colwell
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. /*