Re: HELP!!!!!!
There is no list of file identification on the data tape. That's why TSM DB is designed for. If the DB does not point to data in the tape you can guess but not be sure what actually is there. How did you reached this point (DELete VOLume DIScard=Yes ??) ? If this did not happen as result of human error let all us know. Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:HELP!! Is there anyway that I can take a tape from a storage pool that has NOT been reclaimed and read what files are on it and import that list into the TSM database. Any help would be great! Thanks Rob Schroeder Famous Footwear [EMAIL PROTECTED]
Re: HELP!!!!!!
Zlatko, I ran the old adsmtape utility against a DLT4 TSM 4.1.5 tape and a list of filenames scrolled up my screen. I couldn't get the data off (yet) but the tape certainly seemed to know what files it had. Regards, David Smith AIX Administrator Corporate Express Australia -Original Message- From: Zlatko Krastev [mailto:[EMAIL PROTECTED]] Sent: Thursday, 11 April 2002 4:03 PM To: [EMAIL PROTECTED] Subject: Re: HELP!! There is no list of file identification on the data tape. That's why TSM DB is designed for. If the DB does not point to data in the tape you can guess but not be sure what actually is there. How did you reached this point (DELete VOLume DIScard=Yes ??) ? If this did not happen as result of human error let all us know. Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:HELP!! Is there anyway that I can take a tape from a storage pool that has NOT been reclaimed and read what files are on it and import that list into the TSM database. Any help would be great! Thanks Rob Schroeder Famous Footwear [EMAIL PROTECTED]
TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS
Dear *SM Gurus The TSM DB Fullbackup (19GB) takes about 4 hours on OS/390 with VTS. I haven't found any descriptions for parallelisation, eg. maxpr or mountp. Is it in the tec. nature, the DB will be backed up in sequenz? tia Joachim Joachim Paul Schaub Abraxas Informatik AG Beckenhofstrasse 23 CH-8090 Zürich Schweiz / Switzerland Telefon: +41 (01) 259 34 41 Telefax: +41 (01) 259 42 82 E-Mail: mailto:[EMAIL PROTECTED] Internet: http://www.abraxas.ch
How do I know what tape/s my data is on?
Ok guys, Here is a puzzler for you. Lets say that I have a primary tape pool, but I DONT have a secondary pool. (IE data ONLY goes to tape once with NO second copy). We then send those tapes offsite. (This saves us valuable space in the tape library). One month later, a customer asks for an archive to be retrieved from those tapes. How do I know what tapes to retrieve? - These archives would have built up over a period of time, so there may be more than 10 tapes offsite and I dont want them all!!. Is there a way that I can find out which set of tapes my archived data is on? - Bearing in mind that if reclamation is also run of this pool, then the data may possibly be moved around on a regular basis. Any help would be greatfully recieved. Kind Regards, Roy Lake RS/6000 TSM Systems Administration Team Tibbett Britten European I.T. Judd House Ripple Road Barking Essex IG11 0TU 0208 526 8853 [EMAIL PROTECTED] This e-mail message has been scanned using Sophos Sweep http://www.sophos.com ** --- IMPORTANT INFORMATION - This message is intended only for the use of the Person(s) ('the intended recipient') to whom it was addressed. It may contain information which is privileged confidential within the meaning of applicable law. Accordingly any dissemination, distribution, copying, or other use of this message, or any of its contents, by any person other than the intended recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are NOT the intended recipient please contact the sender and dispose of this email as soon as possible. If in doubt please contact European IT on 0870 607 6777 (+44 20 85 26 88 88). This message has been sent via the Public Internet. **
Re: TSM V5.1
The 5.1 clients are also available for download now. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Jonathan Siegle [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 21:41 To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Got mine on Monday. I really liked the TSM 5.1 cd with 4.2 functional level software... On Thu, 11 Apr 2002, Gill, Geoffrey L. wrote: Hey everyone, I just got my TSM V5.1 package of software. Anyone else get so lucky? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154 Jonathan Siegle Center for Academic Computing [EMAIL PROTECTED] Penn State University 814-865-5840University Park, Pa 16802 ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Redirecting Commands in Scripts
Hello all, I found questions like this in the archives, but no answers.. One more try = I want to run a script, where one line should look like this: QUERY SYSTEM DSM.OUTPUT.QSYSTEM where DSM.OUTPUT.QSYSTEM is a S390 Filename I want to take to the OFFSITE Location. (This Command works great on the command line, but I want to have it in a script!) However - I tried to do it like this: def script test desc='Test' upd script test QUERY SYSTEM DSM.OUTPUT Result: ANR1454I DEFINE SCRIPT: Command script TEST defined. ANR2002E Missing closing quote character. ANS8001I Return code 3. Any hints how to route an output to a file in a script ? I guess, the problem is, that TSM wants to direct the Output of the Update Stmt to a file - and when doing this, one quote is missing, of course We are running TSM 3.7.5 on S390 (I know, not supported, but I guess this should work on all versions) Regards Gerhard Wolkerstorfer
Re: How do I know what tape/s my data is on?
Roy, I hesitate to answer your question, because it would support you in a VERY BAD practise. I find operation with only single copy of data simply irresponsible. The costs for second copy are very low - only couple of tape media. Do rethink this design, consider creating backup pool. This makes it possible to keep tapes from primary pool unloaded from library but still on-site, thus eliminating your find-correct-tape problem. regards Juraj Salak -Original Message- From: Roy Lake [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 11:03 AM To: [EMAIL PROTECTED] Subject: How do I know what tape/s my data is on? Ok guys, Here is a puzzler for you. Lets say that I have a primary tape pool, but I DONT have a secondary pool. (IE data ONLY goes to tape once with NO second copy). We then send those tapes offsite. (This saves us valuable space in the tape library). One month later, a customer asks for an archive to be retrieved from those tapes. How do I know what tapes to retrieve? - These archives would have built up over a period of time, so there may be more than 10 tapes offsite and I dont want them all!!. Is there a way that I can find out which set of tapes my archived data is on? - Bearing in mind that if reclamation is also run of this pool, then the data may possibly be moved around on a regular basis. Any help would be greatfully recieved. Kind Regards, Roy Lake RS/6000 TSM Systems Administration Team Tibbett Britten European I.T. Judd House Ripple Road Barking Essex IG11 0TU 0208 526 8853 [EMAIL PROTECTED] This e-mail message has been scanned using Sophos Sweep http://www.sophos.com ** --- IMPORTANT INFORMATION - This message is intended only for the use of the Person(s) ('the intended recipient') to whom it was addressed. It may contain information which is privileged confidential within the meaning of applicable law. Accordingly any dissemination, distribution, copying, or other use of this message, or any of its contents, by any person other than the intended recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are NOT the intended recipient please contact the sender and dispose of this email as soon as possible. If in doubt please contact European IT on 0870 607 6777 (+44 20 85 26 88 88). This message has been sent via the Public Internet. **
Re: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS
My 80% full 25gb FULL DB backup takes 1hr 20 minutes on 9672-x57 going to a 9840 tape. What else is going on in your TSM system at the time? Expiration processing slows it down quite a bit. Have you gone through the normal steps of maximizing the throughput on your TSM system? Matt -Original Message- From: Schaub Joachim Paul ABX-PROD-ZH [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 4:49 AM To: [EMAIL PROTECTED] Subject: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS Dear *SM Gurus The TSM DB Fullbackup (19GB) takes about 4 hours on OS/390 with VTS. I haven't found any descriptions for parallelisation, eg. maxpr or mountp. Is it in the tec. nature, the DB will be backed up in sequenz? tia Joachim Joachim Paul Schaub Abraxas Informatik AG Beckenhofstrasse 23 CH-8090 Zürich Schweiz / Switzerland Telefon: +41 (01) 259 34 41 Telefax: +41 (01) 259 42 82 E-Mail: mailto:[EMAIL PROTECTED] Internet: http://www.abraxas.ch
Re: Sql problem
There is a workaround the problem but it is ugly and can work for small number of GROUP BY values. Look for my post on the thread SQL query - GROUP on derived value? from 25.09.2001. The rough idea - create records somewhere they would not be a problem. I've used CLIENT_SCHEDULES table with and empty policy domain for the task. Join the tables and group by fake records. Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:Sql problem Hi All, I just realized I can use the summary table to get tape mount stats. However I can't get my sql to work I'm trying select hour(end_time) as Hour, count(*) from summary where activity= 'TAPE MOUNT' and date(end_time) = current date - 1 day group by hour(end_time) and TSM is complaining about the group by clause. ANR2904E Unexpected SQL key word token - 'HOUR'. | .V. nd date(end_time) =current date - 1 day group by hour(end_time) I've also tried 'group by 1' and 'group by Hour' but that doesn't work either. This is fairly standard SQL, anyone know what I'm doing wrong? Steve Harris AIX and TSM Administrator Queensland Health, Brisbane Australia ** This e-mail, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost if you receive it and you are not the intended recipient(s), or if it is transmitted/ received in error. Any unauthorised use, alteration, disclosure, distribution or review of this e-mail is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this e-mail in error, you are asked to immediately notify the sender by telephone or by return e-mail. You should also delete this e-mail message and destroy any hard copies produced. **
Re: Monthly Backups, ...again!: The Real Issues
We are not calling them exactly Class 1, Class 2 and Class 3 but are using the same rules for collocation. There is a slight modification - you can manually collocate by creating Class 3a, Class 3b, etc. So the tape pool for Class 3something would not be too big and on restore you will need less tapes. And Class 3z may become Class 4 with all-those-absolutely-non-critical-nodes and unlimited number of tapes in it. I also enjoy debates. And many threads on this list are about *proper* TSM (now ISM) setup. I have seen a customer using Oracle database through ODBC as plain dBase files with own relations logic on top of this. Guess what was the performace. From this I cannot say Oracle is abnormally slow database, right? Weird setup does not mean the product is bad. That's why for example Incremental-forever does not work with TDP (now ISM for ...) products. If MS Exchange had adopted this nice backup technique and APIs allow some kind of mapping of IS to filespace name, Mailboxes to directories and folders to files ... We could have incremental-forever with restore granularity down to a folder and subfile backup can help us to transfer only new/deleted messages. Or something even better. Same for Oracle for example - instances may be same type of object as filespaces, tablespaces - directories and tables vs files. BTW: explaining to customer I prefer to use term object pointing that for B/A client this is an ordinary file but for TDP is application dependant. And from this point of view I explain why many good sides of Progressive Backup go away. Zlatko Krastev IT Consultant P.S. And completely new things demand from us to change our way of thinking. Same as a century ago there was speed limit for cars of 5 km/h and a man with red sign ought to walk in front of the car to warn the public and prevent horses to panic!!! I am not kidding. Zlatko Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:Re: Monthly Backups, ...again!: The Real Issues I enjoy TSM debates, but one that has not sold me yet is this particular one. Yes, I come from a different environment (than Incremental-forever). One of the biggest drawbacks of the old ADSM was the abnormal slow restores and this has been notified by a collegue of mine of why his previous job did not get ADSM back in the early 90's. My suspicion was this Incremental-forever and here I see why. It all relies on the collocate issue. If you have numerous tapes and numerous drives than collocate will make Incremental-forever a quck restore. I started with 2 drives 80 clients and 500 tapes leading to no-collocate. When restoring 2 GB+ restores that were spread out over 70-100 tapes this took almost 8 hours (note this took about 1 year to get to 70-100 tapes). At our DR test we noticed a diffence of 6 times a normal restore for no-collocate versus a backupset. But on the other hand I brought that restore time down when splitting the restore into 5 separate restores for 5 tape drives (I currently have 6 drives). So the no-collocate will work if the right amount of tape drives are available (our 3570 are pretty expensive). Now in the real world you usually have 1-2 tape drives for restores (dedicated) and you cannot afford to send 80 tapes off every night for collocate, so what we are gravitating to is a class1, class2, and class3 system. class1 will be our DRM critical restore with collocate onsite and offsite, class2 our noncritical but high restore class with collocate onsite and noncollocate offsite. and then the good class3 with nocollocate onsite or offsite. The monthlys or Absolutes will be used to stop the spreading of info over 70 -100 tapes. It may not be true, but I seem to see the more reclamation the more spreading of info. and I would have thought that the reclamation would bring info closer together. All it takes is one time of getting burned with the 70-100 tape restore spread. We have presently moved data from one server to another 7 GB and used TSM to do this. If the manual full had not be done the night before (which has happened) then I still be restoring as we speak. There are more good things about fulls than meets the eye. Now I know not all restores are 2 GB+ but I do see more and more and we will all have to deal with it in our own ways. Just 1 way of dealing with it. Not the only but a way is better than no way. Seay, Paul seay_pd@NAPTH To: [EMAIL PROTECTED] EON.COM cc: Sent by: Subject: Re: Monthly Backups, ...again!: The Real Issues ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 04/10/02 01:14 AM Please respond to ADSM: Dist
AW: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS
ther are no other activ processes, no waits for mountpoints, the db looks o.k., the throughput maybe is limited by ESCON. -Ursprüngliche Nachricht- Von: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 12. April 2002 12:43 An: [EMAIL PROTECTED] Betreff: Re: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS My 80% full 25gb FULL DB backup takes 1hr 20 minutes on 9672-x57 going to a 9840 tape. What else is going on in your TSM system at the time? Expiration processing slows it down quite a bit. Have you gone through the normal steps of maximizing the throughput on your TSM system? Matt -Original Message- From: Schaub Joachim Paul ABX-PROD-ZH [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 4:49 AM To: [EMAIL PROTECTED] Subject: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS Dear *SM Gurus The TSM DB Fullbackup (19GB) takes about 4 hours on OS/390 with VTS. I haven't found any descriptions for parallelisation, eg. maxpr or mountp. Is it in the tec. nature, the DB will be backed up in sequenz? tia Joachim Joachim Paul Schaub Abraxas Informatik AG Beckenhofstrasse 23 CH-8090 Zürich Schweiz / Switzerland Telefon: +41 (01) 259 34 41 Telefax: +41 (01) 259 42 82 E-Mail: mailto:[EMAIL PROTECTED] Internet: http://www.abraxas.ch
Re: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS
I am going over ESCON. I have an issue with TSM that I would watch TSM use more and more CPU and actually do less and less. I found that stopping and starting TSM on a weekly basis would get me past it. I have sent them dumps and logs. They said to STOP draining my DISK pool to 0. SO I am trying that. Anyway, my point is, try bringing TSM down and Up and check the throughput then. It may also be worth your time to check and make sure that TSM is in the proper Work Load Manager service class (of course that is only an issue if the machine is running 100%). Matt -Original Message- From: Schaub Joachim Paul ABX-PROD-ZH [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 7:34 AM To: [EMAIL PROTECTED] Subject: AW: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS ther are no other activ processes, no waits for mountpoints, the db looks o.k., the throughput maybe is limited by ESCON. -Ursprüngliche Nachricht- Von: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 12. April 2002 12:43 An: [EMAIL PROTECTED] Betreff: Re: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS My 80% full 25gb FULL DB backup takes 1hr 20 minutes on 9672-x57 going to a 9840 tape. What else is going on in your TSM system at the time? Expiration processing slows it down quite a bit. Have you gone through the normal steps of maximizing the throughput on your TSM system? Matt -Original Message- From: Schaub Joachim Paul ABX-PROD-ZH [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 4:49 AM To: [EMAIL PROTECTED] Subject: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS Dear *SM Gurus The TSM DB Fullbackup (19GB) takes about 4 hours on OS/390 with VTS. I haven't found any descriptions for parallelisation, eg. maxpr or mountp. Is it in the tec. nature, the DB will be backed up in sequenz? tia Joachim Joachim Paul Schaub Abraxas Informatik AG Beckenhofstrasse 23 CH-8090 Zürich Schweiz / Switzerland Telefon: +41 (01) 259 34 41 Telefax: +41 (01) 259 42 82 E-Mail: mailto:[EMAIL PROTECTED] Internet: http://www.abraxas.ch
Re: Redirecting Commands in Scripts
In some clients, a space before the makes a difference. So try upd script test QUERY SYSTEM DSM.OUTPUT - Mr. Lindsay Morris CEO, Servergraph www.servergraph.com 859-253-8000 ofc 425-988-8478 fax -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Gerhard Wolkerstorfer Sent: Friday, April 12, 2002 6:26 AM To: [EMAIL PROTECTED] Subject: Redirecting Commands in Scripts Hello all, I found questions like this in the archives, but no answers.. One more try = I want to run a script, where one line should look like this: QUERY SYSTEM DSM.OUTPUT.QSYSTEM where DSM.OUTPUT.QSYSTEM is a S390 Filename I want to take to the OFFSITE Location. (This Command works great on the command line, but I want to have it in a script!) However - I tried to do it like this: def script test desc='Test' upd script test QUERY SYSTEM DSM.OUTPUT Result: ANR1454I DEFINE SCRIPT: Command script TEST defined. ANR2002E Missing closing quote character. ANS8001I Return code 3. Any hints how to route an output to a file in a script ? I guess, the problem is, that TSM wants to direct the Output of the Update Stmt to a file - and when doing this, one quote is missing, of course We are running TSM 3.7.5 on S390 (I know, not supported, but I guess this should work on all versions) Regards Gerhard Wolkerstorfer
Re: HELP!!!!!!
I surrender. I am not familiar with tape format but always thought that there is only data. Still do not know are the file names found enough and complete: how the aggregates are handled, what when we have a file spanning more than one tape, etc. There was a service (and I think still exists) from HDD vendors - they were able to recover some of the data from a crashed disk. I prefer to have a backup on hand. Same for TSM - that's why copypools are designed for. Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:Re: HELP!! Zlatko, I ran the old adsmtape utility against a DLT4 TSM 4.1.5 tape and a list of filenames scrolled up my screen. I couldn't get the data off (yet) but the tape certainly seemed to know what files it had. Regards, David Smith AIX Administrator Corporate Express Australia -Original Message- From: Zlatko Krastev [mailto:[EMAIL PROTECTED]] Sent: Thursday, 11 April 2002 4:03 PM To: [EMAIL PROTECTED] Subject: Re: HELP!! There is no list of file identification on the data tape. That's why TSM DB is designed for. If the DB does not point to data in the tape you can guess but not be sure what actually is there. How did you reached this point (DELete VOLume DIScard=Yes ??) ? If this did not happen as result of human error let all us know. Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:HELP!! Is there anyway that I can take a tape from a storage pool that has NOT been reclaimed and read what files are on it and import that list into the TSM database. Any help would be great! Thanks Rob Schroeder Famous Footwear [EMAIL PROTECTED]
Re: TSM V5.1
Yes, and be sure to get the 5.1.0.1 Windows clients from the FTP site, vs. the 5.1.0.0 clients shipped on the CD. As someone pointed out yesterday, we now have a 4.2.1.32 client to address APAR IC33211 (The TSM V4.2 Windows NT-based client acceptor service may crash if improperly formatted data is received from the HTTP port), and this APAR is fixed in 5.1.0.1 as well. For ODBC driver users, be sure to get the 5.1.0.1 ODBC driver as well. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/12/2002 02:42 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM V5.1 The 5.1 clients are also available for download now. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Jonathan Siegle [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 21:41 To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Got mine on Monday. I really liked the TSM 5.1 cd with 4.2 functional level software... On Thu, 11 Apr 2002, Gill, Geoffrey L. wrote: Hey everyone, I just got my TSM V5.1 package of software. Anyone else get so lucky? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154 Jonathan Siegle Center for Academic Computing [EMAIL PROTECTED] Penn State University 814-865-5840University Park, Pa 16802 ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS
Why are you writing a 19GB dataset to the VTS? The VTS is designed to handle small datasets, usually a few 100MB and at most what you can fit on one 3490 cartridge. To do this backup the VTS will have to mount 19+ scratch volumes. The VTS will also need space on the VTS disk cache for such a large dataset, so you could have the VTS spending time trying to offload data from the disk cache to the 3590 stacking tapes. This could be slowing down your backup. What else is happening on the VTS when you are doing this backup? Which model of VTS do you have? Adolph Kahan GlassHouse Systems Inc. 416-229-2950 Ext 304 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Schaub Joachim Paul ABX-PROD-ZH Sent: Friday, April 12, 2002 4:49 AM To: [EMAIL PROTECTED] Subject: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS Dear *SM Gurus The TSM DB Fullbackup (19GB) takes about 4 hours on OS/390 with VTS. I haven't found any descriptions for parallelisation, eg. maxpr or mountp. Is it in the tec. nature, the DB will be backed up in sequenz? tia Joachim Joachim Paul Schaub Abraxas Informatik AG Beckenhofstrasse 23 CH-8090 Zürich Schweiz / Switzerland Telefon: +41 (01) 259 34 41 Telefax: +41 (01) 259 42 82 E-Mail: mailto:[EMAIL PROTECTED] Internet: http://www.abraxas.ch
Re: Redirecting Commands in Scripts
Great! One I can finally answer since I just got help on this. I tried the scripts too, unsuccessfully. The only way I know of to route TSM command output to a dataset is by using the TSM TSO Client. I either use the information as presented, or I REXXrcise it Here's the JCL I got from asking a similar question in this forum... //O8XCJOB (8218,08017,8X,G),'BIN 259 IKE ',NOTIFY=O8X, //MSGCLASS=H,CLASS=A,USER=SPPDASD,REGION=0M /*JOBPARM L=99,T=1440 //A EXEC PGM=IEFBR14 //D1 DD DSN=O8X.ADSM.MSGS, //SPACE=(TRK,0), //UNIT=3390,DISP=(MOD,DELETE) //TSPROC EXEC PGM=IKJEFT01,DYNAMNBR=30 //STEPLIB DD DSN=SYS2.TSM.V4219.LOADLIB,DISP=SHR //DSCOPT DD DISP=SHR,DSN=SYS2.ADSM.$TSO.OPTIONS //DSCLANG DD DSN=SYS1.SANSMSG(ANSMENU),DISP=SHR //D1 DD DSN=O8X.ADSM.MSGS, //SPACE=(CYL,(1,5)),LRECL=84,RECFM=VB,DSORG=PS, //UNIT=3390,DISP=(,CATLG,DELETE),BLKSIZE=0 //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * PROF PRE(O8X) DSMADMC -ID=O8X -PA=D071676 -OUTFILE=DD:D1 MACRO DD:D2 -TAB //D2 DD * SELECT DATE_TIME,MSGNO,MESSAGE FROM ACTLOG - WHERE SEVERITY='E' OR SEVERITY='W' /* // Here is the CLIST... PROC 0 PROFILE PROMPT PRE(SYSUID) CONTROL NOLIST NOCONLIST MSG FLUSH PROMPT NOSYMLIST WRITE 1.) ADSM ON SY1C WRITE 2.) ADSME ON SY1C WRITE 3.) TSMEDP00 ON SY1D WRITE 4.) TSMNTP00 ON SY1D WRITE 5.) TSMUXP00 ON SY1D WRITE 6.) TSMUXT01 ON SY1D PICKSRVR: + WRITENR ENTER NUMBER 1 = 6 FOR THE TSM SERVER-- READ SERVR IF DATATYPE(SERVR) ¬= NUM THEN DO WRITE SERVR IS INCORRECT. ENTER 1,2,3,4,5, OR 6 GOTO PICKSRVR END IF SERVR 1 AND SERVR 6 THEN DO WRITE SERVR IS INCORRECT. ENTER 1,2,3,4,5, OR 6 GOTO PICKSRVR END IF SERVR = 1 THEN SET SRVR = STR(ADSM) IF SERVR = 2 THEN SET SRVR = STR(ADSME) IF SERVR = 3 THEN SET SRVR = STR(TSMEDP00) IF SERVR = 4 THEN SET SRVR = STR(TSMNTP00) IF SERVR = 5 THEN SET SRVR = STR(TSMUXP00) IF SERVR = 6 THEN SET SRVR = STR(TSMUXT01) WRITE CONTACTING SRVR /* IT IS IMPORTANT TO INCLUDE THE PARAMETER PROMPT */ /* IN THE PROFILE AND CONTROL STATEMENTS TO ALLOW*/ /* DSMADMC (TSO ADMIN CLIENT MODULE) TO PROMPT FOR */ /* INPUT (E.G. PASSWORD).*/ ALLOC F(DSCOPT) DA('SYS2.SRVR..$TSO.OPTIONS') SHR REU ALLOC F(DSCLANG) DA('SYS1.SANSMSG(ANSMENU)') SHR REU CALL 'SYS2.TSM.V4219.LOADLIB(DSMADMC)' FREE F(DSCOPT DSCLANG ) PROFILE NOPRE WRITE SRVR TSO CLIENT SESSION ENDED Hope this helps -Original Message- From: Gerhard Wolkerstorfer [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 6:26 AM To: [EMAIL PROTECTED] Subject: Redirecting Commands in Scripts Hello all, I found questions like this in the archives, but no answers.. One more try = I want to run a script, where one line should look like this: QUERY SYSTEM DSM.OUTPUT.QSYSTEM where DSM.OUTPUT.QSYSTEM is a S390 Filename I want to take to the OFFSITE Location. (This Command works great on the command line, but I want to have it in a script!) However - I tried to do it like this: def script test desc='Test' upd script test QUERY SYSTEM DSM.OUTPUT
Re: TSM db backup.
Here is some additional information that may help in determining my problem. Thanks all. Library: tsm: TSMq library f=d Library Name: DBTAPELIB Library Type: MANUAL Device: Private Category: Scratch Category: External Manager: Shared: No LanFree: ObeyMountRetention: Primary Library Manager: Last Update by (administrator): ADMIN Last Update Date/Time: 03/22/02 12:28:40 -- Device Classes tsm: TSMq devc f=d Device Class Name: 8MMDB Device Access Strategy: Sequential Storage Pool Count: 0 Device Type: 8MM Format: DRIVE Est/Max Capacity (MB): 20,480.0 Mount Limit: 1 Mount Wait (min): 60 Mount Retention (min): 10 Label Prefix: TSMDBVOL Library: DBTAPELIB Directory: Server Name: Retry Period: Retry Interval: Shared: Last Update by (administrator): ADMIN Last Update Date/Time: 03/22/02 12:46:42 Device Class Name: DBTRIGGER Device Access Strategy: Sequential Storage Pool Count: 0 Device Type: FILE Format: DRIVE Est/Max Capacity (MB): 4.0 Mount Limit: 1 Mount Wait (min): Mount Retention (min): Label Prefix: Library: Directory: /tsm/database/trigger Server Name: Retry Period: Retry Interval: Shared: Last Update by (administrator): ADMIN Last Update Date/Time: 03/05/02 09:42:53 Device Class Name: DISK Device Access Strategy: Random Storage Pool Count: 3 Device Type: Format: Est/Max Capacity (MB): Mount Limit: Mount Wait (min): Mount Retention (min): Label Prefix: Library: Directory: Server Name: Retry Period: Retry Interval: Shared: Last Update by (administrator): Last Update Date/Time: 03/04/02 12:35:15 - Drives: tsm: TSMq drive f=d Library Name: DBTAPELIB Drive Name: DBTAPEMT0 Device Type: 8MM On-Line: Yes Device: /dev/mt0 Element: Allocated to: Last Update by (administrator): ADMIN Last Update Date/Time: 03/22/02 14:04:12 Cleaning Frequency (Gigabytes/ASNEEDED/NONE): NONE Frank, Have you checked to see if the tape was write-protected? Regards, Demetrius Malbrough UNIX/TSM Administrator -Original Message- From: Frank Kruse [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 10:26 AM To: [EMAIL PROTECTED] Subject: TSM db backup. Hello all, Let me start out by saying that I am a new subscriber to this list, so sorry if these question have been posted before. I have recently set up a TSM server. The server and client code is at 4.2.1. I have the clients backing up to the server and files going only to disk storage pool only for the time being, until I get my tape drives. The problem I am having is with my database backups. I set up the dbbackuptrigger to backup the database at 75%. Now my problem, whenever I set logmode to rollforward, TSM automatically wants to do the first dbBackup which I assume would be a full backup. After the process gets kicked off, the 20 gig tape just gets spit out. Even when I set the logmode to normal and try a manual backup db devclass=8mmdb type=full scratch=yes. When I run the command the tape reads, rewinds, and ejects without the backup. This is very frustrating and is probably something very obvious, but I can't figure it out. Can anyone tell me what I may be doing wrong? -- ** * Frank Kruse [EMAIL PROTECTED]* * IBM Austin 512-823-7475 * ** -- ** * Frank Kruse [EMAIL PROTECTED]* * IBM Austin 512-823-7475 * **
Re: latest client version for Windows
We all know that 5.1.0.1 is the latestIs it the greatest? Time will tell :) Just downloaded and will be installing on a machine later today to play around with it. Curt Magura Lockheed Martin EIS Gaithersburg, Md. 301-240-6305 -Original Message- From: Joe Cascanette [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 8:24 AM To: [EMAIL PROTECTED] Subject: latest client version for Windows I am currently running 4.2.1.20 on most of my Windows servers, and have seen a few messages about 4.2.1.30. Is this for another OS?. I looked at the ftp site and it shows only 4.2.1.23 (patch for security problem). I was planning to upgrade all my Window boxes and just want to make sure that I am putting on the lastest and greatest... Thanks Joe -Original Message- From: Frank Kruse [mailto:[EMAIL PROTECTED]] Sent: Fri 4/12/2002 8:00 AM To: [EMAIL PROTECTED] Cc: Subject: Re: TSM db backup. Here is some additional information that may help in determining my problem. Thanks all. Library: tsm: TSMq library f=d Library Name: DBTAPELIB Library Type: MANUAL Device: Private Category: Scratch Category: External Manager: Shared: No LanFree: ObeyMountRetention: Primary Library Manager: Last Update by (administrator): ADMIN Last Update Date/Time: 03/22/02 12:28:40 -- Device Classes tsm: TSMq devc f=d Device Class Name: 8MMDB Device Access Strategy: Sequential Storage Pool Count: 0 Device Type: 8MM Format: DRIVE Est/Max Capacity (MB): 20,480.0 Mount Limit: 1 Mount Wait (min): 60 Mount Retention (min): 10 Label Prefix: TSMDBVOL Library: DBTAPELIB Directory: Server Name: Retry Period: Retry Interval: Shared: Last Update by (administrator): ADMIN Last Update Date/Time: 03/22/02 12:46:42 Device Class Name: DBTRIGGER Device Access Strategy: Sequential Storage Pool Count: 0 Device Type: FILE Format: DRIVE Est/Max Capacity (MB): 4.0 Mount Limit: 1 Mount Wait (min): Mount Retention (min): Label Prefix: Library: Directory: /tsm/database/trigger Server Name: Retry Period: Retry Interval: Shared: Last Update by (administrator): ADMIN Last Update Date/Time: 03/05/02 09:42:53 Device Class Name: DISK Device Access Strategy: Random Storage Pool Count: 3 Device Type: Format: Est/Max Capacity (MB): Mount Limit: Mount Wait (min): Mount Retention (min): Label Prefix: Library: Directory: Server Name: Retry Period: Retry Interval: Shared: Last Update by (administrator): Last Update Date/Time: 03/04/02 12:35:15 - Drives: tsm: TSMq drive f=d Library Name: DBTAPELIB Drive Name: DBTAPEMT0 Device Type: 8MM On-Line: Yes Device: /dev/mt0 Element: Allocated to: Last Update by (administrator): ADMIN Last Update Date/Time: 03/22/02 14:04:12 Cleaning Frequency (Gigabytes/ASNEEDED/NONE): NONE Frank, Have you checked to see if the tape was write-protected? Regards,
Re: Using Disk in place of tapes for copy pools
I 've read this, with much interest since we are looking at NAS right now in a remote building, for DR purposes for one. Would you know if this would be possible to do, in having the data goto both tape and a NAS appliance offsite. thanks Paul -Original Message- From: Steve Harris [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 7:25 PM To: [EMAIL PROTECTED] Subject: Re: Using Disk in place of tapes for copy pools Can we have some details of your disk vendor and model? How has reliability been? Any disk failures? I have an IBM ESS here, but that is too expensive to waste on very large disk pools. Thanks Steve Harris AIX and TSM Admin Queensland Health, Brisbane Australia [EMAIL PROTECTED] 11/04/2002 22:48:27 Pat, We been using a all disk backuppool for a number of years now. It's grown to 3TB (4 expansion cabinets with 14 73GB drives each and each set to raid 5), we just keep adding disk expansion to server as we need more storage. We use a small LTO library for the copypool. We backup 360 servers (80 to 100 GB total) nightly and growing. The TSM database is 10GB sitting on raid 10 with 15K rpm drives (very fast) , i also defrag the DB monthly. This is a dream setup and works very well, restores run in the blink of a eye. I run the TSM server by myself as a part-time duty. I would suggest just growing your disks storage on your backuppool to at least 1 TB to keep backups and restore running fast, allowing older data to migrate to your existing tape library. Now a days disks have both a performance and price advantage over tape. If you have any other question please let me know. john Synovus Columbus, GA -- Date:Wed, 10 Apr 2002 12:32:20 -0400 From:Patrick J. Kelleher [EMAIL PROTECTED] Subject: Using Disk in place of tapes for copy pools We currently back up 500 GIG a night using an ATL 6000 tape library. Before replacing Tape Library we would like to research the possibility of using Disk in place of tape for all backups. Anyone doing this, especially on a large scale as we have 20 terabytes in Tape Library. -- ** This e-mail, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost if you receive it and you are not the intended recipient(s), or if it is transmitted/ received in error. Any unauthorised use, alteration, disclosure, distribution or review of this e-mail is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this e-mail in error, you are asked to immediately notify the sender by telephone or by return e-mail. You should also delete this e-mail message and destroy any hard copies produced. **
Re: latest client version for Windows
Whoops Looks like Joe was talking about server vs. client levels. Oh well - Still going to play with the new client later today. Curt Magura Lockheed Martin EIS Gaithersburg, Md. 301-240-6305 -Original Message- From: Magura, Curtis [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 8:28 AM To: [EMAIL PROTECTED] Subject: Re: latest client version for Windows We all know that 5.1.0.1 is the latestIs it the greatest? Time will tell :) Just downloaded and will be installing on a machine later today to play around with it. Curt Magura Lockheed Martin EIS Gaithersburg, Md. 301-240-6305 -Original Message- From: Joe Cascanette [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 8:24 AM To: [EMAIL PROTECTED] Subject: latest client version for Windows I am currently running 4.2.1.20 on most of my Windows servers, and have seen a few messages about 4.2.1.30. Is this for another OS?. I looked at the ftp site and it shows only 4.2.1.23 (patch for security problem). I was planning to upgrade all my Window boxes and just want to make sure that I am putting on the lastest and greatest... Thanks Joe -Original Message- From: Frank Kruse [mailto:[EMAIL PROTECTED]] Sent: Fri 4/12/2002 8:00 AM To: [EMAIL PROTECTED] Cc: Subject: Re: TSM db backup. Here is some additional information that may help in determining my problem. Thanks all. Library: tsm: TSMq library f=d Library Name: DBTAPELIB Library Type: MANUAL Device: Private Category: Scratch Category: External Manager: Shared: No LanFree: ObeyMountRetention: Primary Library Manager: Last Update by (administrator): ADMIN Last Update Date/Time: 03/22/02 12:28:40 -- Device Classes tsm: TSMq devc f=d Device Class Name: 8MMDB Device Access Strategy: Sequential Storage Pool Count: 0 Device Type: 8MM Format: DRIVE Est/Max Capacity (MB): 20,480.0 Mount Limit: 1 Mount Wait (min): 60 Mount Retention (min): 10 Label Prefix: TSMDBVOL Library: DBTAPELIB Directory: Server Name: Retry Period: Retry Interval: Shared: Last Update by (administrator): ADMIN Last Update Date/Time: 03/22/02 12:46:42 Device Class Name: DBTRIGGER Device Access Strategy: Sequential Storage Pool Count: 0 Device Type: FILE Format: DRIVE Est/Max Capacity (MB): 4.0 Mount Limit: 1 Mount Wait (min): Mount Retention (min): Label Prefix: Library: Directory: /tsm/database/trigger Server Name: Retry Period: Retry Interval: Shared: Last Update by (administrator): ADMIN Last Update Date/Time: 03/05/02 09:42:53 Device Class Name: DISK Device Access Strategy: Random Storage Pool Count: 3 Device Type: Format: Est/Max Capacity (MB): Mount Limit: Mount Wait (min): Mount Retention (min): Label Prefix: Library: Directory: Server Name: Retry Period: Retry Interval: Shared: Last Update by (administrator): Last Update Date/Time: 03/04/02 12:35:15 - Drives: tsm: TSMq drive f=d Library Name: DBTAPELIB Drive Name: DBTAPEMT0 Device Type: 8MM On-Line: Yes Device: /dev/mt0 Element:
Re: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS
My 80% full 25gb FULL DB backup takes 1hr 20 minutes on 9672-x57 going to a 9840 tape. Our 72% full 56Gbyte FULL DB backup takes 1hr to 3590/3494 (SCSI attached) and to 9840/9310 (Fiber attached). Cheers, Henk ten Have.
latest client version for Windows
I am currently running 4.2.1.20 on most of my Windows servers, and have seen a few messages about 4.2.1.30. Is this for another OS?. I looked at the ftp site and it shows only 4.2.1.23 (patch for security problem). I was planning to upgrade all my Window boxes and just want to make sure that I am putting on the lastest and greatest... Thanks Joe -Original Message- From: Frank Kruse [mailto:[EMAIL PROTECTED]] Sent: Fri 4/12/2002 8:00 AM To: [EMAIL PROTECTED] Cc: Subject: Re: TSM db backup. Here is some additional information that may help in determining my problem. Thanks all. Library: tsm: TSMq library f=d Library Name: DBTAPELIB Library Type: MANUAL Device: Private Category: Scratch Category: External Manager: Shared: No LanFree: ObeyMountRetention: Primary Library Manager: Last Update by (administrator): ADMIN Last Update Date/Time: 03/22/02 12:28:40 -- Device Classes tsm: TSMq devc f=d Device Class Name: 8MMDB Device Access Strategy: Sequential Storage Pool Count: 0 Device Type: 8MM Format: DRIVE Est/Max Capacity (MB): 20,480.0 Mount Limit: 1 Mount Wait (min): 60 Mount Retention (min): 10 Label Prefix: TSMDBVOL Library: DBTAPELIB Directory: Server Name: Retry Period: Retry Interval: Shared: Last Update by (administrator): ADMIN Last Update Date/Time: 03/22/02 12:46:42 Device Class Name: DBTRIGGER Device Access Strategy: Sequential Storage Pool Count: 0 Device Type: FILE Format: DRIVE Est/Max Capacity (MB): 4.0 Mount Limit: 1 Mount Wait (min): Mount Retention (min): Label Prefix: Library: Directory: /tsm/database/trigger Server Name: Retry Period: Retry Interval: Shared: Last Update by (administrator): ADMIN Last Update Date/Time: 03/05/02 09:42:53 Device Class Name: DISK Device Access Strategy: Random Storage Pool Count: 3 Device Type: Format: Est/Max Capacity (MB): Mount Limit: Mount Wait (min): Mount Retention (min): Label Prefix: Library: Directory: Server Name: Retry Period: Retry Interval: Shared: Last Update by (administrator): Last Update Date/Time: 03/04/02 12:35:15 - Drives: tsm: TSMq drive f=d Library Name: DBTAPELIB Drive Name: DBTAPEMT0 Device Type: 8MM On-Line: Yes Device: /dev/mt0 Element: Allocated to: Last Update by (administrator): ADMIN Last Update Date/Time: 03/22/02 14:04:12 Cleaning Frequency (Gigabytes/ASNEEDED/NONE): NONE Frank, Have you checked to see if the tape was write-protected? Regards, Demetrius Malbrough UNIX/TSM Administrator -Original Message-
Database Backup
Hi I have a customer who back up his database with server to server. when I do the command Q DB F=D I see that the last complete backup was done on the 4 of February 2002. this is strange because a full database backup is supposed to be done every mourning. When I backup the database to a server devices class doesn't the last backup database date update in the command Q DB f=D? Kvedja/Regards Petur Eythorsson Taeknimadur/Technician IBM Certified Specialist - AIX Tivoli Storage Manager Certified Professional Microsoft Certified System Engineer [EMAIL PROTECTED] Nyherji Hf Simi TEL: +354-569-7700 Borgartun 37105 Iceland URL:http://www.nyherji.is
AW: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS
txs, Matt, i will try. regards Joachim -Ursprüngliche Nachricht- Von: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 12. April 2002 13:48 An: [EMAIL PROTECTED] Betreff: Re: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS I am going over ESCON. I have an issue with TSM that I would watch TSM use more and more CPU and actually do less and less. I found that stopping and starting TSM on a weekly basis would get me past it. I have sent them dumps and logs. They said to STOP draining my DISK pool to 0. SO I am trying that. Anyway, my point is, try bringing TSM down and Up and check the throughput then. It may also be worth your time to check and make sure that TSM is in the proper Work Load Manager service class (of course that is only an issue if the machine is running 100%). Matt -Original Message- From: Schaub Joachim Paul ABX-PROD-ZH [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 7:34 AM To: [EMAIL PROTECTED] Subject: AW: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS ther are no other activ processes, no waits for mountpoints, the db looks o.k., the throughput maybe is limited by ESCON. -Ursprüngliche Nachricht- Von: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 12. April 2002 12:43 An: [EMAIL PROTECTED] Betreff: Re: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS My 80% full 25gb FULL DB backup takes 1hr 20 minutes on 9672-x57 going to a 9840 tape. What else is going on in your TSM system at the time? Expiration processing slows it down quite a bit. Have you gone through the normal steps of maximizing the throughput on your TSM system? Matt -Original Message- From: Schaub Joachim Paul ABX-PROD-ZH [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 4:49 AM To: [EMAIL PROTECTED] Subject: TSM DB Fullbackup 19GB takes 4 hours on OS/390 VTS Dear *SM Gurus The TSM DB Fullbackup (19GB) takes about 4 hours on OS/390 with VTS. I haven't found any descriptions for parallelisation, eg. maxpr or mountp. Is it in the tec. nature, the DB will be backed up in sequenz? tia Joachim Joachim Paul Schaub Abraxas Informatik AG Beckenhofstrasse 23 CH-8090 Zürich Schweiz / Switzerland Telefon: +41 (01) 259 34 41 Telefax: +41 (01) 259 42 82 E-Mail: mailto:[EMAIL PROTECTED] Internet: http://www.abraxas.ch
Re: Redirecting Commands in Scripts
Hi Gerhard, Is there any specific reason you want to make use of a script? Seeing that Tim Williams already answered your question you should in any case look at doing what you want in a different way. What we do - which will give you exactly what you are trying to achieve right now - is to run a batch job with IKJEFT01 utility - making use of an admin cmd line - and issue the QUERY SYSTEM DSM.OUTPUT.QSYSTEM command. Let me know if there is something specific I'm missing in this case - else play around with batch jobs that can be scheduled or run on demand. Cheers Christo --- Hello all, I found questions like this in the archives, but no answers.. One more try = I want to run a script, where one line should look like this: QUERY SYSTEM DSM.OUTPUT.QSYSTEM where DSM.OUTPUT.QSYSTEM is a S390 Filename I want to take to the OFFSITE Location. (This Command works great on the command line, but I want to have it in a script!) However - I tried to do it like this: def script test desc='Test' upd script test QUERY SYSTEM DSM.OUTPUT Result: ANR1454I DEFINE SCRIPT: Command script TEST defined. ANR2002E Missing closing quote character. ANS8001I Return code 3. Any hints how to route an output to a file in a script ? I guess, the problem is, that TSM wants to direct the Output of the Update Stmt to a file - and when doing this, one quote is missing, of course We are running TSM 3.7.5 on S390 (I know, not supported, but I guess this should work on all versions) Regards Gerhard Wolkerstorfer __ The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Absa is neither liable for the proper, complete transmission of the information contained in this communication, any delay in its receipt or that the mail is virus-free.
Re: TSM Client 5.x
Just go to: ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintenance/client/ and it will list all of the client levels, including 5.1. Zoltan Forray Virginia Commonwealth University - University Computing Center e-mail: [EMAIL PROTECTED] - voice: 804-828-4807 Schaub Joachim Paul ABX-PROD-ZH [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/12/2002 09:19 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:TSM Client 5.x i can't find the V5 Client on the Tivoli Page, does anyone have a downloadadress. thx Joachim
Errors Using EBU For v7.3.4 Database On AIX 4.3.3
Hi, I have an oracle database v7.3.4. I'm also using EBU v2.2 and TDP v2.1.10. I'm pretty sure that I have all of my environment variables set correctly, including $NSR_CLIENT for the oracle id. Although I opened a tar with Oracle Support and I used their Metalink website to get information about NSR_CLIENT and adding oracle as an admin, they're not responding to my questions. I also added the oracle id as an admin user in the Tivoli Server Administration interface. Can anyone tell me why I get the following errors during execution of my backup script? oracle@global: ./ebu backup_WDFATST Oracle7 Enterprise Backup Utility: Release 2.2.0.5.0 - Production on Fri Apr 12 08:44:23 2002 Copyright (c) Oracle Corporation 1979, 1996. All rights reserved. CORE Version 3.5.4.0.0 - Production NLSRTL Version 3.2.4.0.0 - Production ORACLE_HOME = /oracle/product/7.3.4 System name:AIX Node name: global Release:3 Version:4 Machine:000936494C00 Tape API: Release 1.1 Tape Management Software: Release 9.9.9.9 Vendor API: DISK Api (Oracle internal only) backing up to /usr/tivoli/tsm/client /api/bin BACKUP job started with pid=50834 on 12-APR-02 08:44 Starting parsing of command script backup_WDFATST backup offline database db_name=WDFATST archivelog=none parallel=2 log=/oracle/product/7.3.4/obackup/log/full-cold-backup.log Ending parsing of command script Starting Catalog Database verification Catalog Database verified Ending Catalog Database verification Starting Instance Manager verification Found Instance Manager (brd) process running with pid = 76940 Ending Instance Manager verification Starting Target Database state verification Connecting to Target Database ORACLE_SID: WDFATST ORACLE_HOME: /oracle/product/7.3.4 DBNAME: WDFATST Username: internal Connected to idle instance. Issuing Statement: STARTUP PFILE=?/dbs/init@.ora DBA MOUNT; Database mounted. Target database state OK Ending Target Database state verification Database Backup job 41 started on 12-APR-02 08:44 Starting Database configuration verification No registration update is needed Target Database information is up to date in catalog Ending Database configuration verification Starting Database job building, involved files are: Parameter file /oracle/product/7.3.4/dbs/initWDFATST.ora Control file /oracle/accting/local/control1 Datafile /wdfa01/system01.dbf Datafile /wdfa01/system02.dbf Datafile /wdfa01/system03.dbf Datafile /wdfa01/system04.dbf Datafile /wdfa03/temp01.dbf Datafile /wdfa01/tools01.dbf Datafile /wdfa02/users01.dbf Datafile /wdfa02/users02.dbf Datafile /wdfa06/users03.dbf Datafile /wdfa05/apd01.dbf Datafile /wdfa01/apd02.dbf Datafile /wdfa01/apd03.dbf Datafile /wdfa06/apx01.dbf Datafile /wdfa03/ard01.dbf Datafile /wdfa02/arx01.dbf Datafile /wdfa03/fad01.dbf Datafile /wdfa02/fax01.dbf Datafile /wdfa03/fndd01.dbf Datafile /wdfa06/fndx01.dbf Datafile /wdfa03/glbald01.dbf Datafile /wdfa02/glbald02.dbf Datafile /wdfa05/glbalx01.dbf Datafile /wdfa01/glbalx02.dbf Datafile /wdfa01/gld01.dbf Datafile /wdfa06/gld02.dbf Datafile /wdfa01/gld03.dbf Datafile /wdfa02/gljed02.dbf Datafile /wdfa04/gljed01.dbf Datafile /wdfa05/gljed03.dbf Datafile /wdfa06/gljex01.dbf Datafile /wdfa05/gljex02.dbf Datafile /wdfa04/gltempd01.dbf Datafile /wdfa05/gltempx01.dbf Datafile /wdfa02/glx01.dbf Datafile /wdfa05/glx02.dbf Datafile /wdfa04/glx03.dbf Datafile /wdfa04/hrd01.dbf Datafile /wdfa05/hrx01.dbf Datafile /wdfa03/pod01.dbf Datafile /wdfa06/pox01.dbf Datafile /wdfa04/ramsd01.dbf Datafile /wdfa04/ramsd02.dbf Datafile /wdfa06/ramsd03.dbf Datafile /wdfa06/ramsx01.dbf Datafile /wdfa03/rgd01.dbf Datafile /wdfa06/rgx01.dbf Datafile /wdfa04/shrd01.dbf Datafile /wdfa04/shrd02.dbf Datafile /wdfa05/shrx01.dbf Datafile /wdfa05/shrx02.dbf Datafile /wdfa02/discvr01.dbf Datafile /wdfa02/rbs2_01.dbf Datafile /wdfa03/rbs2_02.dbf Datafile /wdfa02/rbs2_03.dbf Datafile /wdfa06/rbs2_04.dbf Ending Database job building Starting Shutdown of target database for offline backup Issuing Statement: SHUTDOWN IMMEDIATE; Database dismounted. Database shutdown. Ended Shutdown of target database for offline backup Starting backup to tape Number of parallel I/O streams: 2 Oracle block size: 8192 bytes Disk input/output size: 131072 bytes Maximum tape I/O size: 262144 bytes Buffer size per I/O stream: 1048576 bytes Starting BFS 18821018615472 on
Re: TSM Client 5.x
ftp://service.boulder.ibm.com/storage/tivoli-storage-management/patches/clie nt/v5r1/Windows/ Curt Magura Lockheed Martin EIS Gaithersburg, Md. 301-240-6305 -Original Message- From: Schaub Joachim Paul ABX-PROD-ZH [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:19 AM To: [EMAIL PROTECTED] Subject: TSM Client 5.x i can't find the V5 Client on the Tivoli Page, does anyone have a downloadadress. thx Joachim
Re: TSM Client 5.x
ftp://ftp.software.ibm.com/storage/tivoli-storage-management/maintenance/cli ent/v5r1 -Original Message- From: Schaub Joachim Paul ABX-PROD-ZH [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:19 AM To: [EMAIL PROTECTED] Subject: TSM Client 5.x i can't find the V5 Client on the Tivoli Page, does anyone have a downloadadress. thx Joachim Confidentiality Note: The information transmitted is intended only for the person or entity to whom or which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please delete this material immediately.
Re: Redirecting Commands in Scripts
HI, If you open up dsmc with -comma parameter, all output will be put in a csv file - perfect for perl scripting (and you can redirect your output). We do that every night to mail out a report of backups nightly - also to automatically mail a report of tapes ejecting for offsite storage , and then an hour later, automatically ejects them. dsmadmc -comma -id=admin -pa=password select a.domain_name,a.description, a.num_nodes,b.node_name from domains a,nodes b where a.domain_name = b.domain_na me order by 1,3 | sed 1,9d | grep -v ANS8002I | grep -i -E [a-z] ${DATADIR}/client.table.data (scripts supplied by Suad Musovich) Hope that helps, Jane - Original Message - From: Williams, Tim P {PBSG} [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 12, 2002 8:52 AM Subject: Re: Redirecting Commands in Scripts I put in a marketing requirement a couple of years agoFYI req00072775 redirection is not supported for commands in a script file (just as redirection is not supported for commands run from the server console). -Original Message- From: Gerhard Wolkerstorfer [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 5:26 AM To: [EMAIL PROTECTED] Subject: Redirecting Commands in Scripts Hello all, I found questions like this in the archives, but no answers.. One more try = I want to run a script, where one line should look like this: QUERY SYSTEM DSM.OUTPUT.QSYSTEM where DSM.OUTPUT.QSYSTEM is a S390 Filename I want to take to the OFFSITE Location. (This Command works great on the command line, but I want to have it in a script!) However - I tried to do it like this: def script test desc='Test' upd script test QUERY SYSTEM DSM.OUTPUT Result: ANR1454I DEFINE SCRIPT: Command script TEST defined. ANR2002E Missing closing quote character. ANS8001I Return code 3. Any hints how to route an output to a file in a script ? I guess, the problem is, that TSM wants to direct the Output of the Update Stmt to a file - and when doing this, one quote is missing, of course We are running TSM 3.7.5 on S390 (I know, not supported, but I guess this should work on all versions) Regards Gerhard Wolkerstorfer
Install Failure on TSM AIX 4.2.1.11 client-help!
Enviro: H70 AIX 4.3.3 ML04 TSM server 4.2.1.10 Existing TSM client 3.7.3.0 I am attempting to install the TSM AIX client 4.2.1.11, and am getting the following unpacking error: I have re-downloaded the file 2 times now and ftp'd it over to the H70 (ftp -i etc., then binary). Can anyone shed some light how I might get around this?? Pre-install tasks for the TSM Backup/Archive Client completed. Mount volume 2 on /tmp/tsm.client/IP22367.tivoli.tsm.client.ba.aix43.32bit. Press the Enter key to continue. 0503-700 inurest: Error in restoring files 0503-037 inurest: Failure on system call to execute command /usr/sbin/restbynam e -S -xYAqf/tmp/tsm.client/IP22367.tivoli.tsm.client.ba.aix43.32bit -Z /tmp/inu tmpDtg97a/sorted.al. restore: 0511-107 Cannot read from pipe. There is an unpacking error. restore: 0511-708 There is an internal unpacking error: decode failure Ken Sedlacek AIX/TSM/UNIX Administrator [EMAIL PROTECTED] IBM Certified Specialist: RS/6000 AIX v4.3 Support IBM Certified Specialist: RS/6000 SP PSSP 3 Tivoli Certified Consultant - Tivoli Storage Manager v4.1
Logical volume Snapshot, to enable 'online' image backups.
Hi Fellow comrades. I am searching for information on how to take Online Image Backups in W2k. with TSM Client 5.1 I know I hasn't read the manual (so don't RTFM me :/ ). how do I do it. Do I need the TSM Server 5 for it or can I do it with TSM Sever 4 thanks in advance Kvedja/Regards Petur Eythorsson Taeknimadur/Technician IBM Certified Specialist - AIX Tivoli Storage Manager Certified Professional Microsoft Certified System Engineer [EMAIL PROTECTED] Nyherji Hf Simi TEL: +354-569-7700 Borgartun 37105 Iceland URL:http://www.nyherji.is
Re: windows2000/NT client schedulers failing intermittently -Clash with NORTON AV ???
have you checked out the W2K event viewer. is there anything there you can find. Kvedja/Regards Petur Eythorsson Taeknimadur/Technician IBM Certified Specialist - AIX Tivoli Storage Manager Certified Professional Microsoft Certified System Engineer [EMAIL PROTECTED] Nyherji Hf Simi TEL: +354-569-7700 Borgartun 37105 Iceland URL:http://www.nyherji.is -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Kwiatek Sent: 12. apríl 2002 13:26 To: [EMAIL PROTECTED] Subject: windows2000/NT client schedulers failing intermittently -Clash with NORTON AV ??? Hello, I am constantly having a good portion of my 900 TSM 4.2.1.30 and 4.2.1.20 client schedulers fail abrutly. The dsmsched.log show files being sent to the server, and then NOTHING. The log just ends. The scheduler is stopped. Nothing in the error log. Someone said that Norton AV may be interfering with TSM. Anyone else have anything to confirm. ? Keith
windows2000/NT client schedulers failing intermittently -Clash with NORTON AV ???
Hello, I am constantly having a good portion of my 900 TSM 4.2.1.30 and 4.2.1.20 client schedulers fail abrutly. The dsmsched.log show files being sent to the server, and then NOTHING. The log just ends. The scheduler is stopped. Nothing in the error log. Someone said that Norton AV may be interfering with TSM. Anyone else have anything to confirm. ? Keith
Re: 3494 library swap out.
Maybe more of a generic way that doesn't depend on any specific OSuse a SQL command: select 'checkout libv ' || trim(library_name) || ' ' || trim(volume_name) || ' checkl=no rem=no' from libvolumes and pipe this to a file. You can then run it in as a MACRO libr Lindsay suggests. You may have to SET SQLDISPLAYMODE WIDE to get it all on one line. This doesn't rely on catawk.MSWord...or any utility. Just a TSM admin client. There's more than one way to skin a cat! :-) Whatever you're comfortable with. Myself, with going to different client sites with different systems, I just don't like to come to rely on a solution on a particular platform. No offense intended! Just my $.02 worth. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Mr. Lindsay Morris Sent: Thursday, April 11, 2002 9:45 PM To: [EMAIL PROTECTED] Subject: Re: 3494 library swap out. I guess different people like different tools...I'm a command-line bigot. The idea of turning a list of volumes into a script is a very good idea. Here's a unix-ified way to do it for those who will, maybe faster: 1. Obtain a list of volumes (or stgpools, or...) into a file, say, /tmp/vols 2. cat /tmp/vols | awk '{print checkout libv library_name $1 checkl=no rem=no}' /tmp/macro vol name is here ^^ 3. dsmadmc -id=... -pas=... -itemcommit macro /tmp/macro itemcommit means if one line fails, don't roll back the whole script Not trying to one-up you, Tab - people more comfortable with MS Word should use it. The idea is great. I often see people doing stuff like this manually, and it makes me cringe. Thanks for the post. - Mr. Lindsay Morris CEO, Servergraph www.servergraph.com 859-253-8000 ofc 425-988-8478 fax -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Tab Trepagnier Sent: Thursday, April 11, 2002 6:56 PM To: [EMAIL PROTECTED] Subject: Re: 3494 library swap out. Geoffrey, Whenever I have to do similar operations on lots of volumes, I use my word processor's (MS Word in this case) mail merge feature to help. The sequence goes like this. 1. Obtain a list of volumes to be processed. If the volume name is the only thing that will change, you can save to a text file. But text files only accommodate one variable. If more variables (fields) are needed, use the native WP doc format. 2. Select the file from step 1 as the data source. 3. Create the master document with the desired command line like: checkout libv library_name [volume] checkl=no remove=no where volume is the merge field to be used for the final document. 4. Merge the data. You will end up with a document that has a line from step 3 for each volume. 5. Because that document will be in the native WP format, do a Save As...text of the document. 6. Reopen the text version of the document. You will have a script. 7. Paste that text document's contents into the text entry window of the Create Script page of the TSM web client. The final result will be a server script consisting of the command from step 3 for each volume. 8. Execute the server script in TSM. I know this sounds a bit complicated, but once you've done it a time or two, you can create in less that five minutes scripts that process thousands of volumes. This technique was vital when I was doing our data reorg after the library upgrades and I had to Move Data the contents of hundreds of tapes. Good luck. Tab Trepagnier TSM Administrator Laitram Corporation Gill, Geoffrey L. [EMAIL PROTECTED]@VM.MARIST.EDU on 04/11/2002 12:34:16 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: 3494 library swap out. On Monday IBM will be removing a leased 3494 and installing a replacement 3494. The library is shared with MVS but MVS has it's own set of tapes and exits ignore my tapes(TSM 4.2.1.9 on AIX 4.3.3) when they are inserted. It's been sugested I checkout all of my tapes, some 800 or so, probably with a remove=no since a 10 slot I/O port would slow things down. IBM says they need to remove all the tapes so they can re-level the library once they put it together. So now questions: (I am not concerned with the MVS side of things since someone else takes care of that.) Do I really need to do this? If yes, is there an easy way to do this or amI going to have to struggle through it? How about getting them back in/available? Should I be doing any TSM inventory? If anyone ahs gone through this or has suggestions please, please send them. Thanks, Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
Exclude NDS object
I need to exclude an NDS object from backing up. Is this the correct format? EXCLUDE.DIRNDS:.O=SBHD.OU=ZEN_APPLICATIONS* Bruce Kamp Network Analyst II Memorial Healthcare System Ph: (954) 987-2020 x4597 Fax: (954) 985-1404 E: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: dbvol create error on AIX
is /var/adsmdbl the filesystem? I think the only ways you can do it is the logical volume which would be /dev/radsmdbl in this case or a file /var/adsmdbl/filename but not as a filesystem. Becky -Original Message- From: Lawrence Clark [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:07 AM To: [EMAIL PROTECTED] Subject: dbvol create error on AIX Hi:Anyone seen this error before? Filesystem1024-blocks Free %UsedIused %Iused Mounted on /dev/adsmdbl 1048576 10156124% 17 1% /var/adsmdbl 04/12/02 10:01:42 ANR2017I Administrator ADMIN issued command: DEFINE DBVOLUME /var/adsmdbl formatsize=980 wait=yes 04/12/02 10:01:42 ANR0984I Process 104534 for DEFINE DBVOLUME started in the FOREGROUND at 10:01:42. 04/12/02 10:01:42 ANR7865W Unable to create volume /var/adsmdbl. Return code=107. 04/12/02 10:01:42 ANR0985I Process 104534 for DEFINE DBVOLUME running in the FOREGROUND completed with completion state FAILURE at 10:01:42.
Re: Logical volume Snapshot, to enable 'online' image backups.
You need the TSM V5 server. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Pétur Eyþórsson [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/12/2002 06:52 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Logical volume Snapshot, to enable 'online' image backups. Hi Fellow comrades. I am searching for information on how to take Online Image Backups in W2k. with TSM Client 5.1 I know I hasn't read the manual (so don't RTFM me :/ ). how do I do it. Do I need the TSM Server 5 for it or can I do it with TSM Sever 4 thanks in advance Kvedja/Regards Petur Eythorsson Taeknimadur/Technician IBM Certified Specialist - AIX Tivoli Storage Manager Certified Professional Microsoft Certified System Engineer [EMAIL PROTECTED] Nyherji Hf Simi TEL: +354-569-7700 Borgartun 37105 Iceland URL:http://www.nyherji.is
Re: 3494 library swap out.
Gosh, Bill, that's even better! Now if we could just cut it down to zero steps... - Mr. Lindsay Morris CEO, Servergraph www.servergraph.com 859-253-8000 ofc 425-988-8478 fax -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Boyer Sent: Friday, April 12, 2002 10:29 AM To: [EMAIL PROTECTED] Subject: Re: 3494 library swap out. Maybe more of a generic way that doesn't depend on any specific OSuse a SQL command: select 'checkout libv ' || trim(library_name) || ' ' || trim(volume_name) || ' checkl=no rem=no' from libvolumes and pipe this to a file. You can then run it in as a MACRO libr Lindsay suggests. You may have to SET SQLDISPLAYMODE WIDE to get it all on one line. This doesn't rely on catawk.MSWord...or any utility. Just a TSM admin client. There's more than one way to skin a cat! :-) Whatever you're comfortable with. Myself, with going to different client sites with different systems, I just don't like to come to rely on a solution on a particular platform. No offense intended! Just my $.02 worth. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Mr. Lindsay Morris Sent: Thursday, April 11, 2002 9:45 PM To: [EMAIL PROTECTED] Subject: Re: 3494 library swap out. I guess different people like different tools...I'm a command-line bigot. The idea of turning a list of volumes into a script is a very good idea. Here's a unix-ified way to do it for those who will, maybe faster: 1. Obtain a list of volumes (or stgpools, or...) into a file, say, /tmp/vols 2. cat /tmp/vols | awk '{print checkout libv library_name $1 checkl=no rem=no}' /tmp/macro vol name is here ^^ 3. dsmadmc -id=... -pas=... -itemcommit macro /tmp/macro itemcommit means if one line fails, don't roll back the whole script Not trying to one-up you, Tab - people more comfortable with MS Word should use it. The idea is great. I often see people doing stuff like this manually, and it makes me cringe. Thanks for the post. - Mr. Lindsay Morris CEO, Servergraph www.servergraph.com 859-253-8000 ofc 425-988-8478 fax -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Tab Trepagnier Sent: Thursday, April 11, 2002 6:56 PM To: [EMAIL PROTECTED] Subject: Re: 3494 library swap out. Geoffrey, Whenever I have to do similar operations on lots of volumes, I use my word processor's (MS Word in this case) mail merge feature to help. The sequence goes like this. 1. Obtain a list of volumes to be processed. If the volume name is the only thing that will change, you can save to a text file. But text files only accommodate one variable. If more variables (fields) are needed, use the native WP doc format. 2. Select the file from step 1 as the data source. 3. Create the master document with the desired command line like: checkout libv library_name [volume] checkl=no remove=no where volume is the merge field to be used for the final document. 4. Merge the data. You will end up with a document that has a line from step 3 for each volume. 5. Because that document will be in the native WP format, do a Save As...text of the document. 6. Reopen the text version of the document. You will have a script. 7. Paste that text document's contents into the text entry window of the Create Script page of the TSM web client. The final result will be a server script consisting of the command from step 3 for each volume. 8. Execute the server script in TSM. I know this sounds a bit complicated, but once you've done it a time or two, you can create in less that five minutes scripts that process thousands of volumes. This technique was vital when I was doing our data reorg after the library upgrades and I had to Move Data the contents of hundreds of tapes. Good luck. Tab Trepagnier TSM Administrator Laitram Corporation Gill, Geoffrey L. [EMAIL PROTECTED]@VM.MARIST.EDU on 04/11/2002 12:34:16 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: 3494 library swap out. On Monday IBM will be removing a leased 3494 and installing a replacement 3494. The library is shared with MVS but MVS has it's own set of tapes and exits ignore my tapes(TSM 4.2.1.9 on AIX 4.3.3) when they are inserted. It's been sugested I checkout all of my tapes, some 800 or so, probably with a remove=no since a 10 slot I/O port would slow things down. IBM says they need to remove all the tapes so they can re-level the library once they put it together. So now questions: (I am
tsm 5.1 for os390 ????
has anyone heard if 5.1 for os390 is available Tim Brown Systems Specialist Information Systems Central Hudson Gas Electric tel: 845-486-5643 fax: 845-586-5921
Re: dbvol create error on AIX
Yes, BeckyI realized that after I sent the note. Needed /var/adsmdbl/dbvoll [EMAIL PROTECTED] 04/12/02 10:33AM is /var/adsmdbl the filesystem? I think the only ways you can do it is the logical volume which would be /dev/radsmdbl in this case or a file /var/adsmdbl/filename but not as a filesystem. Becky -Original Message- From: Lawrence Clark [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:07 AM To: [EMAIL PROTECTED] Subject: dbvol create error on AIX Hi:Anyone seen this error before? Filesystem1024-blocks Free %UsedIused %Iused Mounted on /dev/adsmdbl 1048576 10156124% 17 1% /var/adsmdbl 04/12/02 10:01:42 ANR2017I Administrator ADMIN issued command: DEFINE DBVOLUME /var/adsmdbl formatsize=980 wait=yes 04/12/02 10:01:42 ANR0984I Process 104534 for DEFINE DBVOLUME started in the FOREGROUND at 10:01:42. 04/12/02 10:01:42 ANR7865W Unable to create volume /var/adsmdbl. Return code=107. 04/12/02 10:01:42 ANR0985I Process 104534 for DEFINE DBVOLUME running in the FOREGROUND completed with completion state FAILURE at 10:01:42.
Re: dbvol create error on AIX
Try dsmfmt command and use define dbvol. From: Lawrence Clark [EMAIL PROTECTED] on 04/12/2002 10:07 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: dbvol create error on AIX Hi:Anyone seen this error before? Filesystem1024-blocks Free %UsedIused %Iused Mounted on /dev/adsmdbl 1048576 10156124% 17 1% /var/adsmdbl 04/12/02 10:01:42 ANR2017I Administrator ADMIN issued command: DEFINE DBVOLUME /var/adsmdbl formatsize=980 wait=yes 04/12/02 10:01:42 ANR0984I Process 104534 for DEFINE DBVOLUME started in the FOREGROUND at 10:01:42. 04/12/02 10:01:42 ANR7865W Unable to create volume /var/adsmdbl. Return code=107. 04/12/02 10:01:42 ANR0985I Process 104534 for DEFINE DBVOLUME running in the FOREGROUND completed with completion state FAILURE at 10:01:42.
Re: TSM V5.1
Hi Andy! The 5.1.01 ODBC driver installation does not work. During installation one is prompted for the location of the file Tivoli Storage Manager ODBC Driver.msi. If you point to that file (by default: C:\TEMP\tsmcli\win32\odbc\disk1) it says that it's not a valid installation package... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 14:19 To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Yes, and be sure to get the 5.1.0.1 Windows clients from the FTP site, vs. the 5.1.0.0 clients shipped on the CD. As someone pointed out yesterday, we now have a 4.2.1.32 client to address APAR IC33211 (The TSM V4.2 Windows NT-based client acceptor service may crash if improperly formatted data is received from the HTTP port), and this APAR is fixed in 5.1.0.1 as well. For ODBC driver users, be sure to get the 5.1.0.1 ODBC driver as well. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/12/2002 02:42 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM V5.1 The 5.1 clients are also available for download now. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Jonathan Siegle [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 21:41 To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Got mine on Monday. I really liked the TSM 5.1 cd with 4.2 functional level software... On Thu, 11 Apr 2002, Gill, Geoffrey L. wrote: Hey everyone, I just got my TSM V5.1 package of software. Anyone else get so lucky? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154 Jonathan Siegle Center for Academic Computing [EMAIL PROTECTED] Penn State University 814-865-5840University Park, Pa 16802 ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
I/O error reading label of volume in drive 3580
Hi, I have a tape drive 3580 and TSM 4.1.5.3 in NT. When I do a restore with two tapes I receive the following message: ANR8326I 001: Mount LTO volume TSM001 R/W in drive LTO (\\.\TAPE0) of = library LTOLIB within 118 minutes.=20 ANR8335I 001: Verifying label of LTO volume TSM001 in drive LTO = (\\.\TAPE0).=20 ANR8353E 001: I/O error reading label of volume in drive LTO = (\\.\TAPE0).=20 ANR8326I 001: Mount LTO volume TSM001 R/W in drive LTO (\\.\TAPE0) of = library LTOLIB within 118 minutes.=20 The other tapes are working without problems. Has someone any suggestion? its a problem with the TSM version or with the 3580 LTO? Henry Aranda _ Send and receive Hotmail on your mobile device: http://mobile.msn.com
Re: TSM V5.1
H... not a good sign. I downloaded the driver this morning and verified the install myself, and it went alright. Do you have an existing ODBC driver installed? If so, which version? I suspect that this could be an issue with removing the older ODBC driver. Try this: 1) From Add/Remove Programs, remove the old ODBC driver. 2) You may get a prompt similar to the above. If so, go get the install package for that driver, and extract the install image (but don't run setup). Then try the uninstall again. If prompted, point to the .msi file in the old driver's install image (the one you just unpacked). 3) If that works, then try installing the new driver. Let me know how this goes. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/12/2002 07:48 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM V5.1 Hi Andy! The 5.1.01 ODBC driver installation does not work. During installation one is prompted for the location of the file Tivoli Storage Manager ODBC Driver.msi. If you point to that file (by default: C:\TEMP\tsmcli\win32\odbc\disk1) it says that it's not a valid installation package... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 14:19 To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Yes, and be sure to get the 5.1.0.1 Windows clients from the FTP site, vs. the 5.1.0.0 clients shipped on the CD. As someone pointed out yesterday, we now have a 4.2.1.32 client to address APAR IC33211 (The TSM V4.2 Windows NT-based client acceptor service may crash if improperly formatted data is received from the HTTP port), and this APAR is fixed in 5.1.0.1 as well. For ODBC driver users, be sure to get the 5.1.0.1 ODBC driver as well. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/12/2002 02:42 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM V5.1 The 5.1 clients are also available for download now. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Jonathan Siegle [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 21:41 To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Got mine on Monday. I really liked the TSM 5.1 cd with 4.2 functional level software... On Thu, 11 Apr 2002, Gill, Geoffrey L. wrote: Hey everyone, I just got my TSM V5.1 package of software. Anyone else get so lucky? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154 Jonathan Siegle Center for Academic Computing [EMAIL PROTECTED] Penn State University 814-865-5840University Park, Pa 16802 ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Unload DB/LoadDB
I have a 45GB database. It is approximately 11,500,000 pages. Has anyone tried or had success using the Unload/Load DB? Is there another way that I can reduce this? I have my ACTLOG retention set for 4 days. I think what is holding me back is we have our OFFSITE copy pool set for . We send everything offsite forever (Not my idea). Matt Adamson, MCSE NDC MS Hardware Support *desk:425.288.6286 *cell:206.601.8561 *mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: ASR on NT Novell servers/clients
Hi SMer's, Anybody have any info. on TSM backups causing ASR (Automatic Server Recover (reboot)) on servers? We seem to be getting them at night during backups and we are not missing anything as far as the backup is concerned but this is causing trouble on the client side. We do have MacAffee running during backups which could be an issue. And there have been 3 boxes that have done this 2 Novells are at 4.1.2 on TSM and 5.0 on Netware. and the 1 Windows 2000 is at 4.2.1.18 on TSM and service pack 2 on Win 2000. Thanx in advanced
3494 library swap out
Ok, lots of help here from Bill, Lindsay and Tab, and I appreciate it very much. Now here is a stab at the steps I need to take. Since I'm not much of a script/programmer I'd appreciate any help in correcting mistakes I've made. Note: This will be done from an AIX console on the TSM server. Step1: SET SQLDISPLAYMODE WIDE Step2: select 'checkout libv ' || trim(library_name) || ' ' || trim(volume_name) || ' checkl=no rem=no' from libvolumes /tmp/vols Step3: cat /tmp/vols | awk '{print checkout libv library_name $1 checkl=no rem=no}' /tmp/macro Step4: dsmadmc -id=... -pas=... -itemcommit macro /tmp/macro The output of the file in step2 goes like this: checkout libv 3494LIB U8 checkl=no rem=no checkout libv 3494LIB U00026 checkl=no rem=no checkout libv 3494LIB U00244 checkl=no rem=no checkout libv 3494LIB U00302 checkl=no rem=no And so on and so on. I'm sure my step3, which I took direct from the email Lindsay sent, needs work. A little help..again please. Thanks, Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
Error: Unable to update filespace on server
Hi *SM-ers! Server: AIX 4.3.3ml8 TSM4.2.1.9. Client: AIX 4.3.3ml8 TSM4.2.1.0. When he tries to backup a filesystem he receives the following error in the dsmerror.log: fsCheckAdd: unable to update filespace on server ANS1228E Sending of object '/appl0001' failed ANS1301E Server detected system error On the server side I receive: Transaction failed for session 117296 for node KL1000YG (AIX) - internal server error detected. I can't find any APAR for this, anybody seen this before? Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: ASR on NT Novell servers/clients
Hi William, do you mean the Novell servers abend and the NT server's blue-screen? I have never heard of ASR (automatic server recover)??? Mark -Original Message- From: William Rosette [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 11:52 AM To: [EMAIL PROTECTED] Subject: Re: ASR on NT Novell servers/clients Hi SMer's, Anybody have any info. on TSM backups causing ASR (Automatic Server Recover (reboot)) on servers? We seem to be getting them at night during backups and we are not missing anything as far as the backup is concerned but this is causing trouble on the client side. We do have MacAffee running during backups which could be an issue. And there have been 3 boxes that have done this 2 Novells are at 4.1.2 on TSM and 5.0 on Netware. and the 1 Windows 2000 is at 4.2.1.18 on TSM and service pack 2 on Win 2000. Thanx in advanced Confidentiality Note: The information transmitted is intended only for the person or entity to whom or which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please delete this material immediately.
Re: TSM V5.1
Right off the bat on the 5.1 client on WinXP - preschedulecommand scripts actually return an error level (I'm seeing RC=12) that will halt the schedule where they did not with version 4. -Original Message- From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:49 AM To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Hi Andy! The 5.1.01 ODBC driver installation does not work. During installation one is prompted for the location of the file Tivoli Storage Manager ODBC Driver.msi. If you point to that file (by default: C:\TEMP\tsmcli\win32\odbc\disk1) it says that it's not a valid installation package... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 14:19 To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Yes, and be sure to get the 5.1.0.1 Windows clients from the FTP site, vs. the 5.1.0.0 clients shipped on the CD. As someone pointed out yesterday, we now have a 4.2.1.32 client to address APAR IC33211 (The TSM V4.2 Windows NT-based client acceptor service may crash if improperly formatted data is received from the HTTP port), and this APAR is fixed in 5.1.0.1 as well. For ODBC driver users, be sure to get the 5.1.0.1 ODBC driver as well. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/12/2002 02:42 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM V5.1 The 5.1 clients are also available for download now. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Jonathan Siegle [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 21:41 To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Got mine on Monday. I really liked the TSM 5.1 cd with 4.2 functional level software... On Thu, 11 Apr 2002, Gill, Geoffrey L. wrote: Hey everyone, I just got my TSM V5.1 package of software. Anyone else get so lucky? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154 Jonathan Siegle Center for Academic Computing [EMAIL PROTECTED] Penn State University 814-865-5840University Park, Pa 16802 ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: TSM database maximum recommended size
On Fri, 12 Apr 2002, Darrel Gleddie wrote: A further comment on this subject: I will be transplanting a moderately sized TSM server from an H50 to a 7026-6H1. I have just completed a trial run, to determine how long the process is going to take. I used the latest full dbbackup from the H50, and did a dbrstore on the new hardware. And, just for fun, I ran an audit db on the transplant. Both the old and new hardware use raid-5 ssa for the database, the new hardware has 4 processors (600 MHZ) with 8 GB memory. For your planning purposes, here's the stats from this environment: dbsize 73,656 MB @ 84% dbbackup03:32 dbrestore 04:03 auditdb 47:28 I have been curious about these numbers. Could you tell me why a 74gig db takes 4 hours to restore off of 3590K tape using a 3590E1A drive and also why it takes 3 1/2 hours to write? These numbers suggest a 3-4MB Read and a 4-5 MB write. Why not 11-12MB for both? Both dbbackup and restore were done from a 3590 K. And, thankfully, the audit ran cleanly. Darrel Gleddie IBM Almaden Research Center Jonathan Siegle Center for Academic Computing [EMAIL PROTECTED] Penn State University
DB Volumes
Question: Lets say I have 4 36gb disks. Is it better to create one db volume sized at 33gb on 2 disks, and mirror it on the others, or should you create 2 16.5gb db volumes on each 36gb disk and mirror those on the other 2 disks? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
Restore NSS data, Netware 5
Hello all, I am new to the list, so please forgive any improprieties. I promise I will learn! The environment is TSM server 4.1.4.0 running on an AIX box (4.3 something, I think). Client machine is a server running Netware 5, service pack 3, with TSM client 4.1.3.0. This is a machine that I have just recently adopted(?) and am trying to do a restore on. The problem is that the data to restore is on an NSS volume and the restore just will not work. I have tried restoring to the NSS volume, to another non-NSS volume on the same server and to a non-NSS volume on a different server (NW5, SP5, TSM 4.1.3.0). No luck anywhere. The messages I get back are: 04/11/2002 14:25:35 (TSA500.NLM 5.1 258) This program has encountered a buffer underflow and cannot get the entire field. ** Unsuccessful ** 04/11/2002 14:25:35 ANS4024E Error processing 'USERS:/TEST.TXT': file write error Has anyone else seen this, or anything like it? I think I have narrowed it down to a problem directly related to restoring NSS data. IBM is telling me that is has to do with the version of the TSA500.NLM in the service pack. Getting the same error when trying to restore to the alternate server, with a newer service pack, makes me question that suggestion. I really appreciate any help anyone can offer. I have searched the archives, BTW, and not come up with anything particularly helpful. Thanks. Rich -- Richard Seifert, Jr Ass't Director of Network Operations Clarkson University - CIS Potsdam, NY 13699 (315) 268-6725 [EMAIL PROTECTED]
Re: 3494 library swap out
Don't use step 3 if you use step 2. they do the same thing in different ways. The output of step2 looks like a perfectly valid macro. Just run step 4. - Mr. Lindsay Morris CEO, Servergraph www.servergraph.com 859-253-8000 ofc 425-988-8478 fax -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Gill, Geoffrey L. Sent: Friday, April 12, 2002 12:38 PM To: [EMAIL PROTECTED] Subject: 3494 library swap out Ok, lots of help here from Bill, Lindsay and Tab, and I appreciate it very much. Now here is a stab at the steps I need to take. Since I'm not much of a script/programmer I'd appreciate any help in correcting mistakes I've made. Note: This will be done from an AIX console on the TSM server. Step1: SET SQLDISPLAYMODE WIDE Step2: select 'checkout libv ' || trim(library_name) || ' ' || trim(volume_name) || ' checkl=no rem=no' from libvolumes /tmp/vols Step3: cat /tmp/vols | awk '{print checkout libv library_name $1 checkl=no rem=no}' /tmp/macro Step4: dsmadmc -id=... -pas=... -itemcommit macro /tmp/macro The output of the file in step2 goes like this: checkout libv 3494LIB U8 checkl=no rem=no checkout libv 3494LIB U00026 checkl=no rem=no checkout libv 3494LIB U00244 checkl=no rem=no checkout libv 3494LIB U00302 checkl=no rem=no And so on and so on. I'm sure my step3, which I took direct from the email Lindsay sent, needs work. A little help..again please. Thanks, Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
Re: TSM V5.1
Yes, you've discovered a new feature. If you are using PRESCHEDULECMD, then presumably you have some operation that you wish to complete prior to the scheduled TSM operation (i.e. shut down a database before incremental backup runs). In 5.1, we changed PRESCHEDULECMD so that if the command does end with return code 0, then the scheduled operation will not run. This change was based on user requirements. From the use rmanual, in the section on what's new in 5.1: == Reliable, consistent, and documented return codes have been added to the command line client and the scheduler. This facilitates automation of client operations via user-written scripts. By using the QUERY EVENT command with the FORMAT=DETAILED option, administrators can now distinguish between scheduled backups that completed successfully with no skipped files and scheduled backups that completed successfully with one or more skipped files. Also if you use the processing option preschedulecmd to run a command, and that command returns a non-zero return code, the scheduled event will not run. This ensures that scheduled events will not run if prerequisite commands do not complete successfully. See Return Codes from the Command Line Interface, Preschedulecmd/Prenschedulecmd, and Postschedulecmd/Postnschedulecmd for more information. == Alternatively, if the command does not need to complete prior to running the scheduled operation, you can use PRENSCHEDULECMD, which runs asynchronously, and whose return code is not tracked. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Jolliff, Dale [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/12/2002 10:10 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM V5.1 Right off the bat on the 5.1 client on WinXP - preschedulecommand scripts actually return an error level (I'm seeing RC=12) that will halt the schedule where they did not with version 4. -Original Message- From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:49 AM To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Hi Andy! The 5.1.01 ODBC driver installation does not work. During installation one is prompted for the location of the file Tivoli Storage Manager ODBC Driver.msi. If you point to that file (by default: C:\TEMP\tsmcli\win32\odbc\disk1) it says that it's not a valid installation package... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 14:19 To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Yes, and be sure to get the 5.1.0.1 Windows clients from the FTP site, vs. the 5.1.0.0 clients shipped on the CD. As someone pointed out yesterday, we now have a 4.2.1.32 client to address APAR IC33211 (The TSM V4.2 Windows NT-based client acceptor service may crash if improperly formatted data is received from the HTTP port), and this APAR is fixed in 5.1.0.1 as well. For ODBC driver users, be sure to get the 5.1.0.1 ODBC driver as well. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/12/2002 02:42 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM V5.1 The 5.1 clients are also available for download now. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Jonathan Siegle [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 21:41 To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Got mine on Monday. I really liked the TSM 5.1 cd with 4.2 functional level software... On Thu, 11 Apr 2002, Gill, Geoffrey L. wrote: Hey everyone, I just got my TSM V5.1 package of software. Anyone else get so lucky? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154 Jonathan Siegle Center for Academic Computing [EMAIL PROTECTED] Penn State University 814-865-5840University Park, Pa 16802 ** For information, services and offers, please visit our web site:
Re: ASR on NT Novell servers/clients
No on both accounts. The server reboots itself, and the only way of knowing is through event viewer. Remeta, Mark MRemeta@SELIGMA To: [EMAIL PROTECTED] NDATA.COM cc: Sent by: ADSM:Subject: Re: ASR on NT Novell servers/clients Dist Stor Manager [EMAIL PROTECTED] T.EDU 04/12/02 01:08 PM Please respond to ADSM: Dist Stor Manager Hi William, do you mean the Novell servers abend and the NT server's blue-screen? I have never heard of ASR (automatic server recover)??? Mark -Original Message- From: William Rosette [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 11:52 AM To: [EMAIL PROTECTED] Subject: Re: ASR on NT Novell servers/clients Hi SMer's, Anybody have any info. on TSM backups causing ASR (Automatic Server Recover (reboot)) on servers? We seem to be getting them at night during backups and we are not missing anything as far as the backup is concerned but this is causing trouble on the client side. We do have MacAffee running during backups which could be an issue. And there have been 3 boxes that have done this 2 Novells are at 4.1.2 on TSM and 5.0 on Netware. and the 1 Windows 2000 is at 4.2.1.18 on TSM and service pack 2 on Win 2000. Thanx in advanced Confidentiality Note: The information transmitted is intended only for the person or entity to whom or which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please delete this material immediately.
Re: DB Volumes
On aix, I prefer to make a 73GB striped volume, then mirror it to the other disks. Use the smallest stripe width (4k). If you are not on AIX, then I don't know if you can stripe or not. Andy Carlson|\ _,,,---,,_ Senior Technical Specialist ZZZzz /,`.-'`'-. ;-;;,_ BJC Health Care|,4- ) )-,_. ,\ ( `'-' St. Louis, Missouri '---''(_/--' `-'\_) Cat Pics: http://andyc.dyndns.org/animal.html On Fri, 12 Apr 2002, Gill, Geoffrey L. wrote: Question: Lets say I have 4 36gb disks. Is it better to create one db volume sized at 33gb on 2 disks, and mirror it on the others, or should you create 2 16.5gb db volumes on each 36gb disk and mirror those on the other 2 disks? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
Re: TSM database maximum recommended size
A further comment on this subject: I will be transplanting a moderately sized TSM server from an H50 to a 7026-6H1. I have just completed a trial run, to determine how long the process is going to take. I used the latest full dbbackup from the H50, and did a dbrstore on the new hardware. And, just for fun, I ran an audit db on the transplant. Both the old and new hardware use raid-5 ssa for the database, the new hardware has 4 processors (600 MHZ) with 8 GB memory. For your planning purposes, here's the stats from this environment: dbsize 73,656 MB 84% dbbackup03:32 dbrestore 04:03 auditdb 47:28 Both dbbackup and restore were done from a 3590 K. And, thankfully, the audit ran cleanly. Darrel Gleddie IBM Almaden Research Center
*SM 5.1
trivia: The Mac FTP doc file is mostly updated, but says Welcome to the TSM Version 4 Client for Macintosh! cheers, wayne Wayne T. Smith [EMAIL PROTECTED] ADSM Technical Coordinator - UNET University of Maine System
Re: Restore NSS data, Netware 5
Hi Richard, how big is the file USERS:/TEST.TXT? Also what versions are your TSA500, TSANDS, and SMDR nlm's??? Mark -Original Message- From: Richard Seifert, Jr [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: Restore NSS data, Netware 5 Hello all, I am new to the list, so please forgive any improprieties. I promise I will learn! The environment is TSM server 4.1.4.0 running on an AIX box (4.3 something, I think). Client machine is a server running Netware 5, service pack 3, with TSM client 4.1.3.0. This is a machine that I have just recently adopted(?) and am trying to do a restore on. The problem is that the data to restore is on an NSS volume and the restore just will not work. I have tried restoring to the NSS volume, to another non-NSS volume on the same server and to a non-NSS volume on a different server (NW5, SP5, TSM 4.1.3.0). No luck anywhere. The messages I get back are: 04/11/2002 14:25:35 (TSA500.NLM 5.1 258) This program has encountered a buffer underflow and cannot get the entire field. ** Unsuccessful ** 04/11/2002 14:25:35 ANS4024E Error processing 'USERS:/TEST.TXT': file write error Has anyone else seen this, or anything like it? I think I have narrowed it down to a problem directly related to restoring NSS data. IBM is telling me that is has to do with the version of the TSA500.NLM in the service pack. Getting the same error when trying to restore to the alternate server, with a newer service pack, makes me question that suggestion. I really appreciate any help anyone can offer. I have searched the archives, BTW, and not come up with anything particularly helpful. Thanks. Rich -- Richard Seifert, Jr Ass't Director of Network Operations Clarkson University - CIS Potsdam, NY 13699 (315) 268-6725 [EMAIL PROTECTED] Confidentiality Note: The information transmitted is intended only for the person or entity to whom or which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please delete this material immediately.
Re: DB Volumes
In my mind TSM make load balancing when it have different volumes. I'm pretty sure of that with disk storage pool. I don't know for DB Volume. So, for me you should create on volume by physical disk to avoid disk contention. Salutations / Best Regards gGE Medical Systems ___ Eric Boireau Global Systems Server Architect / Technology Infrastructure Team GE Medical Systems S.A 283, rue de la Minière 78533 BUC Cedex France Tél: (33) 1 30 70 39 32, DC: 8*644 3932 Fax: (33) 1 30 70 39 30, DC: 8*644 3930 mailto:[EMAIL PROTECTED] -Original Message- From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 7:08 PM To: [EMAIL PROTECTED] Subject: DB Volumes Question: Lets say I have 4 36gb disks. Is it better to create one db volume sized at 33gb on 2 disks, and mirror it on the others, or should you create 2 16.5gb db volumes on each 36gb disk and mirror those on the other 2 disks? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
RMAN Scripts TDPO Windows
Hi all... I installed TDPO 2.2 in Windows NT, TSM Server 4.2 Win NT, Oracle 8i. I took a full backup using TDPO, I need to restore the data from the full backup but I don4t have scripts of RMAN. Can anybody send me some RMAN scripts where can I restore a full backup? Thanks in Advance... Jorge Rodrmguez Caracas - Venezuela _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx
FW: 3494 library swap out
-Original Message- From: Taw.Raymond Sent: Friday, April 12, 2002 10:45 AM To: 'ADSM: Dist Stor Manager' Subject: RE: 3494 library swap out Please try the following script and let me know #!/usr/bin/ksh ## 3584lib is the TSM library name; replace 3584lib with your TSM library name ## -pass=admin where admin is the password of admin userid; replace admin with your password ADSM=dsmadmc -id=admin -pass=admin $ADSM q libv 3584lib | /usr/bin/awk '/Private/,/Scratch/ {print $1, $2}' |\ while read libname volid do echo checkout libv $libname $volid checkl=no rem=no## comment this line ### $ADSM checkout libv $libname $volid checkl=no rem=no ## uncomment this line done Regards, Raymond Taw -Original Message- From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:38 AM To: [EMAIL PROTECTED] Subject: 3494 library swap out Ok, lots of help here from Bill, Lindsay and Tab, and I appreciate it very much. Now here is a stab at the steps I need to take. Since I'm not much of a script/programmer I'd appreciate any help in correcting mistakes I've made. Note: This will be done from an AIX console on the TSM server. Step1: SET SQLDISPLAYMODE WIDE Step2: select 'checkout libv ' || trim(library_name) || ' ' || trim(volume_name) || ' checkl=no rem=no' from libvolumes /tmp/vols Step3: cat /tmp/vols | awk '{print checkout libv library_name $1 checkl=no rem=no}' /tmp/macro Step4: dsmadmc -id=... -pas=... -itemcommit macro /tmp/macro The output of the file in step2 goes like this: checkout libv 3494LIB U8 checkl=no rem=no checkout libv 3494LIB U00026 checkl=no rem=no checkout libv 3494LIB U00244 checkl=no rem=no checkout libv 3494LIB U00302 checkl=no rem=no And so on and so on. I'm sure my step3, which I took direct from the email Lindsay sent, needs work. A little help..again please. Thanks, Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
client core dump
We have the following situation. The system is a Compaq Alpha 8200 running TRU64 version 5.1 patch level 3. The version of TSM is version 4 release 2 level 0 for TRU64. It starts ok but when we select any of the icons it core dumps with no error message. I deinstalled version 3 and installed version 4 and the problem remained. Then I rebooted and it still core dumps. The system has plenty of memory and swap space available. The problem occurs no matter which user runs dsm. Anyone have any ideas? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
Netware 6 and *SM
So, anyone backing up NW6 with remote, shared drives (I'm used to calling them NSS volumes in 5.1)? I'm testing a NW6 cluster with the latest client, 4.2.1_29 (man we're getting up there!), and the client will only back up the local volumes. The client has no knowledge of these other volumes, which are EMC disk SCSI attached. It works in 5.1, even in the cluster environment, which is not officially supported by IBM. This is a test environment for now but the Intel/NW boys are chomping at the bit to bring NW6 into production. On a related note, anyone know of plans for a NW cluster aware client? -- Jim Kirkman AIS - Systems UNC-Chapel Hill 966-5884
new TSM links for essential information
Harley Puckett over at Tivoli, passed on these brand new links for essential information: With the recent change in Tivoli's web pages we realize that finding some of the more popular and useful TSM web pages has become a bit challenging. The following link should speed up your search time significantly. For information about IBM Tivoli Storage products, fixes, downloads and pubs go here: http://www.tivoli.com/products/solutions/storage/news.html Also this page has links to Fixes and Downloads, Requirements and Supported Devices and Publications for TSM: http://www.tivoli.com/support/storage_mgr/tivolimain.html Sam Giallanza
Re: Restore NSS data, Netware 5
Hello, The file is tiny, a few bytes. I built it for testing. One of the files I am actually trying to restore is about 250M. None of them work. :( Versions of the files are as follows: TSA500.NLM - v5.01 (2/19/99) TSANDS.NLM - v5.00 (9/10/98) SMDR - v5.03 (3/12/99) Thanks for the help. Regards, Rich Remeta, Mark wrote: Hi Richard, how big is the file USERS:/TEST.TXT? Also what versions are your TSA500, TSANDS, and SMDR nlm's??? Mark -Original Message- From: Richard Seifert, Jr [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: Restore NSS data, Netware 5 Hello all, I am new to the list, so please forgive any improprieties. I promise I will learn! The environment is TSM server 4.1.4.0 running on an AIX box (4.3 something, I think). Client machine is a server running Netware 5, service pack 3, with TSM client 4.1.3.0. This is a machine that I have just recently adopted(?) and am trying to do a restore on. The problem is that the data to restore is on an NSS volume and the restore just will not work. I have tried restoring to the NSS volume, to another non-NSS volume on the same server and to a non-NSS volume on a different server (NW5, SP5, TSM 4.1.3.0). No luck anywhere. The messages I get back are: 04/11/2002 14:25:35 (TSA500.NLM 5.1 258) This program has encountered a buffer underflow and cannot get the entire field. ** Unsuccessful ** 04/11/2002 14:25:35 ANS4024E Error processing 'USERS:/TEST.TXT': file write error Has anyone else seen this, or anything like it? I think I have narrowed it down to a problem directly related to restoring NSS data. IBM is telling me that is has to do with the version of the TSA500.NLM in the service pack. Getting the same error when trying to restore to the alternate server, with a newer service pack, makes me question that suggestion. I really appreciate any help anyone can offer. I have searched the archives, BTW, and not come up with anything particularly helpful. Thanks. Rich -- Richard Seifert, Jr Ass't Director of Network Operations Clarkson University - CIS Potsdam, NY 13699 (315) 268-6725 [EMAIL PROTECTED] Confidentiality Note: The information transmitted is intended only for the person or entity to whom or which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please delete this material immediately. -- Richard Seifert, Jr Ass't Director of Network Operations Clarkson University - CIS Potsdam, NY 13699 (315) 268-6725 [EMAIL PROTECTED]
Re: Database Backup
Interesting. When you do a q volhist t=dbb, what's the last backup it has? Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Pétur Eyþórsson [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 5:43 AM To: [EMAIL PROTECTED] Subject: Database Backup Hi I have a customer who back up his database with server to server. when I do the command Q DB F=D I see that the last complete backup was done on the 4 of February 2002. this is strange because a full database backup is supposed to be done every mourning. When I backup the database to a server devices class doesn't the last backup database date update in the command Q DB f=D? Kvedja/Regards Petur Eythorsson Taeknimadur/Technician IBM Certified Specialist - AIX Tivoli Storage Manager Certified Professional Microsoft Certified System Engineer [EMAIL PROTECTED] Nyherji Hf Simi TEL: +354-569-7700 Borgartun 37105 Iceland URL:http://www.nyherji.is
ANS0106E ReadIndex: message index not found for message 12705.
(etc.) for WinNT 5.1 client on Win2k. It turns out that my tsm_images installation directory now has two baclient subdirectories ... one with an older client (probably 4.2.1.??) and the other with files new this month. My installed baclient directory appears to have mostly new files, but DSCAMENG.txt is back-leveled. Reboots, uninstalls and reinstalls do not help. There is no DSM_DIR env. variable set. Bypass: manually copy the newer DSCAMENG.txt file to the production baclient directory. I didn't try it, but suppose that manually discarding the tsm_images directory between uninstall and reinstall probably would have worked. cheers, wayne Wayne T. Smith [EMAIL PROTECTED] ADSM Technical Coordinator - UNET University of Maine System
Re: Database Backup
Hello, First are you sure database backups are done regularly? on the schedule? do q actlog begind=-1 s=database That will tell you if you had a backup going back one day. The best way to check is do q volhist type=dbb and look at the last line. That's the last database backup. Sung Y. Lee E-mail [EMAIL PROTECTED] Pétur Eyþórsson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: ADSM: cc: Dist StorSubject: Database Backup Manager [EMAIL PROTECTED] .EDU 04/12/2002 07:42 AM Please respond to ADSM: Dist Stor Manager Hi I have a customer who back up his database with server to server. when I do the command Q DB F=D I see that the last complete backup was done on the 4 of February 2002. this is strange because a full database backup is supposed to be done every mourning. When I backup the database to a server devices class doesn't the last backup database date update in the command Q DB f=D? Kvedja/Regards Petur Eythorsson Taeknimadur/Technician IBM Certified Specialist - AIX Tivoli Storage Manager Certified Professional Microsoft Certified System Engineer [EMAIL PROTECTED] Nyherji Hf Simi TEL: +354-569-7700 Borgartun 37105 Iceland URL:http://www.nyherji.is
Re: TSM V5.1 - new return codes
I think the addition of return codes is great but have a question on the rc=4 with excluded files: The doc specifies: rc=4: The operation completed successfully, but some files were not processed. There were no other errors or warnings. This return code is very common. Files are not processed for various reasons. The most common reasons are: - The file is in an exclude list.. - The file was in use by another application and could not be accessed by the client - The file changed during the operation to an extent prohibited by the copy serialization attribute. I have a directory with one subdirectory exluded via exclude and exlude.archive. For an incremental of the directory I get rc=0, for an archive or a selective backup I get rc=4. I would rather see a different return code for an excluded file (I'm excluding it so I expect it to not get backed up!). I think a file that is missed because it is open or changed is much more serious than a file that is excluded. Why are the return codes inconsistent between incrementals and selective or archives? Or was my testing incorrect? Thanks, Tim Rushforth City of Winnipeg -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 12:49 PM To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Yes, you've discovered a new feature. If you are using PRESCHEDULECMD, then presumably you have some operation that you wish to complete prior to the scheduled TSM operation (i.e. shut down a database before incremental backup runs). In 5.1, we changed PRESCHEDULECMD so that if the command does end with return code 0, then the scheduled operation will not run. This change was based on user requirements. From the use rmanual, in the section on what's new in 5.1: == Reliable, consistent, and documented return codes have been added to the command line client and the scheduler. This facilitates automation of client operations via user-written scripts. By using the QUERY EVENT command with the FORMAT=DETAILED option, administrators can now distinguish between scheduled backups that completed successfully with no skipped files and scheduled backups that completed successfully with one or more skipped files. Also if you use the processing option preschedulecmd to run a command, and that command returns a non-zero return code, the scheduled event will not run. This ensures that scheduled events will not run if prerequisite commands do not complete successfully. See Return Codes from the Command Line Interface, Preschedulecmd/Prenschedulecmd, and Postschedulecmd/Postnschedulecmd for more information. == Alternatively, if the command does not need to complete prior to running the scheduled operation, you can use PRENSCHEDULECMD, which runs asynchronously, and whose return code is not tracked. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence.
Re: TSM database maximum recommended size
Comments from [EMAIL PROTECTED] and [EMAIL PROTECTED] The times listed are HH:MM as you suspected. And why does it take so long? Well, the dbbackup was a normal-while-everything-else-is-running backup, maybe this is a partial excuse. The restore, however, was the only thing running on the system. The restore is essentially rebuilding the database, so its not just a matter of streaming the bytes onto the disk. I watched the topas monitor from time to time while this was going on and saw the db hdisk at 90-100% busy. (My guess is that this process has not been souped up in a long time, if ever.) Darrel Gleddie IBM Almaden Research Center
Re: Install Failure on TSM AIX 4.2.1.11 client-help!
You may have to install the base 4.2.1 client before you can install the patch on AIX. -Original Message- From: Ken Sedlacek [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:30 AM To: [EMAIL PROTECTED] Subject: Install Failure on TSM AIX 4.2.1.11 client-help! Enviro: H70 AIX 4.3.3 ML04 TSM server 4.2.1.10 Existing TSM client 3.7.3.0 I am attempting to install the TSM AIX client 4.2.1.11, and am getting the following unpacking error: I have re-downloaded the file 2 times now and ftp'd it over to the H70 (ftp -i etc., then binary). Can anyone shed some light how I might get around this?? Pre-install tasks for the TSM Backup/Archive Client completed. Mount volume 2 on /tmp/tsm.client/IP22367.tivoli.tsm.client.ba.aix43.32bit. Press the Enter key to continue. 0503-700 inurest: Error in restoring files 0503-037 inurest: Failure on system call to execute command /usr/sbin/restbynam e -S -xYAqf/tmp/tsm.client/IP22367.tivoli.tsm.client.ba.aix43.32bit -Z /tmp/inu tmpDtg97a/sorted.al. restore: 0511-107 Cannot read from pipe. There is an unpacking error. restore: 0511-708 There is an internal unpacking error: decode failure Ken Sedlacek AIX/TSM/UNIX Administrator [EMAIL PROTECTED] IBM Certified Specialist: RS/6000 AIX v4.3 Support IBM Certified Specialist: RS/6000 SP PSSP 3 Tivoli Certified Consultant - Tivoli Storage Manager v4.1
Re: TSM V5.1
I have seen older levels of the Microsoft installer not work from network drives. So, if you have the package on a network drive move it to a local drive and try it. This is a known Microsoft bug. -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 12:02 PM To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 H... not a good sign. I downloaded the driver this morning and verified the install myself, and it went alright. Do you have an existing ODBC driver installed? If so, which version? I suspect that this could be an issue with removing the older ODBC driver. Try this: 1) From Add/Remove Programs, remove the old ODBC driver. 2) You may get a prompt similar to the above. If so, go get the install package for that driver, and extract the install image (but don't run setup). Then try the uninstall again. If prompted, point to the .msi file in the old driver's install image (the one you just unpacked). 3) If that works, then try installing the new driver. Let me know how this goes. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/12/2002 07:48 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM V5.1 Hi Andy! The 5.1.01 ODBC driver installation does not work. During installation one is prompted for the location of the file Tivoli Storage Manager ODBC Driver.msi. If you point to that file (by default: C:\TEMP\tsmcli\win32\odbc\disk1) it says that it's not a valid installation package... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 14:19 To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Yes, and be sure to get the 5.1.0.1 Windows clients from the FTP site, vs. the 5.1.0.0 clients shipped on the CD. As someone pointed out yesterday, we now have a 4.2.1.32 client to address APAR IC33211 (The TSM V4.2 Windows NT-based client acceptor service may crash if improperly formatted data is received from the HTTP port), and this APAR is fixed in 5.1.0.1 as well. For ODBC driver users, be sure to get the 5.1.0.1 ODBC driver as well. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/12/2002 02:42 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM V5.1 The 5.1 clients are also available for download now. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Jonathan Siegle [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 21:41 To: [EMAIL PROTECTED] Subject: Re: TSM V5.1 Got mine on Monday. I really liked the TSM 5.1 cd with 4.2 functional level software... On Thu, 11 Apr 2002, Gill, Geoffrey L. wrote: Hey everyone, I just got my TSM V5.1 package of software. Anyone else get so lucky? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154 Jonathan Siegle Center for Academic Computing [EMAIL PROTECTED] Penn State University 814-865-5840University Park, Pa 16802 ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: 3494 library swap out.
The use of SQL is extremely powerful. At Share in San Francisco, we are planning as many as 3 sessions on this subject if we can get the presenters. TSM Adminstrators buck using the thing, but once they learn its value they will never walk away from it. -Original Message- From: Mr. Lindsay Morris [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 10:58 AM To: [EMAIL PROTECTED] Subject: Re: 3494 library swap out. Gosh, Bill, that's even better! Now if we could just cut it down to zero steps... - Mr. Lindsay Morris CEO, Servergraph www.servergraph.com 859-253-8000 ofc 425-988-8478 fax -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Boyer Sent: Friday, April 12, 2002 10:29 AM To: [EMAIL PROTECTED] Subject: Re: 3494 library swap out. Maybe more of a generic way that doesn't depend on any specific OSuse a SQL command: select 'checkout libv ' || trim(library_name) || ' ' || trim(volume_name) || ' checkl=no rem=no' from libvolumes and pipe this to a file. You can then run it in as a MACRO libr Lindsay suggests. You may have to SET SQLDISPLAYMODE WIDE to get it all on one line. This doesn't rely on catawk.MSWord...or any utility. Just a TSM admin client. There's more than one way to skin a cat! :-) Whatever you're comfortable with. Myself, with going to different client sites with different systems, I just don't like to come to rely on a solution on a particular platform. No offense intended! Just my $.02 worth. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Mr. Lindsay Morris Sent: Thursday, April 11, 2002 9:45 PM To: [EMAIL PROTECTED] Subject: Re: 3494 library swap out. I guess different people like different tools...I'm a command-line bigot. The idea of turning a list of volumes into a script is a very good idea. Here's a unix-ified way to do it for those who will, maybe faster: 1. Obtain a list of volumes (or stgpools, or...) into a file, say, /tmp/vols 2. cat /tmp/vols | awk '{print checkout libv library_name $1 checkl=no rem=no}' /tmp/macro vol name is here ^^ 3. dsmadmc -id=... -pas=... -itemcommit macro /tmp/macro itemcommit means if one line fails, don't roll back the whole script Not trying to one-up you, Tab - people more comfortable with MS Word should use it. The idea is great. I often see people doing stuff like this manually, and it makes me cringe. Thanks for the post. - Mr. Lindsay Morris CEO, Servergraph www.servergraph.com 859-253-8000 ofc 425-988-8478 fax -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Tab Trepagnier Sent: Thursday, April 11, 2002 6:56 PM To: [EMAIL PROTECTED] Subject: Re: 3494 library swap out. Geoffrey, Whenever I have to do similar operations on lots of volumes, I use my word processor's (MS Word in this case) mail merge feature to help. The sequence goes like this. 1. Obtain a list of volumes to be processed. If the volume name is the only thing that will change, you can save to a text file. But text files only accommodate one variable. If more variables (fields) are needed, use the native WP doc format. 2. Select the file from step 1 as the data source. 3. Create the master document with the desired command line like: checkout libv library_name [volume] checkl=no remove=no where volume is the merge field to be used for the final document. 4. Merge the data. You will end up with a document that has a line from step 3 for each volume. 5. Because that document will be in the native WP format, do a Save As...text of the document. 6. Reopen the text version of the document. You will have a script. 7. Paste that text document's contents into the text entry window of the Create Script page of the TSM web client. The final result will be a server script consisting of the command from step 3 for each volume. 8. Execute the server script in TSM. I know this sounds a bit complicated, but once you've done it a time or two, you can create in less that five minutes scripts that process thousands of volumes. This technique was vital when I was doing our data reorg after the library upgrades and I had to Move Data the contents of hundreds of tapes. Good luck. Tab Trepagnier TSM Administrator Laitram Corporation Gill, Geoffrey L. [EMAIL PROTECTED]@VM.MARIST.EDU on 04/11/2002 12:34:16 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: 3494 library swap out. On Monday IBM will be removing a leased 3494 and installing a replacement
3494 Partitioning Security Not!, But Maybe There is Hope
Those of us that are trying to share our 3494 libraries and some of us having done so successfully have recognized that the mtlib command and the lmcpd interface have no security to prevent improper accidental or malicious actions. Once an open systems host has been defined to the library that host can change the categories of the tapes, mount them in what ever drive it wishes, use tapeutil to do whatever including read, write, erase the tape if the host has access to a tape drive in the library. As part of Share and a customer I have taken an interest in defining a requirement for IBM to eliminate this issue. There are a number of approaches that IBM could take, but the easiest, simplest, and most cost effect from my point of view is to implement security in the library manager to register ranges of tapes to hosts (multiple if you like). Register the drives the host can manipulate. And, to implement a password token with automated refresh and manual reset facilities that the host has to pass with each lmcpd (mtlib) request. However, this would not change the way any application (backup product) uses the library or the ability to say a system has unlimited access (* for all tapes or drives). This function would be selected by the customer as to whether to turn it on or not. Once on, each host will have to have a temporary password set in the LM and issue a new parameter (-P) on the mtlib command with the temporary password to prime the password control information for a host into the ibmatl.conf entry for that library for this host. At that point the system will go into a password generate mode where it can change the password in a two phased commit process every n days (customer selectable). Each lmcpd request will have the imbedded generated password token. There are certainly other security encryption schemes that could be used to protect against snooping, but that is the least of the problem right now and would be only nice to have. At least now the host has to pass an authorization to do something to the tapes. The LM GUI interface would have some extensions to the host definition screen to support defining what a host could manipulate. One area that would be nice is to define volume or drive groups and just register the host to the volume or drive groups that you wish it to be able to manipulate. That way a change to the group to add a new drive would not require every host to be updated, same for volumes. This is how it would affect the open systems hosts. Commands from an invalid host (reverse IP lookup) rejected outright with the same error that an invalid library gets today. Requests that have invalid passwords would have the same thing happen to them. Requests to manipulate a tape or drive that a host does not have access to will be rejected. Inventory of drive and library query functions will operate as today because backup products issue requests for this stuff and could be affected if it were not left the same. Inventory of tape volumes will mask out volumes not belonging to the host (this is nice to have). The insert function will only notify the hosts that have been registered to the volume range, meaning if no host will get the information if none are registered. And, if a range is registered any tapes in FF00 status will get notified to the newly registered host. How do we want to change this for open systems? We need to ask for what is a business critical need so IBM will do it. How do we want the mainframe to play here? The mainframe does not use the lmcpd interface, yet. Customers have asked for mtilib on the S/390 so that they can do the inquiry functions or fix problems with open systems tapes. I suggest that the same be true of the S/390 requests. However, right now, I suggest it be simple, allow a S/390 definition to the library for all S/390s and let them continue to manage their security external to the library among themselves. At least this would prevent the S/390 from messing with open systems tapes and drives. If the mtlib function is created for S/390 down the road it will just work the same way as the functionality for the open systems. The potential benefits here are significant. Sharing tapes between platforms without exposing things that you do not want could become a reality. Sharing drives becomes much more secure because you can limit the pools of drives a host can manipulate. Using a library to support multiple internal customers/users now becomes a possiblity. And, the potential for an integrity train wreck waiting to happen were some critical data gets accidentally destroyed is eliminated. If the function for insert is done the way suggested above you could just load your library with a bunch of tapes and leave them in FF00 status. Define a new range when a host needs some more tapes and those notifications get sent to the host for it to do what it should (just an idea). The other piece that I have always wanted is an insert
Re: What should I know about SAN
First of all 2.7 is a very bad release of Solaris. We skipped it because it is falling off support soon. Second, 3.7.3.8 is unsupported, so good luck if it does not work. V5.1 is out and the death of 4.2 has already been announced. My point is you had better plan to upgrade your TSM environment. If you plan to use FC tape then 2.7 may not work. It really was not supported well by the vendors until Solaris 8. -Original Message- From: Farren Minns [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:39 AM To: [EMAIL PROTECTED] Subject: What should I know about SAN Hello fellow ##SMERS Running TSM 3.7.3.8 Server on Solaris 2.7 Box (E250 450Mhz 1GB) In the coming months, it looks very likely that we are going to be getting some sort of SAN that will initially just be directly connected to one of our machines (an over-priced array for a while then!), and in the future be connected via a SAN switching device to act as a proper Storage Area Network. Whilst I know that this is a broad subject, I am interested in anyone's personal experiences with this. What questions should I be asking myself in order to get the most out of a SAN and what it can offer. For example, I hear the term Flash Copy quite often. I assume that I could make image backups of an entire system very quickly this way thus providing for some very fast restore times. This is just one thing that I would be interested in understanding. So basically, any people out there who has had good/bad SAN / TSM experiences; I would like to hear from you. Thanks very much Farren Minns Trainee Solaris TSM System Admin - John Wiley Sons
Re: TSM Client 5.x
You have to be on maintenance and order it. -Original Message- From: Schaub Joachim Paul ABX-PROD-ZH [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:19 AM To: [EMAIL PROTECTED] Subject: TSM Client 5.x i can't find the V5 Client on the Tivoli Page, does anyone have a downloadadress. thx Joachim