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