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 product (SOS-Log that we sell only in France, sorry) 
so you'll have to adapt it in SQL (if possible or by script).
Start with : 
select DISTINCT VOLUME_NAME NODE_NAME COPY_TYPE STGPOOL_NAME from  VOLUMEUSAGE

crossing it with POOL_TYPE from STGPOOLS on STGPOOL_NAME

sort by COPY_TYPE of VOLUMUSAGE (BACKUP, ARCHIVE)

then sort the result by NODE_NAME


Be careful, select on volumeusage is sometime very slow

 Likewise I need a query or script that allow me to see what volumes I'll
 need for a backup stgpool process. When I use preview=volumesonly or yes I
 realize not always ask me the volumes that are in the list this command has
 generated. Is there another way to do this?
Maybe something like (again you'll have to adpat in good SQL syntax) :
select volume_name from volumes where last_write_date  your date time and 
stgpool_name = your stgpool
your date time is the TSM date time of the last copy

Hope this helps


If you read french, you can have a look at an example (somehow old) :
http://www.sos-restore.com/demolog/log.htm

Best regards

Christian Bagard
Tél :(33) 442 930 813 
email : [EMAIL PROTECTED]

SOS-Restore - 32 cours Mirabeau - 13100 Aix-en-Provence - France
www.sos-restore.com (only french sorry)


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 elaboration.

   Richard Sims


Re: RESTORE VOLUMES: other suggestions: a real answer to your que stion

2002-02-17 Thread Seay, Paul

Gary,
We are also a Veritas NetBackup user.  Thank God TSM has a facility like the
SQL query to search their databases and generate whatever I want already
built in.

I admit I had to learn SQL a few years ago to write a mainframe application
(RMDS extensions) that did some really complex SQL queries.  So, I was quick
to jump on the SQL features of TSM.  It took me about a week to become a
very proficient SQL coder and about another to learn what a stupid SQL query
with inner and outer joins could do to a system if not coded correctly.

There are several inevitabilities in our industry.  One, flat files are a
thing of the past.  Second, every database application being built today is
relational that can do anything.  TSM is a database application unlike any
other storage management product.  As a result you can do things with it
that are not possible with competitive offerings.

So, the third inevitability has arisen.  Systems people that do not retire
soon will be lost without basic SQL knowledge.  You being a MCSE are keenly
aware of this.

Now, I would like to reemphasize what others have said about ODBC since you
are a Microsoft knowledgeable person.  If you install the ODBC driver
(anywhere) you can use ACCESS to link to the TSM tables (do not recommend
import).  If you have any ACCESS background, you know that its filter
information does basicall a select.  You can see those in the log.

The ODBC driver takes all of 5 minutes to install and setup.

Sorry the current QUERY CONTENT command does not support splat for volume.
The QUERY OCC command would help you significantly in your quest if it
supported '*' as valid option for the volume.  However this is what the SQL
would look like:

SELECT volume_name, node_name, filespace_name from contents where
node_name='your node' group by volume_name, node_name, filespace_name order
by volume_name

However, this query takes for ever to run.  So, it is kind of useless.



-Original Message-
From: Alex Paschal [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:26 PM
To: [EMAIL 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 shudder  VB or Windows Scripting Host. Anything
you can use to automate your job creates time for personal growth, 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


Hi Michel,

Thanx for your assistance.  It continually frustrates me
that here is a product that out of the box requires the user (read
admin) to have another skill set ie SQL just so he can do reasonable job.

An admin without the skill set to create SQL queries and alike (like
me) will find that TSM out of the box is about as efficient as an ashtray on
a motorbike.

Guess I better get myself on a course to learn SQL...

Thanx again..

Gary



-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of
Michel David
Sent: 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.
Little example of script.
SETLOCAL
PUSHD C:\Program Files\Tivoli\TSM
EchoC:\Command.txt select file_name from contents
where volume_name='vol1'
DSMADMC -id=admin -password=admin -noconfirm 
c:\Command.txt  C:\Results.TXT
POPD
ENDLOCAL

This will just generate a file with the file_name
contents of the tape 'vol1'

This is a basis.
I hope you can continue.
Good luck

Michel


--- Gary Swanton [EMAIL PROTECTED] wrote:
 Hi Michel,

 Thank you for your quick response.
 Not too sure what
 you mean at step 2 - CStringArray - Could you please
 decode that bit for
 me

 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
 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

 --- Gary Swanton [EMAIL PROTECTED] wrote:
  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-15 Thread Gary Swanton

Hi Michel,

Thanx for your assistance.  It continually frustrates me
that here is a product that out of the box requires the user (read
admin) to have another skill set ie SQL just so he can do reasonable
job.

An admin without the skill set to create SQL queries and alike
(like me) will find that TSM out of the box is about as efficient as an
ashtray on a motorbike.

Guess I better get myself on a course to learn SQL...

Thanx again..

Gary



-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of
Michel David
Sent: 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.
Little example of script.
SETLOCAL
PUSHD C:\Program Files\Tivoli\TSM
EchoC:\Command.txt select file_name from contents
where volume_name='vol1'
DSMADMC -id=admin -password=admin -noconfirm 
c:\Command.txt  C:\Results.TXT
POPD
ENDLOCAL

This will just generate a file with the file_name
contents of the tape 'vol1'

This is a basis.
I hope you can continue.
Good luck

Michel


--- Gary Swanton [EMAIL PROTECTED] wrote:
 Hi Michel,

 Thank you for your quick response.
 Not too sure what
 you mean at step 2 - CStringArray - Could you please
 decode that bit for
 me

 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
 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

 --- Gary Swanton [EMAIL PROTECTED] wrote:
  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 a data restore, I have no idea of what
  volumes will be required
  for the data.  I have a 30 slot library at my
  disposal, which I
  appreciate is quite small, however, if after  I
 kick
  off a restore I
  should have some indication as to what volumes are
  required thereby
  allowing me to check the volumes into the library
  before the restore job
  commences.
 
  A recent example:  I had to restore 80MB
  worth of data and it
  took over 3.5 hours and over 18 tape changes.  The
  present situation is
  that after I start a restore I have to be glued to
  the console and wait
  for tape requests to appear in the activity log or
  via a pop-up.
 
  My research has shown that other people
 have
  been asking the
  same thing as far back as 1998 but no-one appears
 to
  have provided a
  solution.  Tivoli have told me that it is possible
  with some pretty
  complex SQL statements.  Great now I have to learn
  SQL queries as well.
 
  Does anybody have any ideas on this matter?  It's
  not that hard
  surely..Oh yeah I'm running TSM Server 4.2.10 on a
  W2K platform with
  current clients running 4.2.1.
 
 
 
 
  Gary Swanton
  Microsoft Certified Systems Engineer
  [EMAIL PROTECTED]


 __
 Do You Yahoo!?
 Send FREE Valentine eCards with Yahoo! Greetings!
 http://greetings.yahoo.com


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com



Re: RESTORE VOLUMES

2002-02-15 Thread Alex Paschal

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 for personal growth,
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


Hi Michel,

Thanx for your assistance.  It continually frustrates me
that here is a product that out of the box requires the user (read
admin) to have another skill set ie SQL just so he can do reasonable
job.

An admin without the skill set to create SQL queries and alike
(like me) will find that TSM out of the box is about as efficient as an
ashtray on a motorbike.

Guess I better get myself on a course to learn SQL...

Thanx again..

Gary



-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of
Michel David
Sent: 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.
Little example of script.
SETLOCAL
PUSHD C:\Program Files\Tivoli\TSM
EchoC:\Command.txt select file_name from contents
where volume_name='vol1'
DSMADMC -id=admin -password=admin -noconfirm 
c:\Command.txt  C:\Results.TXT
POPD
ENDLOCAL

This will just generate a file with the file_name
contents of the tape 'vol1'

This is a basis.
I hope you can continue.
Good luck

Michel


--- Gary Swanton [EMAIL PROTECTED] wrote:
 Hi Michel,

 Thank you for your quick response.
 Not too sure what
 you mean at step 2 - CStringArray - Could you please
 decode that bit for
 me

 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
 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

 --- Gary Swanton [EMAIL PROTECTED] wrote:
  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 a data restore, I have no idea of what
  volumes will be required
  for the data.  I have a 30 slot library at my
  disposal, which I
  appreciate is quite small, however, if after  I
 kick
  off a restore I
  should have some indication as to what volumes are
  required thereby
  allowing me to check the volumes into the library
  before the restore job
  commences.
 
  A recent example:  I had to restore 80MB
  worth of data and it
  took over 3.5 hours and over 18 tape changes.  The
  present situation is
  that after I start a restore I have to be glued to
  the console and wait
  for tape requests to appear in the activity log or
  via a pop-up.
 
  My research has shown that other people
 have
  been asking the
  same thing as far back as 1998 but no-one appears
 to
  have provided a
  solution.  Tivoli have told me that it is possible
  with some pretty
  complex SQL statements.  Great now I have to learn
  SQL queries as well.
 
  Does anybody have any ideas on this matter?  It's
  not that hard
  surely..Oh yeah I'm running TSM Server 4.2.10 on a
  W2K platform with
  current clients running 4.2.1.
 
 
 
 
  Gary Swanton
  Microsoft Certified Systems Engineer
  [EMAIL PROTECTED]


 __
 Do You Yahoo!?
 Send FREE Valentine eCards with Yahoo! Greetings!
 http://greetings.yahoo.com


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com



Re: RESTORE VOLUMES

2002-02-14 Thread Michel David

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.
Little example of script.
SETLOCAL
PUSHD C:\Program Files\Tivoli\TSM
EchoC:\Command.txt select file_name from contents
where volume_name='vol1'
DSMADMC -id=admin -password=admin -noconfirm 
c:\Command.txt  C:\Results.TXT
POPD
ENDLOCAL

This will just generate a file with the file_name
contents of the tape 'vol1'

This is a basis.
I hope you can continue.
Good luck

Michel


--- Gary Swanton [EMAIL PROTECTED] wrote:
 Hi Michel,

 Thank you for your quick response.
 Not too sure what
 you mean at step 2 - CStringArray - Could you please
 decode that bit for
 me

 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
 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

 --- Gary Swanton [EMAIL PROTECTED] wrote:
  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 a data restore, I have no idea of what
  volumes will be required
  for the data.  I have a 30 slot library at my
  disposal, which I
  appreciate is quite small, however, if after  I
 kick
  off a restore I
  should have some indication as to what volumes are
  required thereby
  allowing me to check the volumes into the library
  before the restore job
  commences.
 
  A recent example:  I had to restore 80MB
  worth of data and it
  took over 3.5 hours and over 18 tape changes.  The
  present situation is
  that after I start a restore I have to be glued to
  the console and wait
  for tape requests to appear in the activity log or
  via a pop-up.
 
  My research has shown that other people
 have
  been asking the
  same thing as far back as 1998 but no-one appears
 to
  have provided a
  solution.  Tivoli have told me that it is possible
  with some pretty
  complex SQL statements.  Great now I have to learn
  SQL queries as well.
 
  Does anybody have any ideas on this matter?  It's
  not that hard
  surely..Oh yeah I'm running TSM Server 4.2.10 on a
  W2K platform with
  current clients running 4.2.1.
 
 
 
 
  Gary Swanton
  Microsoft Certified Systems Engineer
  [EMAIL PROTECTED]


 __
 Do You Yahoo!?
 Send FREE Valentine eCards with Yahoo! Greetings!
 http://greetings.yahoo.com


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com



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

--- Gary Swanton [EMAIL PROTECTED] wrote:
 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 a data restore, I have no idea of what
 volumes will be required
 for the data.  I have a 30 slot library at my
 disposal, which I
 appreciate is quite small, however, if after  I kick
 off a restore I
 should have some indication as to what volumes are
 required thereby
 allowing me to check the volumes into the library
 before the restore job
 commences.

 A recent example:  I had to restore 80MB
 worth of data and it
 took over 3.5 hours and over 18 tape changes.  The
 present situation is
 that after I start a restore I have to be glued to
 the console and wait
 for tape requests to appear in the activity log or
 via a pop-up.

 My research has shown that other people have
 been asking the
 same thing as far back as 1998 but no-one appears to
 have provided a
 solution.  Tivoli have told me that it is possible
 with some pretty
 complex SQL statements.  Great now I have to learn
 SQL queries as well.

 Does anybody have any ideas on this matter?  It's
 not that hard
 surely..Oh yeah I'm running TSM Server 4.2.10 on a
 W2K platform with
 current clients running 4.2.1.




 Gary Swanton
 Microsoft Certified Systems Engineer
 [EMAIL PROTECTED]


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com



Re: RESTORE VOLUMES

2002-02-13 Thread Gary Swanton

Hi Michel,

Thank you for your quick response.  Not too sure what
you mean at step 2 - CStringArray - Could you please decode that bit for
me

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
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

--- Gary Swanton [EMAIL PROTECTED] wrote:
 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 a data restore, I have no idea of what
 volumes will be required
 for the data.  I have a 30 slot library at my
 disposal, which I
 appreciate is quite small, however, if after  I kick
 off a restore I
 should have some indication as to what volumes are
 required thereby
 allowing me to check the volumes into the library
 before the restore job
 commences.

 A recent example:  I had to restore 80MB
 worth of data and it
 took over 3.5 hours and over 18 tape changes.  The
 present situation is
 that after I start a restore I have to be glued to
 the console and wait
 for tape requests to appear in the activity log or
 via a pop-up.

 My research has shown that other people have
 been asking the
 same thing as far back as 1998 but no-one appears to
 have provided a
 solution.  Tivoli have told me that it is possible
 with some pretty
 complex SQL statements.  Great now I have to learn
 SQL queries as well.

 Does anybody have any ideas on this matter?  It's
 not that hard
 surely..Oh yeah I'm running TSM Server 4.2.10 on a
 W2K platform with
 current clients running 4.2.1.




 Gary Swanton
 Microsoft Certified Systems Engineer
 [EMAIL PROTECTED]


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com



Re: RESTORE VOLUMES

2002-02-13 Thread Bill Smoldt

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 questions here.

One format of the command you need is:

select volume_name, stgpool_name, filespace_name from volumeusage where
node_name='NODENAME'

where NODENAME is the name of the node in question in all caps.

That will show you which primary and copy pool tapes you need for the
restore.

To just see the tapes for a specific storage pool for you case, add a
selection of the storage pool name:

select volume_name, stgpool_name, filespace_name from volumeusage where
node_name='NODENAME' where stgpool_name='TAPEPOOL'

where TAPEPOOL is the name of your primary tape pool.

As you already know, this is not necessary if you have enough robot slots to
hold all your primary tapepool tapes.  Proper sizing of a TSM environment
before purchase is quite important.

Bill Smoldt
STORServer



-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Gary Swanton
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 a data restore, I have no idea of what volumes will be required
for the data.  I have a 30 slot library at my disposal, which I
appreciate is quite small, however, if after  I kick off a restore I
should have some indication as to what volumes are required thereby
allowing me to check the volumes into the library before the restore job
commences.

A recent example:  I had to restore 80MB worth of data and it
took over 3.5 hours and over 18 tape changes.  The present situation is
that after I start a restore I have to be glued to the console and wait
for tape requests to appear in the activity log or via a pop-up.

My research has shown that other people have been asking the
same thing as far back as 1998 but no-one appears to have provided a
solution.  Tivoli have told me that it is possible with some pretty
complex SQL statements.  Great now I have to learn SQL queries as well.

Does anybody have any ideas on this matter?  It's not that hard
surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with
current clients running 4.2.1.




Gary Swanton
Microsoft Certified Systems Engineer
[EMAIL PROTECTED]



Re: RESTORE VOLUMES

2002-02-13 Thread James Healy

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
large.




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 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 a data restore, I have no idea of what volumes will be required
for the data.  I have a 30 slot library at my disposal, which I
appreciate is quite small, however, if after  I kick off a restore I
should have some indication as to what volumes are required thereby
allowing me to check the volumes into the library before the restore job
commences.

A recent example:  I had to restore 80MB worth of data and it
took over 3.5 hours and over 18 tape changes.  The present situation is
that after I start a restore I have to be glued to the console and wait
for tape requests to appear in the activity log or via a pop-up.

My research has shown that other people have been asking the
same thing as far back as 1998 but no-one appears to have provided a
solution.  Tivoli have told me that it is possible with some pretty
complex SQL statements.  Great now I have to learn SQL queries as well.

Does anybody have any ideas on this matter?  It's not that hard
surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with
current clients running 4.2.1.




Gary Swanton
Microsoft Certified Systems Engineer
[EMAIL PROTECTED]



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.

/*  */
/* macro file to select the volumes that a node */
/* is stored on.*/
/*  */
set sqldatetimeformat i
set sqldisplaymode w
set sqlmathmode r
commit
select distinct copy_type, left(node_name,16), left(volume_name,16), -
left(stgpool_name,16) -
   from adsm.volumeusage  -
   where node_name = %1 -
 and copy_type in ('BACKUP', 'ARCHIVE') -
 and filespace_name %2 %3 -
  c:\tsmvolumes.txt



At 08:01 PM 2/13/2002 +1100, you wrote:
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 a data restore, I have no idea of what volumes will be required
for the data.  I have a 30 slot library at my disposal, which I
appreciate is quite small, however, if after  I kick off a restore I
should have some indication as to what volumes are required thereby
allowing me to check the volumes into the library before the restore job
commences.

A recent example:  I had to restore 80MB worth of data and it
took over 3.5 hours and over 18 tape changes.  The present situation is
that after I start a restore I have to be glued to the console and wait
for tape requests to appear in the activity log or via a pop-up.

My research has shown that other people have been asking the
same thing as far back as 1998 but no-one appears to have provided a
solution.  Tivoli have told me that it is possible with some pretty
complex SQL statements.  Great now I have to learn SQL queries as well.

Does anybody have any ideas on this matter?  It's not that hard
surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with
current clients running 4.2.1.




Gary Swanton
Microsoft Certified Systems Engineer
[EMAIL PROTECTED]

--
Bill Colwell
C. S. Draper Lab
Cambridge Ma.