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 <kelly14 AT OPTUSHOME.COM DOT AU> wrote:
> Hi Michel,
> 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
> Michel David
> Sent: Wednesday, 13 February 2002 8:21 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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 <kelly14 AT OPTUSHOME.COM DOT AU> 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
> > kelly14 AT optushome.com DOT au
>
>
> __________________________________________________
> 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