Re: From An ATL7100 to a P3000
Hi, If you delete a library all volumes are deleted from the inventory (no library=no inventory). If you define your new library, this will be an empty one (new library=no inventory). Audit library will not checkin volumes, it will only remove missing volumes from the library inventory. Now you have an empty library (in ITSM) and your volumes are put in the new library (mixed scratch and private). - If you give a audit library, no volumes will be checked in in ITSM; - If you give a checkin libv search=library stat=PRIVATE both your Private tapes and your scratch tapes will be checked in as Private, leaving you with a new library and no scratch tapes available. Don't think you will want to to this...; - If you do a checkin libv search=library stat=Scratch, ITSM will not accept the Private tapes as Scratch and ONLY checkin the scratch tapes as Scratch. Then run another checkin this time with checkin libv search=library stat=private for the remaining tapes (the private once). An other way is manual sort your tapes and check them in as either Scr or Priv. Hope above will help. Regard, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Argeropoulos, Bonnie Sent: dinsdag 29 juni 2004 19:09 To: [EMAIL PROTECTED] Subject: Re: From An ATL7100 to a P3000 Hello, I don't understand...why would I want to check the tapes in as scratch if they already have data on them...why wouldn't I just physcially move them and then run an audit library. At first you say to checkin my data tapes as scratch, but then you say that private tapes cannot be checked in as scratch Thanks, Bonnie -Original Message- From: Bos, Karel [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 11:00 AM To: [EMAIL PROTECTED] Subject: Re: From An ATL7100 to a P3000 Hi, The database will still know the tapes (and the content of the tapes). But you will have to do a checkin libv stat=scratch before doing checkin libv stat=priv. ITSM will let you checkin empty volumes as private, but will not accept private tapes being checked in as scratch. Regards, Karel. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Argeropoulos, Bonnie Sent: dinsdag 29 juni 2004 16:34 To: [EMAIL PROTECTED] Subject: From An ATL7100 to a P3000 Hello, We are planning on changing our tape library from an ATL7100 to a P3000 and from four DLT7000 tape drives to six DLT8000 tape drives on an F50 running AIX 4.3.3 and TSM 5.1.62. We are currently looking at putting our process for this change together and have found we have a few questions. We thought we could delete the path to the drives, path to the library, the drives and then the library. We would then connect the new library and physically move the DLT'4 tapes over to the new library and redefine everything. We are now concerned that if we delete the library will the database no longer know of the tapes? Would anyone have any suggestions or see any problems with this plan? Thanks for any help, Bonnie CONFIDENTIAL COMMUNICATION - PLEASE READ PRIVACY NOTICE This communication is confidential and may be read only by its intended recipient(s). It may contain legally privileged and protected information. If you believe you have received this communication in error, please Reply to the Sender and so indicate or call (603) 663-2800. Then, please promptly Delete this communication from your computer. This communication, and any information contained herein, may only be forwarded, printed, disclosed, copied or disseminated by those specifically authorized to do so. UNAUTHORIZED DISCLOSURE MAY RESULT IN LEGAL LIABILITY FOR THOSE PERSONS RESPONSIBLE. CONFIDENTIAL COMMUNICATION - PLEASE READ PRIVACY NOTICE This communication is confidential and may be read only by its intended recipient(s). It may contain legally privileged and protected information. If you believe you have received this communication in error, please Reply to the Sender and so indicate or call (603) 663-2800. Then, please promptly Delete this communication from your computer. This communication, and any information contained herein, may only be forwarded, printed, disclosed, copied or disseminated by those specifically authorized to do so. UNAUTHORIZED DISCLOSURE MAY RESULT IN LEGAL LIABILITY FOR THOSE PERSONS RESPONSIBLE.
LTO estimated capacity drops
Just analysing our TSM install today as tapes have been getting chewed up quicker then normal, despite no confuration changes being made at server or client side. We have client-side compression turned on (hardware off) and we were getting about 140-180Gb of data on each tape before they being marked as full. Looking today though it has practically halved in capacity (or more in some cases) dropping anywhere from 45-90Gb of data before being labeled full. Any ideas what might cause this? The nature of our data hasn't changed at all, could dirty drives cause such a drastic reduction in capacity? TIA! Gordon -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
NDMP backups via LAN?
Hi, I have a potential customer who would like to backup his NetApp filer to TSM. Now I just learned that NDMP allows for backups of the NetApp via the LAN to a backup server with 'local attached' tapedrives. Unfortunately, it seems this is not supported with TSM. Does anybody know if this is in the works? In our case it is impossible to connect the NetApp to the tapedrives, which seems to be the only supported configuration in TSM according to: http://www.netapp.com/tech_library/3066.html#4.6. As you can see, TSM lacks a few options, and the only available option is a non-option in our case. Anybody have any hints? -- Met vriendelijke groeten, Remco Post SARA - Reken- en Netwerkdiensten http://www.sara.nl High Performance Computing Tel. +31 20 592 3000Fax. +31 20 668 3167 I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end. -- Douglas Adams
TDP for Oracle
Hi all, I have to implement TDP for Oracle at one our customer location right from TSM.The oracle DB is 8.1.7 on windows NT 4.0. TSM version 5.2.0.0 on windows 2000. RMAN is not used for backup now. My problem is the customer is not willing to provide me with a separate machine for RMAN recovery catalog database. He insists that RMAN DB also be installed on the same machine where the target DB is Installed and running. When I tried the installation in a test m/c I installed Two databases on the same machine in archive log mode. one named PRODDB and other RCATDB. Everything went on fine. When I tried to Mount the target DB which is PRODDB in mount mode it says an oracle error cannot mount the database in Exclusive mode. How to go about it in such situation. I have checked in the ORacle forum sites. But unable to get a solution. My requiremnt is to start the database in mount mode which is to be done for recovery from RMAN. I hope somebody would have done this already. thanks in advance John --- The information in this e-mail is the property of DCM DataSystems and may be confidential and privileged. It is intended solely for the addressee and access of this email by anyone else is unauthorised. If you are not the intended receipient, any disclosure, copying, distribution or any action taken in reliance of this message is prohibited and may be unlawful. If you receive this message by error, please notify the sender immediately and delete all copies of this message. ---
Using select statements
Hi everyone I need some help. Was told by a colleague that you can run queries using SQL select statements to obtain information regarding a TSM server. I am trying to compose a select statement to display filespaces on the server which have not been backed up in the last three days. However I am not too sure how to create a statement that works, particularly the part of the statement which deals with the coding for greater then three days Hope this is clear == This communication, together with any attachments hereto or links contained herein, is for the sole use of the intended recipient(s) and may contain information that is confidential or legally protected. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, dissemination, distribution or use of this communication is STRICTLY PROHIBITED. If you have received this communication in error, please notify the sender immediately by return e-mail message and delete the original and all copies of the communication, along with any attachments hereto or links herein, from your system. == The St. Paul Travelers e-mail system made this annotation on 06/30/2004, 07:29:28 AM.
Antwort: Re: From An ATL7100 to a P3000
Hallo, I did every day. 1. checkin libv IBM3570COPY search=yes,checkl=b stat=scr 2. checkin libv IBM3570COPY search=yes,checkl=b stat=pri If you monitor it you see that there are the scratch Tape checked in with the error message that it couldn't checkin the privat tape as Scratch Tapes. Then you see the privat Tapes checked in. Then you have to update the acces of the checked in private volumes to readwrite (upd v vol-ser acc=readw). mit freundlichen Grüßen \ best regards Ralf Behrendt WGZ-Bank Organisation und Betrieb - IT-Systeme - Ludwig-Erhard-Alle 20 D - 40227 Düsseldorf Telefon: +49 211 778 39 15 Telefax: +49 211 778 16 02 Handy: +49 170 576 44 15 mailto:[EMAIL PROTECTED] ADSM: Dist Stor Manager [EMAIL PROTECTED] schrieb am 29.06.2004 19:09:10: Hello, I don't understand...why would I want to check the tapes in as scratch if they already have data on them...why wouldn't I just physcially move them and then run an audit library. At first you say to checkin my data tapes as scratch, but then you say that private tapes cannot be checked in as scratch Thanks, Bonnie -Original Message- From: Bos, Karel [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 11:00 AM To: [EMAIL PROTECTED] Subject: Re: From An ATL7100 to a P3000 Hi, The database will still know the tapes (and the content of the tapes). But you will have to do a checkin libv stat=scratch before doing checkin libv stat=priv. ITSM will let you checkin empty volumes as private, but will not accept private tapes being checked in as scratch. Regards, Karel. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Argeropoulos, Bonnie Sent: dinsdag 29 juni 2004 16:34 To: [EMAIL PROTECTED] Subject: From An ATL7100 to a P3000 Hello, We are planning on changing our tape library from an ATL7100 to a P3000 and from four DLT7000 tape drives to six DLT8000 tape drives on an F50 running AIX 4.3.3 and TSM 5.1.62. We are currently looking at putting our process for this change together and have found we have a few questions. We thought we could delete the path to the drives, path to the library, the drives and then the library. We would then connect the new library and physically move the DLT'4 tapes over to the new library and redefine everything. We are now concerned that if we delete the library will the database no longer know of the tapes? Would anyone have any suggestions or see any problems with this plan? Thanks for any help, Bonnie CONFIDENTIAL COMMUNICATION - PLEASE READ PRIVACY NOTICE This communication is confidential and may be read only by its intended recipient(s). It may contain legally privileged and protected information. If you believe you have received this communication in error, please Reply to the Sender and so indicate or call (603) 663-2800. Then, please promptly Delete this communication from your computer. This communication, and any information contained herein, may only be forwarded, printed, disclosed, copied or disseminated by those specifically authorized to do so. UNAUTHORIZED DISCLOSURE MAY RESULT IN LEGAL LIABILITY FOR THOSE PERSONS RESPONSIBLE. CONFIDENTIAL COMMUNICATION - PLEASE READ PRIVACY NOTICE This communication is confidential and may be read only by its intended recipient(s). It may contain legally privileged and protected information. If you believe you have received this communication in error, please Reply to the Sender and so indicate or call (603) 663-2800. Then, please promptly Delete this communication from your computer. This communication, and any information contained herein, may only be forwarded, printed, disclosed, copied or disseminated by those specifically authorized to do so. UNAUTHORIZED DISCLOSURE MAY RESULT IN LEGAL LIABILITY FOR THOSE PERSONS RESPONSIBLE. Ueber das Internet versandte E-mails koennen leicht verfaelscht oder unter fremdem Namen erstellt werden. Demzufolge muessen wir zu Ihrer und unserer Sicherheit die rechtliche Verbindlichkeit der vorstehenden Erklaerungen ausschließen. Der Versand von E-mail dient somit ausschließlich dem Informationsaustausch. Due to the fact that E-mails are prone to manipulation and can be misleading as to the identity of the sender, the foregoing statements and comments shall have no legal validity. This is for your own protection as well as ours. Thus, E-mails shall be sent for information purposes only.
Re: Using select statements
Hi, I forgot to include the select statement that I have written. It takes the following form. select node_name, filespace_name, date(backup_date) from backups where ((days(backup_date) - days(current_date))) =-3 == This communication, together with any attachments hereto or links contained herein, is for the sole use of the intended recipient(s) and may contain information that is confidential or legally protected. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, dissemination, distribution or use of this communication is STRICTLY PROHIBITED. If you have received this communication in error, please notify the sender immediately by return e-mail message and delete the original and all copies of the communication, along with any attachments hereto or links herein, from your system. == The St. Paul Travelers e-mail system made this annotation on 06/30/2004, 07:54:24 AM.
Antwort: Re: Using select statements
Hi, you can use the sample script FSNOBACKUP. Start it with run fsnobackup 3 (3 = 3 days since they have not been completed). Best regards, Karin mailto:[EMAIL PROTECTED] http://www.emprise.de/enc Ein Unternehmen der EMPRISE Gruppe Diese e-Mail einschließlich ihrer Anhänge ist vertraulich. Wir bitten, eine fehlgeleitete e-Mail unverzüglich vollständig zu löschen und uns eine Nachricht zukommen zu lassen. Wir haben die e-Mail beim Ausgang auf Viren geprüft; wir raten jedoch wegen der Gefahr auf den Übertragungswegen zu einer Eingangskontrolle. Eine Haftung für Virenfreiheit schließen wir aus. This e-mail and any attachments are confidential. If you are not the intended recipient of this e-mail, please immediately delete its contents and notify us. This e-mail was checked for virus contamination before being sent. Nevertheless, it is advisable to check for any contamination occurring during transmission. We cannot accept any liability for virus contamination. |-+ | | Moses Show | | | [EMAIL PROTECTED]| | | L.COM | | | Gesendet von:| | | ADSM: Dist Stor | | | Manager | | | [EMAIL PROTECTED]| | | .EDU| | || | || | | 30.06.2004 13:58 | | | Bitte antworten | | | an ADSM: Dist | | | Stor Manager| |-+ -| | | | An: [EMAIL PROTECTED] | | Kopie:(Blindkopie: Karin Dambacher/Emprise) | | Thema:Re: Using select statements | -| Hi, I forgot to include the select statement that I have written. It takes the following form. select node_name, filespace_name, date(backup_date) from backups where ((days(backup_date) - days(current_date))) =-3 == This communication, together with any attachments hereto or links contained herein, is for the sole use of the intended recipient(s) and may contain information that is confidential or legally protected. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, dissemination, distribution or use of this communication is STRICTLY PROHIBITED. If you have received this communication in error, please notify the sender immediately by return e-mail message and delete the original and all copies of the communication, along with any attachments hereto or links herein, from your system. == The St. Paul Travelers e-mail system made this annotation on 06/30/2004, 07:54:24 AM.
Re: Antwort: Re: Using select statements
Where can I locate this sample script Karin Dambacher [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 30/06/2004 13:21 Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To [EMAIL PROTECTED] cc Subject Antwort: Re: Using select statements Hi, you can use the sample script FSNOBACKUP. Start it with run fsnobackup 3 (3 = 3 days since they have not been completed). Best regards, Karin mailto:[EMAIL PROTECTED] http://www.emprise.de/enc Ein Unternehmen der EMPRISE Gruppe Diese e-Mail einschließlich ihrer Anhänge ist vertraulich. Wir bitten, eine fehlgeleitete e-Mail unverzüglich vollständig zu löschen und uns eine Nachricht zukommen zu lassen. Wir haben die e-Mail beim Ausgang auf Viren geprüft; wir raten jedoch wegen der Gefahr auf den Übertragungswegen zu einer Eingangskontrolle. Eine Haftung für Virenfreiheit schließen wir aus. This e-mail and any attachments are confidential. If you are not the intended recipient of this e-mail, please immediately delete its contents and notify us. This e-mail was checked for virus contamination before being sent. Nevertheless, it is advisable to check for any contamination occurring during transmission. We cannot accept any liability for virus contamination. |-+ | | Moses Show | | | [EMAIL PROTECTED]| | | L.COM | | | Gesendet von:| | | ADSM: Dist Stor | | | Manager | | | [EMAIL PROTECTED]| | | .EDU| | || | || | | 30.06.2004 13:58 | | | Bitte antworten | | | an ADSM: Dist | | | Stor Manager| |-+ -| | | | An: [EMAIL PROTECTED] | | Kopie:(Blindkopie: Karin Dambacher/Emprise)| | Thema:Re: Using select statements | -| Hi, I forgot to include the select statement that I have written. It takes the following form. select node_name, filespace_name, date(backup_date) from backups where ((days(backup_date) - days(current_date))) =-3 == This communication, together with any attachments hereto or links contained herein, is for the sole use of the intended recipient(s) and may contain information that is confidential or legally protected. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, dissemination, distribution or use of this communication is STRICTLY PROHIBITED. If you have received this communication in error, please notify the sender immediately by return e-mail message and delete the original and all copies of the communication, along with any attachments hereto or links herein, from your system. == The St. Paul Travelers e-mail system made this annotation on 06/30/2004, 07:54:24 AM. == This communication, together with any attachments hereto or links contained herein, is for the sole use of the intended recipient(s) and may contain information that is confidential or legally protected. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, dissemination, distribution or use of this communication is STRICTLY PROHIBITED. If you have received this communication in error, please notify the sender immediately by return e-mail message and delete the original and all copies of the communication, along with any attachments hereto or links herein, from your system. == The St. Paul Travelers e-mail system made this annotation on 06/30/2004, 08:29:15 AM.
Antwort: Re: Antwort: Re: Using select statements
Hi, in the web admin look at object view - automation - server command scripts. If this list is empty, you have to load the sample scripts with dsmserv runfile ..xyz\scripts.smp where xyz is the server directory. If the list is not empty, FSNOBACK is defined (you can see it in the list) and you can read or run it. Best regards, Karin EMPRISE Network Consulting GmbH mailto:[EMAIL PROTECTED] http://www.emprise.de/enc Ein Unternehmen der EMPRISE Gruppe Diese e-Mail einschließlich ihrer Anhänge ist vertraulich. Wir bitten, eine fehlgeleitete e-Mail unverzüglich vollständig zu löschen und uns eine Nachricht zukommen zu lassen. Wir haben die e-Mail beim Ausgang auf Viren geprüft; wir raten jedoch wegen der Gefahr auf den Übertragungswegen zu einer Eingangskontrolle. Eine Haftung für Virenfreiheit schließen wir aus. This e-mail and any attachments are confidential. If you are not the intended recipient of this e-mail, please immediately delete its contents and notify us. This e-mail was checked for virus contamination before being sent. Nevertheless, it is advisable to check for any contamination occurring during transmission. We cannot accept any liability for virus contamination. |-+ | | Moses Show | | | [EMAIL PROTECTED]| | | L.COM | | | Gesendet von:| | | ADSM: Dist Stor | | | Manager | | | [EMAIL PROTECTED]| | | .EDU| | || | || | | 30.06.2004 14:33 | | | Bitte antworten | | | an ADSM: Dist | | | Stor Manager| |-+ -| | | | An: [EMAIL PROTECTED] | | Kopie:(Blindkopie: Karin Dambacher/Emprise) | | Thema:Re: Antwort: Re: Using select statements | -| Where can I locate this sample script Karin Dambacher [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 30/06/2004 13:21 Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To [EMAIL PROTECTED] cc Subject Antwort: Re: Using select statements Hi, you can use the sample script FSNOBACKUP. Start it with run fsnobackup 3 (3 = 3 days since they have not been completed). Best regards, Karin mailto:[EMAIL PROTECTED] http://www.emprise.de/enc Ein Unternehmen der EMPRISE Gruppe Diese e-Mail einschließlich ihrer Anhänge ist vertraulich. Wir bitten, eine fehlgeleitete e-Mail unverzüglich vollständig zu löschen und uns eine Nachricht zukommen zu lassen. Wir haben die e-Mail beim Ausgang auf Viren geprüft; wir raten jedoch wegen der Gefahr auf den Übertragungswegen zu einer Eingangskontrolle. Eine Haftung für Virenfreiheit schließen wir aus. This e-mail and any attachments are confidential. If you are not the intended recipient of this e-mail, please immediately delete its contents and notify us. This e-mail was checked for virus contamination before being sent. Nevertheless, it is advisable to check for any contamination occurring during transmission. We cannot accept any liability for virus contamination. |-+ | | Moses Show | | | [EMAIL PROTECTED]| | | L.COM | | | Gesendet von:| | | ADSM: Dist Stor | | | Manager | | | [EMAIL PROTECTED]| | | .EDU| | || | || | | 30.06.2004 13:58 | | | Bitte antworten | | | an ADSM: Dist | | | Stor Manager| |-+ -| | | | An: [EMAIL PROTECTED] | | Kopie:(Blindkopie: Karin Dambacher/Emprise)| |
Re: Antwort: Re: Using select statements
Karin Dambacher [EMAIL PROTECTED] you can use the sample script FSNOBACKUP. Start it with run fsnobackup 3 (3 = 3 days since they have not been completed). From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Moses Show Where can I locate this sample script Read your manuals, sir. Search any of the current administrative guides for the string 'sample script'. If you don't know how to get online copies of the manuals, search http://search.adsm.org for the keywords monthly and FAQ. -- Mark Stapleton
Re: From An ATL7100 to a P3000
Hello Karel, Thank-you so much for your explanation...that really helped me to understand why I needed to check the tapes back in. I was hoping to just open the library door and remove them from the old library, but would you recommend that I use a checkout command to do this? Thank-you, Bonnie -Original Message- From: Bos, Karel [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 2:22 AM To: [EMAIL PROTECTED] Subject: Re: From An ATL7100 to a P3000 Hi, If you delete a library all volumes are deleted from the inventory (no library=no inventory). If you define your new library, this will be an empty one (new library=no inventory). Audit library will not checkin volumes, it will only remove missing volumes from the library inventory. Now you have an empty library (in ITSM) and your volumes are put in the new library (mixed scratch and private). - If you give a audit library, no volumes will be checked in in ITSM; - If you give a checkin libv search=library stat=PRIVATE both your Private tapes and your scratch tapes will be checked in as Private, leaving you with a new library and no scratch tapes available. Don't think you will want to to this...; - If you do a checkin libv search=library stat=Scratch, ITSM will not accept the Private tapes as Scratch and ONLY checkin the scratch tapes as Scratch. Then run another checkin this time with checkin libv search=library stat=private for the remaining tapes (the private once). An other way is manual sort your tapes and check them in as either Scr or Priv. Hope above will help. Regard, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Argeropoulos, Bonnie Sent: dinsdag 29 juni 2004 19:09 To: [EMAIL PROTECTED] Subject: Re: From An ATL7100 to a P3000 Hello, I don't understand...why would I want to check the tapes in as scratch if they already have data on them...why wouldn't I just physcially move them and then run an audit library. At first you say to checkin my data tapes as scratch, but then you say that private tapes cannot be checked in as scratch Thanks, Bonnie -Original Message- From: Bos, Karel [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 11:00 AM To: [EMAIL PROTECTED] Subject: Re: From An ATL7100 to a P3000 Hi, The database will still know the tapes (and the content of the tapes). But you will have to do a checkin libv stat=scratch before doing checkin libv stat=priv. ITSM will let you checkin empty volumes as private, but will not accept private tapes being checked in as scratch. Regards, Karel. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Argeropoulos, Bonnie Sent: dinsdag 29 juni 2004 16:34 To: [EMAIL PROTECTED] Subject: From An ATL7100 to a P3000 Hello, We are planning on changing our tape library from an ATL7100 to a P3000 and from four DLT7000 tape drives to six DLT8000 tape drives on an F50 running AIX 4.3.3 and TSM 5.1.62. We are currently looking at putting our process for this change together and have found we have a few questions. We thought we could delete the path to the drives, path to the library, the drives and then the library. We would then connect the new library and physically move the DLT'4 tapes over to the new library and redefine everything. We are now concerned that if we delete the library will the database no longer know of the tapes? Would anyone have any suggestions or see any problems with this plan? Thanks for any help, Bonnie CONFIDENTIAL COMMUNICATION - PLEASE READ PRIVACY NOTICE This communication is confidential and may be read only by its intended recipient(s). It may contain legally privileged and protected information. If you believe you have received this communication in error, please Reply to the Sender and so indicate or call (603) 663-2800. Then, please promptly Delete this communication from your computer. This communication, and any information contained herein, may only be forwarded, printed, disclosed, copied or disseminated by those specifically authorized to do so. UNAUTHORIZED DISCLOSURE MAY RESULT IN LEGAL LIABILITY FOR THOSE PERSONS RESPONSIBLE. CONFIDENTIAL COMMUNICATION - PLEASE READ PRIVACY NOTICE This communication is confidential and may be read only by its intended recipient(s). It may contain legally privileged and protected information. If you believe you have received this communication in error, please Reply to the Sender and so indicate or call (603) 663-2800. Then, please promptly Delete this communication from your computer. This communication, and any information contained herein, may only be forwarded, printed, disclosed, copied or disseminated by those specifically authorized to do so. UNAUTHORIZED DISCLOSURE MAY RESULT IN LEGAL LIABILITY FOR THOSE PERSONS RESPONSIBLE. CONFIDENTIAL COMMUNICATION - PLEASE READ PRIVACY NOTICE This communication is confidential and may be read only by its intended recipient(s). It may
Re: Using select statements
Hi, First, try to avoid select statements against backup table since it take some time to run... (and nobody mentioned it...) Second, look at http://people.bu.edu/rbs/ADSM.QuickFacts, there are alot of SQL links at the end. Third, try select node_name, filespace_name, substr(cast(backup_end as char(26)),1,10) as Last Backup Date from filespaces where backup_end current_timestamp - 24 hours order by Last Backup Date. You can include 'and backup_end current_timestamp -XYZ hours' if you want to narrow it. //Henrik Moses Show [EMAIL PROTECTED]To: [EMAIL PROTECTED] TPAUL.COM cc: (bcc: Henrik Wahlstedt) Sent by: Subject: Re: Using select statements ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 2004-06-30 13:58 Please respond to ADSM: Dist Stor Manager Hi, I forgot to include the select statement that I have written. It takes the following form. select node_name, filespace_name, date(backup_date) from backups where ((days(backup_date) - days(current_date))) =-3 == This communication, together with any attachments hereto or links contained herein, is for the sole use of the intended recipient(s) and may contain information that is confidential or legally protected. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, dissemination, distribution or use of this communication is STRICTLY PROHIBITED. If you have received this communication in error, please notify the sender immediately by return e-mail message and delete the original and all copies of the communication, along with any attachments hereto or links herein, from your system. == The St. Paul Travelers e-mail system made this annotation on 06/30/2004, 07:54:24 AM. --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Authentication Problem and Downlevel Server version
Hello everybody I have a TSM client (version 4.2.1) running on AIX 4.3.3. I have two errors situation (distinct, I think) on this client. Situation 1: When I make a q node I receive the following message: I already change the node name and re-install the client with a new name. tsm q node Please enter your user id DSFT01: dsft01 Please enter password for user id DSFT01: Node Name: DSFT01 Session established with server TSM: AIX-RS/6000 Server Version 4, Release 2, Level 3.0 Server date/time: 06/30/04 14:12:25 Last access: 06/30/04 14:10:02 ANS1943E The operation is not supported: Downlevel server version. Unknown system error Please check the TSM Error Log for any additional information tsm Situation 2: When I try to start the Schedule process, TSM request authentication On dsm.sys I have the following configuration: SCHEDMODE PROMPTED TCPCLIENTADDRESS dsft01 PASSWORDACCESS GENERATE COMMmethod TCPip TCPPort1500 [EMAIL PROTECTED]:/usr/tivoli/tsm/client/ba/bin (dsmc sched ) [1] 39198 [EMAIL PROTECTED]:/usr/tivoli/tsm/client/ba/bin Tivoli Storage Manager Command Line Backup Client Interface - Version 4, Release 2, Level 1.0 (C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved. Querying server for next scheduled event. Node Name: DSFT01 Please enter your user id DSFT01: ANS1029E Communications have been dropped. Scheduler has been stopped. Could you provide me some help on those problems? Thank you Tiago
Problem with TSM Client in a WIN2000 Cluster Environment
Hello everyone, We have some problems with our TSM scheduler service in a Windows 2000 Cluster Environment. There are two cluster nodes in the cluster, and from each cluster node we try to backup our data from the corresponding cluster-hard disks to a remote TSM-server. So cluster node A backs up data from the corresponding clustered (failover) HD AA to the TSM node AAA and cluster node B who backs up data from the corresponding clustered (failover) HD BB to the TSM node BBB. We would like both these clusters to have failover-capabilities with respect to each other, so that the backup from cluster node A automatically switches to server 2 if it fails on server 1 and vice versa with cluster node B Our problem: two TSM scheduler services on each of the two servers running the cluster are installed: One for cluster node A and one for cluster node B. For some reason that I do not understand only the second service to be installed installed works. The first service installed (scheduler service for cluster node A on Server 1 and the service for cluster node B on server 2) exits with an error (MS Event ID 4099 / Source: AdsmClientService / Scheduler exited with a result code of 12). So the failover-mechanism on the cluster switches over to the other node. There the second installed (working) service allows the data to be backed up successully. But since the Schedule Service does not work on the original nodes, the failover-capabilities of the cluster are lost. We cannot switch cluster nodes between servers, because with the failure of the schedule services installed first the cluster fails and switches back to the nodes where the services that were installed later are located producing the error decribed before. The administrator of the TSM server tells me that the service seems to transmit a wrong password - which cannot be, because I reinstalled it with very simly default passwords and doublespellchecked the passwords. Since he is a Linux expert, he has no experience with windows clustering, and therefore cannot help me on this issue. Does anyone have experience with such a clustered environment under windows and know how to resolve it? Thank you for your help, Martin -- Martin Krauß IT-Gruppe Geisteswissenschaften LMU München Ludwigsstraße 28 80539 München Hotline: 2180 6400 Tel.:089 2180 1395 FAX: 089 2180 13543 Email: [EMAIL PROTECTED]
AW: Problem with TSM Client in a WIN2000 Cluster Environment
-Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Martin Krauß Gesendet: Mittwoch, 30. Juni 2004 15:35 An: [EMAIL PROTECTED] Betreff: Problem with TSM Client in a WIN2000 Cluster Environment Hello everyone, We have some problems with our TSM scheduler service in a Windows 2000 Cluster Environment. There are two cluster nodes in the cluster, and from each cluster node we try to backup our data from the corresponding cluster-hard disks to a remote TSM-server. So cluster node A backs up data from the corresponding clustered (failover) HD AA to the TSM node AAA and cluster node B who backs up data from the corresponding clustered (failover) HD BB to the TSM node BBB. We would like both these clusters to have failover-capabilities with respect to each other, so that the backup from cluster node A automatically switches to server 2 if it fails on server 1 and vice versa with cluster node B Our problem: two TSM scheduler services on each of the two servers running the cluster are installed: One for cluster node A and one for cluster node B. For some reason that I do not understand only the second service to be installed installed works. The first service installed (scheduler service for cluster node A on Server 1 and the service for cluster node B on server 2) exits with an error (MS Event ID 4099 / Source: AdsmClientService / Scheduler exited with a result code of 12). So the failover-mechanism on the cluster switches over to the other node. There the second installed (working) service allows the data to be backed up successully. But since the Schedule Service does not work on the original nodes, the failover-capabilities of the cluster are lost. We cannot switch cluster nodes between servers, because with the failure of the schedule services installed first the cluster fails and switches back to the nodes where the services that were installed later are located producing the error decribed before. The administrator of the TSM server tells me that the service seems to transmit a wrong password - which cannot be, because I reinstalled it with very simly default passwords and doublespellchecked the passwords. Since he is a Linux expert, he has no experience with windows clustering, and therefore cannot help me on this issue. Does anyone have experience with such a clustered environment under windows and know how to resolve it? Thank you for your help, Martin -- Martin Krauß IT-Gruppe Geisteswissenschaften LMU München Ludwigsstraße 28 80539 München Hotline: 2180 6400 Tel.:089 2180 1395 FAX: 089 2180 13543 Email: [EMAIL PROTECTED]
Storage-Agent
Hi all, Can anybody tell me which product I have to licence, if I want to use lanfree-Backup TSM5.2 on Unix and W2K-clients . My server is on AIX. I can't see a product on the IBM-website, I only find the Storage Agent Books. Thanks a lot Chris
Antwort: AW: Problem with TSM Client in a WIN2000 Cluster Environment
Hi, there is a bug when you install a cluster service sched , you have to open the GUI and reenter the password. When we install a new cluster schedule we map the aktiv node cluster disk to the inactiv node using the same drive letter. This way we can use the same opt and path to the opt to install the schedule on the inactive Node. We can also reenter the password on the inactive nodes' registry to make sure the sched won't fail when the cluster moves resources Mit freundlichen Grüßen / Best Regards Markus Veit _ ScaleOn GmbH Co. KG SO-HS2-SBB Leverkusen, B151 R.401 Tel.: +49 214 30 71254 Fax: +49 214 30 9671254 E-Mail: [EMAIL PROTECTED] Internet : http://www.bayer-ag.de A Bayer Company An: [EMAIL PROTECTED] Kopie: Thema: AW: Problem with TSM Client in a WIN2000 Cluster Environment [EMAIL PROTECTED] Received : 30.06.2004 16:12 Bitte antworten an ADSM: Dist Stor Manager -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Martin Krauß Gesendet: Mittwoch, 30. Juni 2004 15:35 An: [EMAIL PROTECTED] Betreff: Problem with TSM Client in a WIN2000 Cluster Environment Hello everyone, We have some problems with our TSM scheduler service in a Windows 2000 Cluster Environment. There are two cluster nodes in the cluster, and from each cluster node we try to backup our data from the corresponding cluster-hard disks to a remote TSM-server. So cluster node A backs up data from the corresponding clustered (failover) HD AA to the TSM node AAA and cluster node B who backs up data from the corresponding clustered (failover) HD BB to the TSM node BBB. We would like both these clusters to have failover-capabilities with respect to each other, so that the backup from cluster node A automatically switches to server 2 if it fails on server 1 and vice versa with cluster node B Our problem: two TSM scheduler services on each of the two servers running the cluster are installed: One for cluster node A and one for cluster node B. For some reason that I do not understand only the second service to be installed installed works. The first service installed (scheduler service for cluster node A on Server 1 and the service for cluster node B on server 2) exits with an error (MS Event ID 4099 / Source: AdsmClientService / Scheduler exited with a result code of 12). So the failover-mechanism on the cluster switches over to the other node. There the second installed (working) service allows the data to be backed up successully. But since the Schedule Service does not work on the original nodes, the failover-capabilities of the cluster are lost. We cannot switch cluster nodes between servers, because with the failure of the schedule services installed first the cluster fails and switches back to the nodes where the services that were installed later are located producing the error decribed before. The administrator of the TSM server tells me that the service seems to transmit a wrong password - which cannot be, because I reinstalled it with very simly default passwords and doublespellchecked the passwords. Since he is a Linux expert, he has no experience with windows clustering, and therefore cannot help me on this issue. Does anyone have experience with such a clustered environment under windows and know how to resolve it? Thank you for your help, Martin -- Martin Krauß IT-Gruppe Geisteswissenschaften LMU München Ludwigsstraße 28 80539 München Hotline: 2180 6400 Tel.:089 2180 1395 FAX: 089 2180 13543 Email: [EMAIL PROTECTED]
Cannot logon web TSM5.2.2.5
Hi, Gurus, . TSM 5.2.2.5 windows 2003. But cannot login on web interface admin. It used to be admin and admin. but now no response. Is it Windows 2003 Security issue? And in device configuration the tape library and drives are on same level, drives are not under Tape library. Any information will be appreciated. Tao Jiang Coban Research and Technologies 12503 Exchange Drive Suite 536 Stafford, Tx, 77477 281-277-8288 Ext:112
Antwort: Storage-Agent
Hi Chris, the license file is 'mgsyssan.lic'. Good luck, Rainer Christoph Pilgram [EMAIL PROTECTED] An: [EMAIL PROTECTED] ELHEIM.COM Kopie: Gesendet von: ADSM: Dist Stor Thema: Storage-Agent Manager [EMAIL PROTECTED] 30.06.2004 16:13 Bitte antworten an ADSM: Dist Stor Manager Hi all, Can anybody tell me which product I have to licence, if I want to use lanfree-Backup TSM5.2 on Unix and W2K-clients . My server is on AIX. I can't see a product on the IBM-website, I only find the Storage Agent Books. Thanks a lot Chris
about db2 restore
Hi, Bill I met some problem about online restoring the DB2 database: When I use command line to restore the database, the error is: db2 = rollforward database hjy218 to end of logs and stop SQL0956C Not enough storage is available in the database heap to process the statement. SQLSTATE=57011 when I use GUI to restore the database, the error is: BM][CLI Driver] SQL1117N A connection to or activation of database ANDY cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019 Before I backuped the database online, I had set the roll-foreward to on. Could you tell me how can I disable ROLL-FORWARD PENDING and achive the online recovery on db2. Thanks Andy - Post your free ad now! Yahoo! Canada Personals
Re: From An ATL7100 to a P3000
Hello Bonnie, If you delete your library, ITSM will delete the library inventory for you. So the answer to you question is No, do not use checkout libv. It will only slow things down. Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Argeropoulos, Bonnie Sent: woensdag 30 juni 2004 15:06 To: [EMAIL PROTECTED] Subject: Re: From An ATL7100 to a P3000 Hello Karel, Thank-you so much for your explanation...that really helped me to understand why I needed to check the tapes back in. I was hoping to just open the library door and remove them from the old library, but would you recommend that I use a checkout command to do this? Thank-you, Bonnie -Original Message- From: Bos, Karel [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 2:22 AM To: [EMAIL PROTECTED] Subject: Re: From An ATL7100 to a P3000 Hi, If you delete a library all volumes are deleted from the inventory (no library=no inventory). If you define your new library, this will be an empty one (new library=no inventory). Audit library will not checkin volumes, it will only remove missing volumes from the library inventory. Now you have an empty library (in ITSM) and your volumes are put in the new library (mixed scratch and private). - If you give a audit library, no volumes will be checked in in ITSM; - If you give a checkin libv search=library stat=PRIVATE both your Private tapes and your scratch tapes will be checked in as Private, leaving you with a new library and no scratch tapes available. Don't think you will want to to this...; - If you do a checkin libv search=library stat=Scratch, ITSM will not accept the Private tapes as Scratch and ONLY checkin the scratch tapes as Scratch. Then run another checkin this time with checkin libv search=library stat=private for the remaining tapes (the private once). An other way is manual sort your tapes and check them in as either Scr or Priv. Hope above will help. Regard, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Argeropoulos, Bonnie Sent: dinsdag 29 juni 2004 19:09 To: [EMAIL PROTECTED] Subject: Re: From An ATL7100 to a P3000 Hello, I don't understand...why would I want to check the tapes in as scratch if they already have data on them...why wouldn't I just physcially move them and then run an audit library. At first you say to checkin my data tapes as scratch, but then you say that private tapes cannot be checked in as scratch Thanks, Bonnie -Original Message- From: Bos, Karel [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 11:00 AM To: [EMAIL PROTECTED] Subject: Re: From An ATL7100 to a P3000 Hi, The database will still know the tapes (and the content of the tapes). But you will have to do a checkin libv stat=scratch before doing checkin libv stat=priv. ITSM will let you checkin empty volumes as private, but will not accept private tapes being checked in as scratch. Regards, Karel. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Argeropoulos, Bonnie Sent: dinsdag 29 juni 2004 16:34 To: [EMAIL PROTECTED] Subject: From An ATL7100 to a P3000 Hello, We are planning on changing our tape library from an ATL7100 to a P3000 and from four DLT7000 tape drives to six DLT8000 tape drives on an F50 running AIX 4.3.3 and TSM 5.1.62. We are currently looking at putting our process for this change together and have found we have a few questions. We thought we could delete the path to the drives, path to the library, the drives and then the library. We would then connect the new library and physically move the DLT'4 tapes over to the new library and redefine everything. We are now concerned that if we delete the library will the database no longer know of the tapes? Would anyone have any suggestions or see any problems with this plan? Thanks for any help, Bonnie CONFIDENTIAL COMMUNICATION - PLEASE READ PRIVACY NOTICE This communication is confidential and may be read only by its intended recipient(s). It may contain legally privileged and protected information. If you believe you have received this communication in error, please Reply to the Sender and so indicate or call (603) 663-2800. Then, please promptly Delete this communication from your computer. This communication, and any information contained herein, may only be forwarded, printed, disclosed, copied or disseminated by those specifically authorized to do so. UNAUTHORIZED DISCLOSURE MAY RESULT IN LEGAL LIABILITY FOR THOSE PERSONS RESPONSIBLE. CONFIDENTIAL COMMUNICATION - PLEASE READ PRIVACY NOTICE This communication is confidential and may be read only by its intended recipient(s). It may contain legally privileged and protected information. If you believe you have received this communication in error, please Reply to the Sender and so indicate or call (603) 663-2800. Then, please promptly Delete this communication from your
Antwort: Using select statements
Hallo, I use select node_name,filespace_name,backup_end from filespaces where cast ((current_timestamp-backup_end)days as decimal(3,0))3 mit freundlichen Grüßen Ralf Behrendt WGZ-Bank Organisation und Betrieb - IT-Systeme - Ludwig-Erhard-Alle 20 D - 40227 Düsseldorf Telefon: +49 211 778 39 15 Telefax: +49 211 778 16 02 Handy: +49 170 576 44 15 mailto:[EMAIL PROTECTED] ADSM: Dist Stor Manager [EMAIL PROTECTED] schrieb am 30.06.2004 13:33:20: Hi everyone I need some help. Was told by a colleague that you can run queries using SQL select statements to obtain information regarding a TSM server. I am trying to compose a select statement to display filespaces on the server which have not been backed up in the last three days. However I am not too sure how to create a statement that works, particularly the part of the statement which deals with the coding for greater then three days Hope this is clear == This communication, together with any attachments hereto or links contained herein, is for the sole use of the intended recipient(s) and may contain information that is confidential or legally protected. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, dissemination, distribution or use of this communication is STRICTLY PROHIBITED. If you have received this communication in error, please notify the sender immediately by return e-mail message and delete the original and all copies of the communication, along with any attachments hereto or links herein, from your system. == The St. Paul Travelers e-mail system made this annotation on 06/30/2004, 07:29:28 AM.
Re: Storage-Agent
I downloaded these products (with Passport Advantage site): IBM Tivoli Storage Manager for SANS Managed Systems for SAN on UNIX V5.2.2, Multi-Language (C566MML) IBM Tivoli Storage Manager for SANS Managed Systems for SAN on Windows V5.2.2, Multi-Language (C566LML) Jeroen -Original Message- From: Christoph Pilgram [mailto:[EMAIL PROTECTED] Sent: woensdag 30 juni 2004 16:14 To: [EMAIL PROTECTED] Subject: Storage-Agent Hi all, Can anybody tell me which product I have to licence, if I want to use lanfree-Backup TSM5.2 on Unix and W2K-clients . My server is on AIX. I can't see a product on the IBM-website, I only find the Storage Agent Books. Thanks a lot Chris
Re: NDMP backups via LAN?
Hi, We have several netapp filers in our environment. Because NDMP in general (and specifically in the case of TSM) is lacking we use a slightly different configuration. For each filer, we have an anti-virus server that runs the off box mcafee solution for netapp. These also double as the backup nodes for the filers. We share each vol (vol1, vol2, c$, etc) and backup those with the domain tag in the dsm.opt file. Pro's 1) Doesn't require ndmp. 2) Retains progressive incremental approach. 3) Doesn't require an image backup. 4) Can scale to whatever volume is needed by adding more nodes. 5) No tape drive issues. Con's 1) More network traffic 2) Probably slower. 3) Windows/UNIX account must have rights to read all files. 4) Need to exclude ~snapshot folders (not a big deal, unless you forget). 5) Scheduler service must run as the windows account with the rights. In a disaster, the filer brain is in the c$ share (the files that have all of the qtree's and shares are in there) so you could restore the c$ share and recreate the volumes. Of course the best disaster option for the filers is to have a second one in a remote facility and use snapmirror to mirror them, but that may be cost prohibitive. I have been told (mostly by netapp people) that veritas and legato have better implementations of ndmp than TSM. YMMV. Michael Wheelock Integris Health -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Remco Post Sent: Wednesday, June 30, 2004 3:57 AM To: [EMAIL PROTECTED] Subject: NDMP backups via LAN? Hi, I have a potential customer who would like to backup his NetApp filer to TSM. Now I just learned that NDMP allows for backups of the NetApp via the LAN to a backup server with 'local attached' tapedrives. Unfortunately, it seems this is not supported with TSM. Does anybody know if this is in the works? In our case it is impossible to connect the NetApp to the tapedrives, which seems to be the only supported configuration in TSM according to: http://www.netapp.com/tech_library/3066.html#4.6. As you can see, TSM lacks a few options, and the only available option is a non-option in our case. Anybody have any hints? -- Met vriendelijke groeten, Remco Post SARA - Reken- en Netwerkdiensten http://www.sara.nl High Performance Computing Tel. +31 20 592 3000Fax. +31 20 668 3167 I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end. -- Douglas Adams
Re: admin password on 5.2
Trying to log onto a 5.2 installation. Get: Enter your user id: admin Enter your password: Your password has expired. Enter your password: Please enter a new password: Enter new password for verification: ANS1262E Password is not updated. Either an invalid current password was supplie d or the new password does not fulfill the server password requirements. ANS1051E Invalid password Enter your password: tried 8 characters 1234567a, no good, tried uoieax99, no good. What are the restrictions?
Antwort: Backup copygroups
Hallo Moses, I although have to make a daily and a monthly backup on the server with different retention periods. I solve the problem by creating to policy domains dayly_pd and monthly_pd where are different management classes. On the node I use two different nodes hostname_day and hostname_mon which are backed up in the responding policy domain with the responding management class. I have to use two dsm.opt files when i start the two schedulers Use export DSM_CONFIG=$DSM_DIR/dsm.opt or export DSM_CONFIG =$DSM_DIR/mon_dsm.opt in Script to start the two schedulers. mit freundlichen Grüßen Ralf Behrendt mailto:[EMAIL PROTECTED] ADSM: Dist Stor Manager [EMAIL PROTECTED] schrieb am 29.06.2004 18:00:44: Hi people, I have a burning question which hopefully somebody can provide an answer to. Have been asked to backup SQL servers daily using TSM . The details and instructions for how these backups are performed and any characteristics are contained in the respective management class of the policy set in the policy domain. I also need to backup these servers at monthend and some every five weeks. What I am trying to find out is if it is possible to have more than one backup copygroup under this management class. The reason is because the period backups will have different retention times to the dailys and possibly different retain only version values. Is it feasible to create two separate backup copygroups to manage this ? If so how would you get the server to differentiate between if a backup is run daily or at the end of periods. Once again any help would be gratefully received, examples would be even more gratefully received.
Re: Using select statements
Do a q script fsnobackup'. I think that might be a TSM supplied script that does what you want. Matter of fact, do a q script and get familar with the supplied scripts. Some of them are quite useful and others serve as a good starting point for writing your own queries. David [EMAIL PROTECTED] 6/30/2004 7:33:20 AM Hi everyone I need some help. Was told by a colleague that you can run queries using SQL select statements to obtain information regarding a TSM server. I am trying to compose a select statement to display filespaces on the server which have not been backed up in the last three days. However I am not too sure how to create a statement that works, particularly the part of the statement which deals with the coding for greater then three days Hope this is clear == This communication, together with any attachments hereto or links contained herein, is for the sole use of the intended recipient(s) and may contain information that is confidential or legally protected. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, dissemination, distribution or use of this communication is STRICTLY PROHIBITED. If you have received this communication in error, please notify the sender immediately by return e-mail message and delete the original and all copies of the communication, along with any attachments hereto or links herein, from your system. == The St. Paul Travelers e-mail system made this annotation on 06/30/2004, 07:29:28 AM.
Re: admin password on 5.2
Check the minimum password length that was set on your TSM server (query status will show a minimum password length field). Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] 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. Lawrence Clark [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 06/30/2004 08:48 Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject Re: admin password on 5.2 Trying to log onto a 5.2 installation. Get: Enter your user id: admin Enter your password: Your password has expired. Enter your password: Please enter a new password: Enter new password for verification: ANS1262E Password is not updated. Either an invalid current password was supplie d or the new password does not fulfill the server password requirements. ANS1051E Invalid password Enter your password: tried 8 characters 1234567a, no good, tried uoieax99, no good. What are the restrictions?
Re: raw partitions
On Tuesday 29 June 2004 20:33, [EMAIL PROTECTED] wrote: == In article [EMAIL PROTECTED], Joni Moyer [EMAIL PROTECTED] writes: Hello all! I was reading the performance tuning guide and it states that we should use raw partitions for server db, log and disk storage pool volumes for an AIX server and I was just wondering if this is true and what the benefits are of configuring volumes in this manner? Simpler, faster, less space overhead. Euh, yes and no. For AIX and jfs2 file systems, you can enable CIO (in /etc/filesystems: options = rw,cio). If you do so, your file systems are as fast as raw devices. So you have the benefits of a file system and the speed of a raw device. The I/O requests are directly done on the disk, all cache is skipped. I have a pdf file about this setup for oracle and the speed you can get. We once enabled this on a very busy AIX server and the oracle database was very, very fast. As I understand it, if we configure raw logical volumes, the AIX volume group will need to be applied to a raw logical volume, as opposed to a standard UNIX filesytem. For each disk and logical volume, there is a /dev/r* device that you can use. This is the raw device version of the normal /dev/* device. Stef -- [EMAIL PROTECTED] Using Linux as bandwidth manager http://www.docum.org/
TSM Server 5.2.2.5 Delete filespace
I just last week upgraded TSM Server to 5.2.2.5 from 4.2.3.4 on AIX. I just ran a DEL FILESPACE. While it was running it showed 0 objects deleted and when it ended the actlog showed successful, but still showed 0 objects deleted. It obviously did delete as the filespaces didn't exist anymore and I was able to Remove Node. The node was a W2K node and I had run CLEANUP BACKUPGROUPS just before the upgrade and had no updates from that. David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5509 [EMAIL PROTECTED] ## This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ##
Re: admin password on 5.2
hmmm.since I can't do a dsmadmc I don't know how I might do a q status. I don't see the parm in the dsmserv.opt [EMAIL PROTECTED] 06/30/2004 12:40:41 PM Check the minimum password length that was set on your TSM server (query status will show a minimum password length field). Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] 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. Lawrence Clark [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 06/30/2004 08:48 Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject Re: admin password on 5.2 Trying to log onto a 5.2 installation. Get: Enter your user id: admin Enter your password: Your password has expired. Enter your password: Please enter a new password: Enter new password for verification: ANS1262E Password is not updated. Either an invalid current password was supplie d or the new password does not fulfill the server password requirements. ANS1051E Invalid password Enter your password: tried 8 characters 1234567a, no good, tried uoieax99, no good. What are the restrictions?
Re: TSM Server 5.2.2.5 Delete filespace
Hello David, this is a known defect, described by apar IC39306. This apar will be fixed in the 5.2.3.0 level of the server to be available very shortly. Rejean Larivee IBM Tivoli Storage Manager support ** Visit our new IBM Tivoli Storage Manager support page: http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html Expand IBM Tivoli product knowledge through our Support Technical Exchange. http://www-3.ibm.com/software/sysmgmt/products/support/supp_tech_exch.html ** David Longo [EMAIL PROTECTED] TH-FIRST.ORG To Sent by: ADSM: [EMAIL PROTECTED] Dist Stor cc Manager [EMAIL PROTECTED] Subject .EDU TSM Server 5.2.2.5 Delete filespace 06/30/2004 01:54 PM Please respond to ADSM: Dist Stor Manager I just last week upgraded TSM Server to 5.2.2.5 from 4.2.3.4 on AIX. I just ran a DEL FILESPACE. While it was running it showed 0 objects deleted and when it ended the actlog showed successful, but still showed 0 objects deleted. It obviously did delete as the filespaces didn't exist anymore and I was able to Remove Node. The node was a W2K node and I had run CLEANUP BACKUPGROUPS just before the upgrade and had no updates from that. David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5509 [EMAIL PROTECTED] ## This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ##
Re: admin password on 5.2
it took 4 ddigits with f letters for the new password... [EMAIL PROTECTED] 06/30/2004 12:40:41 PM Check the minimum password length that was set on your TSM server (query status will show a minimum password length field). Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] 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. Lawrence Clark [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 06/30/2004 08:48 Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject Re: admin password on 5.2 Trying to log onto a 5.2 installation. Get: Enter your user id: admin Enter your password: Your password has expired. Enter your password: Please enter a new password: Enter new password for verification: ANS1262E Password is not updated. Either an invalid current password was supplie d or the new password does not fulfill the server password requirements. ANS1051E Invalid password Enter your password: tried 8 characters 1234567a, no good, tried uoieax99, no good. What are the restrictions?
Re: admin password on 5.2
try to shutdown the tsmserver (sending a kill signal should do the trick or stop the service for windows) then start the tsm server in console mode, this means get on a command prompt and execute the dsmserv(.exe) This will give you an almost standard dsmadmc prompt, now add/set an administrator, halt the server and start as usual. regards Otto Schakenbos System Administrator TEL: +49-7151/502 8468 FAX: +49-7151/502 8489 MOBILE: +49-172/7102715 E-MAIL: [EMAIL PROTECTED] TFX IT-Service AG Fronackerstrasse 33-35 71332 Waiblingen GERMANY Lawrence Clark wrote: hmmm.since I can't do a dsmadmc I don't know how I might do a q status. I don't see the parm in the dsmserv.opt [EMAIL PROTECTED] 06/30/2004 12:40:41 PM Check the minimum password length that was set on your TSM server (query status will show a minimum password length field). Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] 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. Lawrence Clark [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 06/30/2004 08:48 Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject Re: admin password on 5.2 Trying to log onto a 5.2 installation. Get: Enter your user id: admin Enter your password: Your password has expired. Enter your password: Please enter a new password: Enter new password for verification: ANS1262E Password is not updated. Either an invalid current password was supplie d or the new password does not fulfill the server password requirements. ANS1051E Invalid password Enter your password: tried 8 characters 1234567a, no good, tried uoieax99, no good. What are the restrictions?
Migration steps TSM 5.1 to 5.2 on AIX
Questions: 1). Are the dsmsrv.opt compatible across 5.1 to a 5.2 TSM release 2). Will the upgradedb auto-invoke when I attempt to bring up the 5.2 server pointing to the old 5.1 database 3). If not, where is it.upgradedb is not found on the server. Would it be explicitly invoked prior to bringing up the 5.2 server as in dsmc upgradedb? 4). Are there any things that should be done prior to migration, such as an audit db on the 5.1 TSM db My plan is below for the AIX environment. Any helpful comments would be useful: Upgrade TSM steps: Current setup: *TSM Server Version 5, Release 1, Level 6.1 * AIX 4.3.3.0 Migrating to: *TSM Server Version 5, Release 2, Level 2.0TSM Server * AIX 5.2.0.0 All current storage of disk based volume groups and TSM DB is on SSA disk. Migration scenario: * Stop all scheduled processes on old server * Back up TSM db on old server * Halt both servers * Move from old to new server /usr/tivoli/tsm/server/bin/ o Dsmserv.opt o Dsmserv.sys o Dsmserv.dsk * Move from old to new server /home/root/tsmfiles/ o Devconfig.info o Volhistory.info o Inclexcl.list (for client) o Dsm.opt (for client) * Export SSA disk on current TSM server * Import SSA disk on replacement server running TSM 5.2 * Verify all volume groups and mount points are set. * Start new server (is upgradedb invoked?) * Bring over tape libraries * Recycle node and TSM server
Re: admin password on 5.2
Anybody knows password on 5.2 Win2K3? - Original Message - From: Otto Schakenbos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 12:34 PM Subject: Re: admin password on 5.2 try to shutdown the tsmserver (sending a kill signal should do the trick or stop the service for windows) then start the tsm server in console mode, this means get on a command prompt and execute the dsmserv(.exe) This will give you an almost standard dsmadmc prompt, now add/set an administrator, halt the server and start as usual. regards Otto Schakenbos System Administrator TEL: +49-7151/502 8468 FAX: +49-7151/502 8489 MOBILE: +49-172/7102715 E-MAIL: [EMAIL PROTECTED] TFX IT-Service AG Fronackerstrasse 33-35 71332 Waiblingen GERMANY Lawrence Clark wrote: hmmm.since I can't do a dsmadmc I don't know how I might do a q status. I don't see the parm in the dsmserv.opt [EMAIL PROTECTED] 06/30/2004 12:40:41 PM Check the minimum password length that was set on your TSM server (query status will show a minimum password length field). Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] 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. Lawrence Clark [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 06/30/2004 08:48 Please respond to ADSM: Dist Stor Manager To [EMAIL PROTECTED] cc Subject Re: admin password on 5.2 Trying to log onto a 5.2 installation. Get: Enter your user id: admin Enter your password: Your password has expired. Enter your password: Please enter a new password: Enter new password for verification: ANS1262E Password is not updated. Either an invalid current password was supplie d or the new password does not fulfill the server password requirements. ANS1051E Invalid password Enter your password: tried 8 characters 1234567a, no good, tried uoieax99, no good. What are the restrictions?
Re: raw partitions
If possible, I would be interested in obtaining a copy of the pdf document you refer to. Thanks! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Stef Coene Sent: Wednesday, June 30, 2004 12:52 PM To: [EMAIL PROTECTED] Subject: Re: raw partitions On Tuesday 29 June 2004 20:33, [EMAIL PROTECTED] wrote: == In article [EMAIL PROTECTED], Joni Moyer [EMAIL PROTECTED] writes: Hello all! I was reading the performance tuning guide and it states that we should use raw partitions for server db, log and disk storage pool volumes for an AIX server and I was just wondering if this is true and what the benefits are of configuring volumes in this manner? Simpler, faster, less space overhead. Euh, yes and no. For AIX and jfs2 file systems, you can enable CIO (in /etc/filesystems: options = rw,cio). If you do so, your file systems are as fast as raw devices. So you have the benefits of a file system and the speed of a raw device. The I/O requests are directly done on the disk, all cache is skipped. I have a pdf file about this setup for oracle and the speed you can get. We once enabled this on a very busy AIX server and the oracle database was very, very fast. As I understand it, if we configure raw logical volumes, the AIX volume group will need to be applied to a raw logical volume, as opposed to a standard UNIX filesytem. For each disk and logical volume, there is a /dev/r* device that you can use. This is the raw device version of the normal /dev/* device. Stef -- [EMAIL PROTECTED] Using Linux as bandwidth manager http://www.docum.org/
Re: AIX 5.2 CIO raw partitions Info
Check this out http://www-1.ibm.com/servers/aix/whitepapers/db_perf_aix.pdf Charlie Hurtubise Tecsys Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Thach, Kevin G Sent: Wednesday, June 30, 2004 1:44 PM To: [EMAIL PROTECTED] Subject: Re: raw partitions If possible, I would be interested in obtaining a copy of the pdf document you refer to. Thanks! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Stef Coene Sent: Wednesday, June 30, 2004 12:52 PM To: [EMAIL PROTECTED] Subject: Re: raw partitions On Tuesday 29 June 2004 20:33, [EMAIL PROTECTED] wrote: == In article [EMAIL PROTECTED], Joni Moyer [EMAIL PROTECTED] writes: Hello all! I was reading the performance tuning guide and it states that we should use raw partitions for server db, log and disk storage pool volumes for an AIX server and I was just wondering if this is true and what the benefits are of configuring volumes in this manner? Simpler, faster, less space overhead. Euh, yes and no. For AIX and jfs2 file systems, you can enable CIO (in /etc/filesystems: options = rw,cio). If you do so, your file systems are as fast as raw devices. So you have the benefits of a file system and the speed of a raw device. The I/O requests are directly done on the disk, all cache is skipped. I have a pdf file about this setup for oracle and the speed you can get. We once enabled this on a very busy AIX server and the oracle database was very, very fast. As I understand it, if we configure raw logical volumes, the AIX volume group will need to be applied to a raw logical volume, as opposed to a standard UNIX filesytem. For each disk and logical volume, there is a /dev/r* device that you can use. This is the raw device version of the normal /dev/* device. Stef -- [EMAIL PROTECTED] Using Linux as bandwidth manager http://www.docum.org/
Re: Novell cluster volume not able to contact client
Timothy, If you're not going to use the dsmcad for scheduling (which I would recommend) then you have to have the dsmc sched nlm loaded. To use the cad you need the line managedservices webclient schedule. Here's an example of our opt file for a cluster node: * * Communications settings * --- * Setting Options for the TCP/IP Communication Method * --- * COMMMETHODTCPip TCPSERVERADDRESS xxx.x.xxx.xx TCPPORT 1500 * Setting Nodename * --- NODENAME aisutah_data2 MEMORYEFFICIENTBACKUP YES NWPWFILE YES managedservices webclient schedule * traceflags service txnbytelimit 25600 tcpwindowsize 63 tcpbuffsize 32 tcpnodelay yes resourceutilization 10 domain d2: httpport 7224 passwordaccess generate errorlogname d2:\backup\dsmerror.log schedlogname d2:\backup\dsmsched.log schedlogretention 7 errorlogretention 7 clusternode yes passworddir d2:\backup Timothy Hughes wrote: Hello, We are still working on our Novell TSM Cluster, We keep getting the following message in the server log. while trying to backup the Domain Novl3 on the Cluster at midnight. (ANR2716E Schedule prompter was not able to contact client DOCCS1USRS using type 1 (10.xx.xx.xx 1501). I can click on a link to that domain and it takes me to the backup/restore gui screen so why isn't the backup working a midnight? Anyone with any suggestions/tips/hints? Thanks for any comments in advance! The DSM.opt file for the Domain Novl3 COMMMETHOD TCPip TCPCLIENTADDRESSxx.xx.xx.xx TCPSERVERADDRESSxx.xx.xx.xx (tsm server ip) TCPPORT 1500 HTTPPORT1635 errorlogretention 14 schedlogretention 7 NODENAME docsiusr CLUSTERNODEyes DOMAIN nvol3: ERRORLOGNAME docsiusr\nvol3:tivoli\dsmerror.log SCHEDLOGNAME docsiusr\nvol3:tivoli\dsmsched.log PASSWORDDIRdocsiusr\nvol3:tivoli\password passwordaccess generate NWPWFILE YES schedmode prompted * Testflag allows client to exit from unload TESTFLAG enablescriptinput * CADMODE WEBCLIENT SCHED (possibly needed to manager client acceptor and sched services. MEMORYEFFICIENTBACKUP YES NWEXITNLMP NO * NWUSER server_1_name\user\:password * NWUSER server_2_name\user:password * NWUSER nds_tree_name\user:password Quiet * VERBOSE -- Jim Kirkman AIS - Systems UNC-Chapel Hill 966-5884 (old desk) 698-8615 (new cell!)
TDP for MSSQL 5.2.1 performance issues and questions.
One of my users is trying to restore a 22 gig MSSQL database using TDP v5.2.1. The entire restore is taking several hours from start to finish and I have no idea why. I've watched the process and once it mounts the tape (the whole DB fits on 1 tape) ,it just sits for usually hours and appears to do nothing. Any clues why this is taking so long? We are running our TSM 5.2.2.4 server under AIX 5.1 if it matters. Any suggestion on what to look at? Thanks, John
Re: TDP for MSSQL 5.2.1 performance issues and questions.
The delay is that with large DB's, you have to wait for the DB file to be recreated on disk before it can be restored from backup. With only say a 1 GB file, it's hardly noticeable. They has been some occasional discussion about this. David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5509 [EMAIL PROTECTED] [EMAIL PROTECTED] 06/30/04 03:50PM One of my users is trying to restore a 22 gig MSSQL database using TDP v5.2.1. The entire restore is taking several hours from start to finish and I have no idea why. I've watched the process and once it mounts the tape (the whole DB fits on 1 tape) ,it just sits for usually hours and appears to do nothing. Any clues why this is taking so long? We are running our TSM 5.2.2.4 server under AIX 5.1 if it matters. Any suggestion on what to look at? Thanks, John ## This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ##
Re: TDP for MSSQL 5.2.1 performance issues and questions.
John, This is normal. SQL Server is pre-formatting the files in preparation for the restore. Data Protection for SQL restores a small bit of information that the SQL Server requires to properly set up and preformat the files. After that, Data Protection for SQL must wait around until the SQL Server starts requesting more data to fill the files. There is a README entry and a User's Guide note about this: We recommend that the COMMTIMEOUT value on the TSM Server be set to at least 600 seconds. The SQL Server must preformat the database files prior to restoring the database in those files. This occurs after a small amount of data has already been restored from the TSM Server. When restoring very large databases, it may be necessary to set COMMTIMEOUT to even larger values than 600. Failure to do so may result in restores that fail due to a severed TCP/IP connection caused by the TSM Server thinking that DP for SQL is hung. Thanks, Del ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 06/30/2004 03:50:00 PM: One of my users is trying to restore a 22 gig MSSQL database using TDP v5.2.1. The entire restore is taking several hours from start to finish and I have no idea why. I've watched the process and once it mounts the tape (the whole DB fits on 1 tape) ,it just sits for usually hours and appears to do nothing. Any clues why this is taking so long? We are running our TSM 5.2.2.4 server under AIX 5.1 if it matters. Any suggestion on what to look at? Thanks, John