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