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"
Echo>C:\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
