AW: Outlook PST files
Hi Bruce, we are using subfilebackup for the users .pst files and are happy with it. Backuptime didn't rise and we got a drop of amount of backup data round about 55% (pst and other files together) Wan clients I have implemented Adaptive subfile differencing but still running marathon backups of some these clients. Why don't you try to use subfile feature in your LAN? Wirh regards, Stefan Holzwarth
Re: Backup Report
This is a very old weakness of ADSM. I did from v1.6 to V3.1 some GREP and post-execute commands and scripting and colleague with HP Omniback laughed about me while clicking on his expandable coloured tree formed backup results. Maybe I will find something better in latest TSM versions I am just going to install, or a market chance for a shareware writer? regards Juraj Salak Austria -Original Message- From: John [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:59 PM To: [EMAIL PROTECTED] Subject: Backup Report Hi TSM'ers I am busy implementing a TSM/WIN2K environment and the customer asked me to do an interim demo today. The scheduled backup of the local client ran ok but failed due to open files. He then asked me what I thought was a legitimate question: Where is the output report so that we can know why the backup failed, and not just that it did fail. I know other backup solutions can do this. Apart from looking in the TSM event log is there anyway to make TSM automatically generate an output report and say email it to someone? If anyone has done this before I would appreciate your help. Ta John
verbose after successfully backed up
hi there, I have 15 ADSM Nodes installed and running under AIX. I have 15 GUI client installed on 12 Nt server and 3 AIX server Client type: TSM Archive client 4.2.1.20 (full backup of the system) TDP for Domino client 1.1.2 (selective and incremental backup + archivelog for Domino) When the backup is finished, i have to remote the server and watch for successfully process to be sure that the backup had run correctly. Is there a way to send an Email to the IT and verbose the backup process when it is done ? If yes, I would appreciate some explanation, cause i'm new in managing ADSM Node and Client. thanks for any answers. Sincerly, Mike __ _ Michael REGELIN Ingénieur Informatique - O.S.O. Groupware Messagerie Centre des Technologies de l'Information (CTI) Route des Acacias 82 CP149 - 1211 Genève 8 Tél. + 41 22 3274322 - Fax + 41 22 3275499 Mailto:[EMAIL PROTECTED] http://intraCTI.etat-ge.ch/services_complementaires/messagerie.html __
Error on SAP redologs backup
Hi there, TDP for SAP R/3 on W2000 v 3.2.0.1, TSM server for MVS 4.2.0.0 TDP for SAP R/3 sometimes reports error on redolog backups. There are 2 copies of redologs backed up to 2 different diskpools ( - tapepools). All seems to be OK, but there is error message on the end of backup. This is last part of log generated by BACKINT (whole log is attached): === BKI1215I: Average transmission rate was 25.408 GB/h (7.227 MB/sec). BKI0020I: End of backint program at: 03/31/02 03:46:14 . BKI0021I: Elapsed time: 14 min 49 sec . BKI0024I: Return code is: 0. BR232E 159 of 159 files saved by backup utility BR280I Time stamp 2002-03-31 04.46.14 BR231E Backup utility call failed BR016I 159 offline redo log files processed, total size 3179.978 MB BR007I End of offline redo log processing: adhqrvlg.svd 2002-03-31 04.47.02 BR280I Time stamp 2002-03-31 04.47.02 BR005I BRARCHIVE terminated with errors == I cannot find any other error in log and all redologs were backed up in two copies. Any idea Wiht best regards Tom adhqrvlg.zip Description: Zip compressed data
Re: Locale on HP-UX 11.0 TSM Server
dear Mr Bob smith The AIX, Solaris, and HP-UX support locales other than English that describe every user interface that varies with location or language. Solaris and HP-UX only support English, Simplified Chinese, and Japanese locale information. The default directories for system-supplied locales are as follows. AIX /usr/lib/nls/loc Solaris /usr/lib/locale HP-UX /usr/lib/nls/locales The servers and clients obtain format information from the locale definition in effect at the time it's called. I recommend you to consult the documentation on your local system for details bout setting up your locale definition. 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 Smith, Bob Sent: 22. apríl 2002 09:02 To: [EMAIL PROTECTED] Subject: Locale on HP-UX 11.0 TSM Server We are implementing a new server on HP-UX 11.0. The Language option defaults to AMENG, but all times in TSM - activity log etc - show as Mon, Apr 22, 2002 09:28:57 AM. This is most irritating as all the times now split on to two lines, and I don't really need all this detail. Setting dateformat and timeformat makes no difference. Only by setting the locale to Portuguese (pt_PT.roman8) do I get times like this - 22/04/2002 09.28.51, which is more acceptable (it doesn't split on to 2 lines), but the decimal point is now a comma. Has anyone experience of this problem on HP-UX 11.0 and done something different? Bob Smith
Locale on HP-UX 11.0 TSM Server
We are implementing a new server on HP-UX 11.0. The Language option defaults to AMENG, but all times in TSM - activity log etc - show as Mon, Apr 22, 2002 09:28:57 AM. This is most irritating as all the times now split on to two lines, and I don't really need all this detail. Setting dateformat and timeformat makes no difference. Only by setting the locale to Portuguese (pt_PT.roman8) do I get times like this - 22/04/2002 09.28.51, which is more acceptable (it doesn't split on to 2 lines), but the decimal point is now a comma. Has anyone experience of this problem on HP-UX 11.0 and done something different? Bob Smith
Re: Expiration ...
Thanks ... I'll try this Jan -Original Message- From: Tomás Hrouda [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 12:44 PM To: [EMAIL PROTECTED] Subject: Re: Expiration ... Hi Jan, you are completely right. As you mentioned, possible (and I mean correct too) way is 1. change retention periods to reflect your new policy requirements, 2. validate policy set, 3. activate policy set, 4. run expiration on TSM server manually (command EXPIRE INVENTORY) and 5. reclaim free space on volumes (or see your volumes goes SCRATCH if reclamation runs automatically). Change of retention periods affects all files binded to management class you've changed, this means previous backed up as well as future backed up files. Hope this helps. Tom -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Jan de Raeymaeker Sent: Monday, April 22, 2002 1:01 PM To: [EMAIL PROTECTED] Subject: Expiration ... We have hit a snag on the system where by we need to manually expire volumes urgently. Our current policy is for 60 days retention, but we need to claw back some volumes for scratch. If I change the retention period I am under the impression that this will not age out existing volumes but simple take affect from the point of change. Is this the case ? I have been told by a consultant that we may have to delete volumes and it could get a little messy. This seems a bit extreme. There must be a way of changing the status of volumes manually which will convince the TSM system that the volumes have expired. Then I should be able to run a normal expire inventory and let the server do the work. Is this possible / correct ? If yes, how can it be done ? If no, what is the solution ? I am working on AIX 4.3.3 ML9, TSM 4.2.1.11. All help is welcome. Thank you Jan ** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action or reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer. **
Expiration ...
We have hit a snag on the system where by we need to manually expire volumes urgently. Our current policy is for 60 days retention, but we need to claw back some volumes for scratch. If I change the retention period I am under the impression that this will not age out existing volumes but simple take affect from the point of change. Is this the case ? I have been told by a consultant that we may have to delete volumes and it could get a little messy. This seems a bit extreme. There must be a way of changing the status of volumes manually which will convince the TSM system that the volumes have expired. Then I should be able to run a normal expire inventory and let the server do the work. Is this possible / correct ? If yes, how can it be done ? If no, what is the solution ? I am working on AIX 4.3.3 ML9, TSM 4.2.1.11. All help is welcome. Thank you Jan ** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action or reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer. **
Affects of changing Retentions Questions
I had made a change in our copy groups from VerExists and VerDeleted from NoLimit to Verexists 5 Verdeleted 3. It appears by doing this all of the TSM clients (WinNT, Win2K, Novel, Sun ETC) are going through a full backup to apply the changes to each file which is causing a huge load on the TSM servers and the recovery log fills. Couple Questions 1) By making this change doe the node then have to re-examine all clients file and back them up as if it was a new client.? 2) If yes to No 1 then it would create a Huge load on the server? 3) Anyone know of a way improve / speed up the process? (DB Cache is 98-99% 4) For the new retentions to take affect does the following need to happen? Node Backup, DB Backup, then expire? 5) If I change the copy group retentions back to a create the same situation all over? Environment Info Server Info = Running TSM 4.1.5.3 on AIX 4.3.3 Client Info= Netware 4.11, 5, Win2K SP2, Winnt4 SP4+ , Solaris 2.8, 8, AIX 4.3.3 Any help on how to improve this process would be GREATLY appreciated!!! Regards, Charles Hart
Re: Expiration ...
Hi Jan, you are completely right. As you mentioned, possible (and I mean correct too) way is 1. change retention periods to reflect your new policy requirements, 2. validate policy set, 3. activate policy set, 4. run expiration on TSM server manually (command EXPIRE INVENTORY) and 5. reclaim free space on volumes (or see your volumes goes SCRATCH if reclamation runs automatically). Change of retention periods affects all files binded to management class you've changed, this means previous backed up as well as future backed up files. Hope this helps. Tom -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Jan de Raeymaeker Sent: Monday, April 22, 2002 1:01 PM To: [EMAIL PROTECTED] Subject: Expiration ... We have hit a snag on the system where by we need to manually expire volumes urgently. Our current policy is for 60 days retention, but we need to claw back some volumes for scratch. If I change the retention period I am under the impression that this will not age out existing volumes but simple take affect from the point of change. Is this the case ? I have been told by a consultant that we may have to delete volumes and it could get a little messy. This seems a bit extreme. There must be a way of changing the status of volumes manually which will convince the TSM system that the volumes have expired. Then I should be able to run a normal expire inventory and let the server do the work. Is this possible / correct ? If yes, how can it be done ? If no, what is the solution ? I am working on AIX 4.3.3 ML9, TSM 4.2.1.11. All help is welcome. Thank you Jan ** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action or reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer. **
logging in as a different client???
Environment: TSM Server @ V4.2 S390 Client: AIX @ 3106 and 4.2 Situation: have client A and Client B. Want to log in to TSM server from client A, but as Client B. I know the syntax on NT, could anyone help me on the AIX platform? Thx. Regards, Joe Wholey TGA Distributed Data Services Merrill Lynch Phone: 212-647-3018 Page: 888-637-7450 E-mail: [EMAIL PROTECTED]
Re: TDP for Domino backup File is in use or File (NULL) could not be opened for reading
File (NULL) could not be opened for reading or This database is currently being used by someone else. In order to share a Notes database, all users must use a Domino Server instead of a File Server. Etienne, This sounds like a configuration problem. 1. Make sure that the NOTESINIPATH (DOMDSMC QUERY PREF) is set to the directory containing the NOTES.INI file of the Domino server you are backing up. 2. Also, make sure there is not another NOTES.INI file anywhere in your path or in the WINNT or WINNT\SYSTEM32 directory. This can cause problems. We usually have customers search their entire filesystem for all the NOTES.INI files. Then, temporarily rename all of the them, EXCEPT for the one they want to use, to some other name. Then retry the operation. In some cases, even though you have NOTESINIPATH pointing to the correct NOTES.INI location, Domino itself will look in other places first. :-( 3. Also, be sure that you are running TDP for Domino 1.1.2. Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] - Leave everything a little better than you found it. - Smile a lot: it costs nothing and is beyond price.
Rif: Error on SAP redologs backup
Your log reports the following error: BR372E File L:\oracle\SK2\saparch\SK2126010.001 was already reported as saved by backup utility This was fixed with TDP v 3.2.0.8 (APAR IC32365 - REDOLOGS REPORTED TWICE). Regards, Stefano Tomá? Hrouda throuda@HTD.Per:[EMAIL PROTECTED] CZ Cc: Inviato da: Oggetto: Error on SAP redologs backup ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 22/04/2002 12.38 Per favore, rispondere a ADSM: Dist Stor Manager Hi there, TDP for SAP R/3 on W2000 v 3.2.0.1, TSM server for MVS 4.2.0.0 TDP for SAP R/3 sometimes reports error on redolog backups. There are 2 copies of redologs backed up to 2 different diskpools ( - tapepools). All seems to be OK, but there is error message on the end of backup. This is last part of log generated by BACKINT (whole log is attached): === BKI1215I: Average transmission rate was 25.408 GB/h (7.227 MB/sec). BKI0020I: End of backint program at: 03/31/02 03:46:14 . BKI0021I: Elapsed time: 14 min 49 sec . BKI0024I: Return code is: 0. BR232E 159 of 159 files saved by backup utility BR280I Time stamp 2002-03-31 04.46.14 BR231E Backup utility call failed BR016I 159 offline redo log files processed, total size 3179.978 MB BR007I End of offline redo log processing: adhqrvlg.svd 2002-03-31 04.47.02 BR280I Time stamp 2002-03-31 04.47.02 BR005I BRARCHIVE terminated with errors == I cannot find any other error in log and all redologs were backed up in two copies. Any idea Wiht best regards Tom (See attached file: adhqrvlg.zip) =?iso-8859-1?Q?adhqrvlg.zip?= Description: Zip archive
Re: logging in as a different client???
That's Simple: dsmc -machine=node name Ran. -Original Message- From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: logging in as a different client??? Environment: TSM Server @ V4.2 S390 Client: AIX @ 3106 and 4.2 Situation: have client A and Client B. Want to log in to TSM server from client A, but as Client B. I know the syntax on NT, could anyone help me on the AIX platform? Thx. Regards, Joe Wholey TGA Distributed Data Services Merrill Lynch Phone: 212-647-3018 Page: 888-637-7450 E-mail: [EMAIL PROTECTED]
expiring object
Hello, When consulting the gui client for a Restore, I'm surprised to see that some files are not present to be restored. the management class have been set up correctly to keep 13 versions. Only 2 versions are visible (in active and inactive mode). I controled the dsm.opt. It is correctly using the management class: include *.nsf domino_month by the way, when expiring is in effect, is it the hole backup set or only the file that is expired ? Could anyone help me ? Thank's __ _ Michael REGELIN Ingénieur Informatique - O.S.O. Groupware Messagerie Centre des Technologies de l'Information (CTI) Route des Acacias 82 CP149 - 1211 Genève 8 Tél. + 41 22 3274322 - Fax + 41 22 3275499 Mailto:[EMAIL PROTECTED] http://intraCTI.etat-ge.ch/services_complementaires/messagerie.html __
Re: TDP for Domino backup File is in use or File (NULL) could not be opened for reading
Thanks for the help, but on it's second run (and I have not changed anything, except I did an entire backup while the server was down this weekend) everything was backed up correctly by the Scheduler. Hope it will keep this up! Thanks again. Etienne Brodeur Del Hoobler [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/22/2002 08:30 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TDP for Domino backup File is in use or File (NULL) could not be opened for reading File (NULL) could not be opened for reading or This database is currently being used by someone else. In order to share a Notes database, all users must use a Domino Server instead of a File Server. Etienne, This sounds like a configuration problem. 1. Make sure that the NOTESINIPATH (DOMDSMC QUERY PREF) is set to the directory containing the NOTES.INI file of the Domino server you are backing up. 2. Also, make sure there is not another NOTES.INI file anywhere in your path or in the WINNT or WINNT\SYSTEM32 directory. This can cause problems. We usually have customers search their entire filesystem for all the NOTES.INI files. Then, temporarily rename all of the them, EXCEPT for the one they want to use, to some other name. Then retry the operation. In some cases, even though you have NOTESINIPATH pointing to the correct NOTES.INI location, Domino itself will look in other places first. :-( 3. Also, be sure that you are running TDP for Domino 1.1.2. Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] - Leave everything a little better than you found it. - Smile a lot: it costs nothing and is beyond price.
Re: Expiration ...(full vols 0.0% utilized)
Have you checked to ensure you don't have any ~HUNG~ volumes ? We recently discovered (in TSM 4.1) that if we had reclamation running during our DB backup that TSM would have some lock problems and once all the data was moved off a volume, it wouldn't roll scratch again ! ! ! I went out and looked and we had close to 100 tapes that were FULL and 0% utilized ! ! ! We had to run ~audit vol fix=yes~ against each of these volumes (to clear up hanging references) but this only moved them to an EMPTY state where they stayed until we issued a ~delete vol~ against each of them at which time they rolled scratch again. you might try a q vol stat=full and see if you have any that are 0.0% utilized... Dwight E. Cook Software Application Engineer III Science Applications International Corporation 509 S. Boston Ave. Suit 220 Tulsa, Oklahoma 74103-4606 Office (918) 732-7109 -Original Message- From: Jan de Raeymaeker [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 6:01 AM To: [EMAIL PROTECTED] Subject: Expiration ... We have hit a snag on the system where by we need to manually expire volumes urgently. Our current policy is for 60 days retention, but we need to claw back some volumes for scratch. If I change the retention period I am under the impression that this will not age out existing volumes but simple take affect from the point of change. Is this the case ? I have been told by a consultant that we may have to delete volumes and it could get a little messy. This seems a bit extreme. There must be a way of changing the status of volumes manually which will convince the TSM system that the volumes have expired. Then I should be able to run a normal expire inventory and let the server do the work. Is this possible / correct ? If yes, how can it be done ? If no, what is the solution ? I am working on AIX 4.3.3 ML9, TSM 4.2.1.11. All help is welcome. Thank you Jan ** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action or reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer. **
Re: Single Drive Manual Library
Hi, using of large disk stg pools minimises tape unload/load cycles which is important in such situation if you can afford two tape drives (you do can configure one tsm manual library consisting from more tape drives as opposite to impossibility of definig one tsm library consisting of more (hw) tape libraries) then you have no problems at all if you have one tape drive only then some workarounds for tape2tape operations are necessary generally speaking - it works like a breeze, I had it with v3.1 2 years ago and am about to configure newest version this way soon regards juraj Salak [EMAIL PROTECTED] -Original Message- From: Kolbeinn Josepsson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:51 PM To: [EMAIL PROTECTED] Subject: Single Drive Manual Library Hi all there, Does anyone have experience using TSM with Single Drive Manual Library for small sites? I think it is rather complicated to get those configuration to work without problems, I have not found any recommendations or samples in Red Books or Tivoli Manuals. If anyone have found out a good working configuration for Single Drive Manual Library installation, and like to share it with others, then kindly reply with short description of how to do... Also any suggestions are welcome. Thanks and regards, Kolbeinn Josepsson NYHERJI HF. BORGARTUN 37 IS-105 REYKJAVIK ICELAND
Single Drive Manual Library
Hi all there, Does anyone have experience using TSM with Single Drive Manual Library for small sites? I think it is rather complicated to get those configuration to work without problems, I have not found any recommendations or samples in Red Books or Tivoli Manuals. If anyone have found out a good working configuration for Single Drive Manual Library installation, and like to share it with others, then kindly reply with short description of how to do... Also any suggestions are welcome. Thanks and regards, Kolbeinn Josepsson NYHERJI HF. BORGARTUN 37 IS-105 REYKJAVIK ICELAND
Re: Single Drive Manual Library
I HAD a client like your describe, small sites (less than 40 GB total storage) withan LTO 3580 tape drive. The problem is that you have to do reclamation on the disks (since you only have one tape drive), now with an LTO tape (100 to 200 GB depending of compression) that's a lot os space to leave empty on the server. So my client decided to NOT use reclamation. He routinely deleted the volumes manually to be able to reuse them. To make sure that he had a full copy of his files I configured a selective backup that took everything on his machines once per week. I had to setup TSM to work like the good old days of four incremental and then a full backup. As for the DB backups, he had to change the tape in his drive (doing a dismount vol _volname_ first) manually before the schedule DB backup at 10:00 AM (he didn't want to have to type the commands himself). Then he loads the tapes for tonight checking to make sure there is enough space on it. If there isn't enough space then he does a delete volume _volname_ discarddata=yes. In other words it's pretty horrible. We added an old tape drive he had lying around and use that for the DB backups which helped a little. I guest if you have reclamation it would help a lot, but you still have to manipulate the tapes a lot and check for free space on them before using them. I have setup sites in collocation with small library 5-8 slots and one drive and that works well as long as you have enough space on disks to reclaim your volumes. If anyone as good way of functionning with a single tape drive let me know! Etienne Brodeur Kolbeinn Josepsson [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/22/2002 09:51 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Single Drive Manual Library Hi all there, Does anyone have experience using TSM with Single Drive Manual Library for small sites? I think it is rather complicated to get those configuration to work without problems, I have not found any recommendations or samples in Red Books or Tivoli Manuals. If anyone have found out a good working configuration for Single Drive Manual Library installation, and like to share it with others, then kindly reply with short description of how to do... Also any suggestions are welcome. Thanks and regards, Kolbeinn Josepsson NYHERJI HF. BORGARTUN 37 IS-105 REYKJAVIK ICELAND
Re: expiring object
When consulting the gui client for a Restore, I'm surprised to see that some files are not present to be restored. the management class have been set up correctly to keep 13 versions. Only 2 versions are visible (in active and inactive mode). I controled the dsm.opt. It is correctly using the management class: include *.nsf domino_month by the way, when expiring is in effect, is it the hole backup set or only the file that is expired ? Michael, Make sure you are running TDP for Domino 1.1.2. It fixed a problem where some of the backups were not showing up correctly in the GUI. What does the DOMDSMC QUERY DBB * /SUBDIR=YES command show? Do you see all your backups? Another thing to do is use the SHOW VERSION nodename fsname TSM Server command to find out what versions actually exist on the TSM Server. Each Domino database backup is expired on its own. It is not tied to other backups that occurred during the entire Domino server backup. It is treated just like a file when using the TSM BA client. Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] - Leave everything a little better than you found it. - Smile a lot: it costs nothing and is beyond price.
Re: sense errors
This sense code indicates a medium error where the format was corrupted. This error is usually associated with a TSM volume where someone did other than TSM recordings (dd, Veritas, tar, etc) George Lesho System/Storage Admin AFC Enterprises Johnn D. Tan [EMAIL PROTECTED]To: [EMAIL PROTECTED] L.EDU cc: (bcc: George Lesho/Partners/AFC) Sent by: ADSM: Subject: sense errors Dist Stor Manager [EMAIL PROTECTED] .EDU 04/18/02 03:31 PM Please respond to ADSM: Dist Stor Manager Does anyone have any ideas on the following errors that showed up in our TSM activity log? We have TSM 4.1.3 server running on AIX 4.3.3ML9, connected to a SpectraLogic HVD 64000/Gator (with Sony SDX-500C drives). We've sent the sense code info to Tivoli as well as SpectraLogic, but they point at each other or general SCSI problems. We've already swapped out the cables, the terminators, even one of the SCSI cards. We've cleaned the drives, changed the filters, re-connected the cables, etc. Even though all of the below are on DRIVE1, it actually happens to all six of our drives eventually. I checked the TSM Messages manual, and it's not that helpful. * I'm writing not so much to get a definitive answer (as that's obviously something specific to our site setup), but more for other clues or leads that I could investigate. Maybe Tivoli, SpectraLogic, and our own group have all been looking in the wrong direction. * By the way, we get these on a more-or-less regular basis, like one set of three (such as below) per week or every other week. Thanks for any leads. johnn 04/18/02 07:43:55 ANR8302E I/O error on drive DRIVE1 (/dev/mt0) (OP=READ, CC=306, KEY=03, ASC=31, ASCQ=00, SENSE=F0.00.03.00.00.80.00.14.00.00.00.00.31.00.00.00.CE- .00.00.00.00.B8.01.4D.20.50., Description=Drive or media failure). Refer to Appendix B in the 'Messages' manual for recommended action. 04/18/02 07:56:40 ANR8302E I/O error on drive DRIVE1 (/dev/mt0) (OP=READ, CC=306, KEY=03, ASC=31, ASCQ=00, SENSE=F0.00.03.00.00.80.00.14.00.00.00.00.31.00.00.00.CE- .00.00.00.00.EC.01.4C.60.70., Description=Drive or media failure). Refer to Appendix B in the 'Messages' manual for recommended action. 04/18/02 08:06:17 ANR8302E I/O error on drive DRIVE1 (/dev/mt0) (OP=READ, CC=306, KEY=03, ASC=31, ASCQ=00, SENSE=F0.00.03.00.00.80.00.14.00.00.00.00.31.00.00.00.CE- .00.00.00.01.24.01.46.68.00., Description=Drive or media failure). Refer to Appendix B in the 'Messages' manual for recommended action.
Re: Expiration ...
Another way without deleting anything is this. What reclamation percent do you use? If say you use the standard of 60%, then reducing this to 55% will free up more tapes onsite and offsite. David Longo [EMAIL PROTECTED] 04/22/02 07:01AM We have hit a snag on the system where by we need to manually expire volumes urgently. Our current policy is for 60 days retention, but we need to claw back some volumes for scratch. If I change the retention period I am under the impression that this will not age out existing volumes but simple take affect from the point of change. Is this the case ? I have been told by a consultant that we may have to delete volumes and it could get a little messy. This seems a bit extreme. There must be a way of changing the status of volumes manually which will convince the TSM system that the volumes have expired. Then I should be able to run a normal expire inventory and let the server do the work. Is this possible / correct ? If yes, how can it be done ? If no, what is the solution ? I am working on AIX 4.3.3 ML9, TSM 4.2.1.11. All help is welcome. Thank you Jan ** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action or reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer. ** MMS health-first.org made the following annotations on 04/22/02 11:06:35 -- 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. ==
Piping a file to dsmc
Hello, We are using ADSM in the following environment: ADSM server Version 3, Release 7, Level 0.0 runs on Sun E6500 Solaris 5.7. IBM tape library is 3494(robot) with 3590-B1A drives. DSM client Version 3, Release 7, Level 2.0 runs on many other Sun E1 servers without any tape drives. I need to do a full database reorganization on a database of about 450GB. The export file(s) will be around 150GB which cannot be stored on disk. I need to run the export and pipe or redirect the output to tape. Is there a way to pipe a file to dsmc for backup - something like cat /etc/hosts | dsmc to backup contents of /etc/hosts ? Thanks, Farshid Behdashti
Re: Single Drive Manual Library
Kolbeinn, Yes, I've done it...but I can't say that I recommend using the backup functionality of TSM when operating in this manner. Normally what I'd do for a small site with a single drive and no robotics is stick just to archives. Unfortunately, with a single drive, doing reclamation is a serious nuisance. You can, if you are really determined to run backups, do single drive reclamations using a disk storage pool...but again, I don't recommend it. I do have customers that are using single drives and just do archives, and are getting along fine in that fashion. My $.02 -Lloyd On Mon, 22 Apr 2002 13:51:16 + Kolbeinn Josepsson [EMAIL PROTECTED] wrote: Hi all there, Does anyone have experience using TSM with Single Drive Manual Library for small sites? I think it is rather complicated to get those configuration to work without problems, I have not found any recommendations or samples in Red Books or Tivoli Manuals. If anyone have found out a good working configuration for Single Drive Manual Library installation, and like to share it with others, then kindly reply with short description of how to do... Also any suggestions are welcome. Thanks and regards, Kolbeinn Josepsson NYHERJI HF. BORGARTUN 37 IS-105 REYKJAVIK ICELAND -- - Lloyd Dieter- Senior Technology Consultant Synergy, Inc. http://www.synergyinc.cc [EMAIL PROTECTED] Main:716-389-1260fax:716-389-1267 -
TSM Client for Mac OS X
I am having problems getting the TSM 5.1 Scheduler to work properly on a Mac running OS X. I had previously been running a lower version under OS 9 and I believe I have followed all the installation instructions for the new version. When I start the TSM Mac X Scheduler Daemon it seems to initiate the TSM Scheduler (not the TSM Mac X Scheduler). This then pops up occasionally but never seems to initiate a backup. If I start TSM Mac X Scheduler directly, it initially bounces in the dock and then it starts TSM Scheduler (once then then ran and did a backup but now it just quits as soon as I enter the login info. Is this a problem with permissions? I am logged in to an administrator account. I¹m sure this question is way below the level of this list but I¹m stumped. -Eric Amis
What to do with a volume that won't ITSM mount in a 3570 library?
ITSM'ers: Enviro: AIX 4.3.3.04 H70 TSM 4.2.1.10 server MP Magstar 3570-C12 library I have 1 tape that won't mount in the 3570 via ITSM. There is still data on it and I can't figure out how to get the data off the tape if it won't mount. I don't have the SENSE data error message, though. So, how do I get data off this volume if it won't mount in ITSM? 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: sense errors
It could actually be a problem with the media. We recently had a mjor problem when a batch of 300 tapes had to be sent back and replaced. It took us a long time to determine the problem. Try inserting a tape which has a successful backup on it (i.e. get on e from offsite or someting). If this reads OK then it is probably a media fault. Good luck Jan -Original Message- From: George Lesho [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:29 PM To: [EMAIL PROTECTED] Subject: Re: sense errors This sense code indicates a medium error where the format was corrupted. This error is usually associated with a TSM volume where someone did other than TSM recordings (dd, Veritas, tar, etc) George Lesho System/Storage Admin AFC Enterprises Johnn D. Tan [EMAIL PROTECTED]To: [EMAIL PROTECTED] L.EDU cc: (bcc: George Lesho/Partners/AFC) Sent by: ADSM: Subject: sense errors Dist Stor Manager [EMAIL PROTECTED] .EDU 04/18/02 03:31 PM Please respond to ADSM: Dist Stor Manager Does anyone have any ideas on the following errors that showed up in our TSM activity log? We have TSM 4.1.3 server running on AIX 4.3.3ML9, connected to a SpectraLogic HVD 64000/Gator (with Sony SDX-500C drives). We've sent the sense code info to Tivoli as well as SpectraLogic, but they point at each other or general SCSI problems. We've already swapped out the cables, the terminators, even one of the SCSI cards. We've cleaned the drives, changed the filters, re-connected the cables, etc. Even though all of the below are on DRIVE1, it actually happens to all six of our drives eventually. I checked the TSM Messages manual, and it's not that helpful. * I'm writing not so much to get a definitive answer (as that's obviously something specific to our site setup), but more for other clues or leads that I could investigate. Maybe Tivoli, SpectraLogic, and our own group have all been looking in the wrong direction. * By the way, we get these on a more-or-less regular basis, like one set of three (such as below) per week or every other week. Thanks for any leads. johnn 04/18/02 07:43:55 ANR8302E I/O error on drive DRIVE1 (/dev/mt0) (OP=READ, CC=306, KEY=03, ASC=31, ASCQ=00, SENSE=F0.00.03.00.00.80.00.14.00.00.00.00.31.00.00.00.CE- .00.00.00.00.B8.01.4D.20.50., Description=Drive or media failure). Refer to Appendix B in the 'Messages' manual for recommended action. 04/18/02 07:56:40 ANR8302E I/O error on drive DRIVE1 (/dev/mt0) (OP=READ, CC=306, KEY=03, ASC=31, ASCQ=00, SENSE=F0.00.03.00.00.80.00.14.00.00.00.00.31.00.00.00.CE- .00.00.00.00.EC.01.4C.60.70., Description=Drive or media failure). Refer to Appendix B in the 'Messages' manual for recommended action. 04/18/02 08:06:17 ANR8302E I/O error on drive DRIVE1 (/dev/mt0) (OP=READ, CC=306, KEY=03, ASC=31, ASCQ=00, SENSE=F0.00.03.00.00.80.00.14.00.00.00.00.31.00.00.00.CE- .00.00.00.01.24.01.46.68.00., Description=Drive or media failure). Refer to Appendix B in the 'Messages' manual for recommended action. ** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action or reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer. **
Re: What to do with a volume that won't ITSM mount in a 3570library?
Look at the actlog at the time operation is attempted and see what error message is and tell us. If it is something like: ANR8779E Unable to open drive /dev/rmt4, error number=46 then most likely tape is broken. Manually inspect tape - open access door on tape and see if tape is damaged there. I've had many cases of broken 3570 tapes, this is the error you get attempting to mount a broken tape. I've seen a couple of times where this error means something else, but most of the time - broke! David Longo [EMAIL PROTECTED] 04/22/02 11:36AM ITSM'ers: Enviro: AIX 4.3.3.04 H70 TSM 4.2.1.10 server MP Magstar 3570-C12 library I have 1 tape that won't mount in the 3570 via ITSM. There is still data on it and I can't figure out how to get the data off the tape if it won't mount. I don't have the SENSE data error message, though. So, how do I get data off this volume if it won't mount in ITSM? 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 MMS health-first.org made the following annotations on 04/22/02 12:11:53 -- 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: sense errors
Also check micro code levels on the tape drives. Have them brought up to the latest level. Check compatibility between the microcode levels on the drive and the O/S fileset level. You will have to contact the manufacturer for this. You may need to update the fileset. Also make sure that TSM is compatible with the current micro-code level. You may need to upgrade TSM. Good luck Jan -Original Message- From: George Lesho [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:29 PM To: [EMAIL PROTECTED] Subject: Re: sense errors This sense code indicates a medium error where the format was corrupted. This error is usually associated with a TSM volume where someone did other than TSM recordings (dd, Veritas, tar, etc) George Lesho System/Storage Admin AFC Enterprises Johnn D. Tan [EMAIL PROTECTED]To: [EMAIL PROTECTED] L.EDU cc: (bcc: George Lesho/Partners/AFC) Sent by: ADSM: Subject: sense errors Dist Stor Manager [EMAIL PROTECTED] .EDU 04/18/02 03:31 PM Please respond to ADSM: Dist Stor Manager Does anyone have any ideas on the following errors that showed up in our TSM activity log? We have TSM 4.1.3 server running on AIX 4.3.3ML9, connected to a SpectraLogic HVD 64000/Gator (with Sony SDX-500C drives). We've sent the sense code info to Tivoli as well as SpectraLogic, but they point at each other or general SCSI problems. We've already swapped out the cables, the terminators, even one of the SCSI cards. We've cleaned the drives, changed the filters, re-connected the cables, etc. Even though all of the below are on DRIVE1, it actually happens to all six of our drives eventually. I checked the TSM Messages manual, and it's not that helpful. * I'm writing not so much to get a definitive answer (as that's obviously something specific to our site setup), but more for other clues or leads that I could investigate. Maybe Tivoli, SpectraLogic, and our own group have all been looking in the wrong direction. * By the way, we get these on a more-or-less regular basis, like one set of three (such as below) per week or every other week. Thanks for any leads. johnn 04/18/02 07:43:55 ANR8302E I/O error on drive DRIVE1 (/dev/mt0) (OP=READ, CC=306, KEY=03, ASC=31, ASCQ=00, SENSE=F0.00.03.00.00.80.00.14.00.00.00.00.31.00.00.00.CE- .00.00.00.00.B8.01.4D.20.50., Description=Drive or media failure). Refer to Appendix B in the 'Messages' manual for recommended action. 04/18/02 07:56:40 ANR8302E I/O error on drive DRIVE1 (/dev/mt0) (OP=READ, CC=306, KEY=03, ASC=31, ASCQ=00, SENSE=F0.00.03.00.00.80.00.14.00.00.00.00.31.00.00.00.CE- .00.00.00.00.EC.01.4C.60.70., Description=Drive or media failure). Refer to Appendix B in the 'Messages' manual for recommended action. 04/18/02 08:06:17 ANR8302E I/O error on drive DRIVE1 (/dev/mt0) (OP=READ, CC=306, KEY=03, ASC=31, ASCQ=00, SENSE=F0.00.03.00.00.80.00.14.00.00.00.00.31.00.00.00.CE- .00.00.00.01.24.01.46.68.00., Description=Drive or media failure). Refer to Appendix B in the 'Messages' manual for recommended action. ** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action or reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer. **
ANR0102E + ANR2032E -- Internal server error
Hi TSM'ers, Environment: TSM-server 4.2.1.8 on AIX 4.3.3, TSM-dsmadmc-client 4.1.1.0 TSM-user: WINNT OS Level: 4.00 OLD TSM-client: 3.1.0.8 on WINNT NEW TSM-client: 5.1.0.0 on WINNT Problem: 1. a WINNT-user having had successfully running a v4-client downloaded the latest 5.1.0.0 client via ftp://ftp.rz.uni-karlsruhe.de/pub/tsm/mirror/maintenance/client/v5r1/Windows/WinNT/v510 2. After installation/upgradeing he received ( in the dsmerror.log of the v5.1.0.0-client ): ... 22.04.2002 14:10:22 GetHostnameOrNumber(): gethostbyname(): errno = 11001. 22.04.2002 14:10:22 TcpOpen: Could not resolve host name. 22.04.2002 14:10:22 sessOpen: Failure in communications open call. rc: -53 22.04.2002 14:10:22 Ungültiger TCP/IP-Host-Name ... 3. Given some V5-client mysteries causing the 4.2.1.8 TSM-server on AIX 4.3.3 to misbehave ( as shown in 2. ), I did: dsmadmc ren node oblong oblong_old followed by dsmadmc register node oblong ?? passexp=0 compress=yes and received: 22.04.2002 15:09:58 ANR2017I Administrator C0034003 issued command: REGISTER NODE oblong ?***? passexp=0 compress=yes 22.04.2002 15:09:58 ANR0102E admnode.c(9789): Error 1 inserting row in table Extended.Attrs. 22.04.2002 15:09:58 ANR2032E REGISTER NODE: Command failed - internal server error detected. Any idea TSM'ers / TSM-team ? 4. Doing a dsmadmc reg node oblongx ?***? passexp=0 xompress=y works OK, i.e. the rename of the nodename from oblong to oblong_old did NOT cleanup sufficiently to make a reregistering of the original node oblong working. 5. In the worst case I would be able to do the following: dsmadmc del filesp oblong * dsmadmc rem node oblong dsmadmc reg node oblong but wouldn't like to do so. -- MfG / Ciao - - - - - - - - - - - - - - - - - - - - - - - - - - - - Peter Dümpert Email: [EMAIL PROTECTED] Rechenzentrum der Technischen Universität Fax : ++49/531/391-5549 D 38092 BraunschweigTel : ++49/531/391-5535
[no subject]
Hello *SMers. What is the best way to achieve the following I have 6 servers, each one of then must be backed up incrementally on a daily, weakly, monthly and yearly basis. I thought about configuring 4 nodes for each box on the dsm.sys file, lets say: NODE1DAILY NODE1WEEKLY NODE1MONTHLY NODE1YEARLY And also start 4 dsmc sched processes, so they can backup on the way i want. Is it correct or is another way to do this? Thanks in advance. = Do or Do Not, there is no try -Yoda. The Empire Strikes Back ___ Do You Yahoo!? Yahoo! Messenger Comunicacisn instantanea gratis con tu gente. http://messenger.yahoo.es
Re: ADSM 3.1 - really need some assistance
Stuart, Not to pick on you (not to mention that this could be a fairly complex issue), but did you do a help anr0207e on your ADSM server? It indicates to look for other error messages. Look in your actlog for other errors, both at the same timestamp and on the same database volume - F: \ADSM_SERVER\DB\DB5.DSM. Let us know what other errors you're getting, and we may be able to help more. I won't make any guesses from this point, but I do have a feeling of what may have happened. The ADSM/TSM online help is often actually, well, helpful. I'm amazed at how many questions from people I can answer just by looking at the help and following what it says to do. And I'm amazed at how people think I'm so smart when I can find the answers so quickly. Sometimes interpreting what the help screen says takes some doing, but quite often it's pretty plain and simple. Nick Cassimatis [EMAIL PROTECTED] Today is the tomorrow of yesterday.
[no subject]
Dear Mr Eduardo. TSM isn't build to backup with this system that is Grandpa,Father,Son system. I would never recommend this kind of configuration. You should configure your system so that you can cover the whole time Spam you need. You will reduce tremendous cost in tapes with that kind of configuration. When you think of TSM you need to think outside of other backup systems you know. because TSM doesn't handle tape expiration like the other systems. TSM expire on file-level (the way it should be). using tape expiration on TSM is a brutal rape on TSM. I recommend you to use only one opt file and, be sure you can cover the whole time you need in your expire configuration. If you think that will be to much data, consider to binding only the important data to the include/exclude option with client option set with multiple management classes. 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 Eduardo Martinez Sent: 22. apríl 2002 17:42 To: [EMAIL PROTECTED] Subject: Hello *SMers. What is the best way to achieve the following I have 6 servers, each one of then must be backed up incrementally on a daily, weakly, monthly and yearly basis. I thought about configuring 4 nodes for each box on the dsm.sys file, lets say: NODE1DAILY NODE1WEEKLY NODE1MONTHLY NODE1YEARLY And also start 4 dsmc sched processes, so they can backup on the way i want. Is it correct or is another way to do this? Thanks in advance. = Do or Do Not, there is no try -Yoda. The Empire Strikes Back ___ Do You Yahoo!? Yahoo! Messenger Comunicacisn instantanea gratis con tu gente. http://messenger.yahoo.es
[no subject]
dear mr Eduardo Martinez I forgot that you could only have one drive and if you do then you cant do the thing I was talking about. there where discussion about this earlier today, you could find something there. hope this helps. pete out :) 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 Eduardo Martinez Sent: 22. apríl 2002 17:42 To: [EMAIL PROTECTED] Subject: Hello *SMers. What is the best way to achieve the following I have 6 servers, each one of then must be backed up incrementally on a daily, weakly, monthly and yearly basis. I thought about configuring 4 nodes for each box on the dsm.sys file, lets say: NODE1DAILY NODE1WEEKLY NODE1MONTHLY NODE1YEARLY And also start 4 dsmc sched processes, so they can backup on the way i want. Is it correct or is another way to do this? Thanks in advance. = Do or Do Not, there is no try -Yoda. The Empire Strikes Back ___ Do You Yahoo!? Yahoo! Messenger Comunicacisn instantanea gratis con tu gente. http://messenger.yahoo.es
Installing TDP for SQL 2.2
We are trying to install the TDP for SQL version 2.2 on to a WinNT4 machine running MS-SQL. So far we have the client (version 4.2.1.20) installed to catch all the non SQL files. It's set up to be called by the TSM server to run and it's doing fine. All the non SQL backups are fine. We have the SQL folders set to be excluded. We are now trying to install the SQL part now and it does not want to play nice. We loaded version 2.2.0.0 and we have gotten it working to point where we can do a SQL backup from the command line and from within the GUI. We can't get it run when it's called from the TSM server. The programs are all installed to the default locations and I ran the dsmcutil install command from the baclient folder to create a new scheduler service for the SQL part. I referred it to the dsm file in the tdpsql folder just like the docs said. I've got a schedule on the TSM server set to kick off at a certain time but nothing happens. I've looked at the assorted log files nothing shows up. If I run tdpsqlc backup * full it runs just fine. Am I missing something here? Do I need to call the sqlfull.cmd from one of the dsm.opt files? David Tyree Microcomputer Specialist South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Re: Installing TDP for SQL 2.2
We are trying to install the TDP for SQL version 2.2 on to a WinNT4 machine running MS-SQL. So far we have the client (version 4.2.1.20) installed to catch all the non SQL files. It's set up to be called by the TSM server to run and it's doing fine. All the non SQL backups are fine. We have the SQL folders set to be excluded. We are now trying to install the SQL part now and it does not want to play nice. We loaded version 2.2.0.0 and we have gotten it working to point where we can do a SQL backup from the command line and from within the GUI. We can't get it run when it's called from the TSM server. The programs are all installed to the default locations and I ran the dsmcutil install command from the baclient folder to create a new scheduler service for the SQL part. I referred it to the dsm file in the tdpsql folder just like the docs said. I've got a schedule on the TSM server set to kick off at a certain time but nothing happens. I've looked at the assorted log files nothing shows up. If I run tdpsqlc backup * full it runs just fine. Am I missing something here? Do I need to call the sqlfull.cmd from one of the dsm.opt files? Do the dsm.opt files for the two scheduler services specify different node names? As far as I know, that is the only way to have one TSM server send interleaved requests to two scheduler services on the same client system. Does the schedule definition specify 'action=command', and specify the full path to the tdpsqlc command in the 'object' parameter? Is the sqldsmc.exe file somewhere under the 'Program Files' directory? If so, the schedule definition will need double quotes around the path to get Windows to treat the embedded space in 'Program Files' correctly. If the schedule is defined from an administrative command line session, the 'define' command will need double quotes within single quotes. The single quotes will get the TSM server to accept the embedded blanks and double quotes as part of the command, and the double quotes will get Windows to accept the embedded blank in the path.
Re: Installing TDP for SQL 2.2
David, Make sure that script name in the schedule is identical to the name of the script on the NT box. Check the .extension of the script. Bill - Original Message - From: Tyree, David [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 1:58 PM Subject: Installing TDP for SQL 2.2 We are trying to install the TDP for SQL version 2.2 on to a WinNT4 machine running MS-SQL. So far we have the client (version 4.2.1.20) installed to catch all the non SQL files. It's set up to be called by the TSM server to run and it's doing fine. All the non SQL backups are fine. We have the SQL folders set to be excluded. We are now trying to install the SQL part now and it does not want to play nice. We loaded version 2.2.0.0 and we have gotten it working to point where we can do a SQL backup from the command line and from within the GUI. We can't get it run when it's called from the TSM server. The programs are all installed to the default locations and I ran the dsmcutil install command from the baclient folder to create a new scheduler service for the SQL part. I referred it to the dsm file in the tdpsql folder just like the docs said. I've got a schedule on the TSM server set to kick off at a certain time but nothing happens. I've looked at the assorted log files nothing shows up. If I run tdpsqlc backup * full it runs just fine. Am I missing something here? Do I need to call the sqlfull.cmd from one of the dsm.opt files? David Tyree Microcomputer Specialist South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Re: Single Drive Manual Library
Yep... it's possible to arrange a single-drive environment; it's highly dependent on the onsite person doing tape mounts on request, and organizing the tape pool to satisfy your retention requirements -- if you're lucky, get sufficient disk pool storage to allow either single-drive reclamation or copy-pool support. I've had two different situations, we resolved them as follows: 1. Manual single-drive -- a file server with Exchange server; we configured it for Incremental forever (the file server node), daily incremental with weekly full for the Exchange; we installed admin client on the desktops of 2 or 3 onsite supervisors, so they would watch for tape mounts, and react accordingly. We used server-to-server across a WAN for the database backups; again, daily incremental, weekly full (on the weekend, when traffic was low). This is probably the worst scenario for trying to use TSM -- but, that's what we did; it was running for about a year when I left the account -- turned it over to centralized backup personnel, who continue the operation. This was a test to see how good or bad it would be to manage remotely; it was okay, but one must always take initiative to monitor the onsite folks performing tape mounts. Rather than try to do reclamation, we did once-a-month Full backups (by changing the policyset to absolute for one cycle), which would cause older tapes to (ultimately) go to Empty, since retention of Exchange was one-month, files was 30-45 days... poor man's trick reclamation. Since this was a DLT, we minimized tape thrashing by running both daily backups in close succession, using same media for all the data... used one tape per week, accumulating approx. 15 tapes total, as they recycled. Refreshed all new tapes once per year. Another reason this is not quite as cool as we'd like is it lacks copy-pool protection against media failure -- for case of a large restore request (as in a disk drive failure). I think, more likely, a simpler approach, would be better -- weekly-fulls might be better than the monthly-absolute -- in case of media failure, you'd still have another copy of all but the most recent week's data). 2. Single-drive library with 6 or 7 slots -- installed sufficient disk pool to handle single-drive reclamation, as per Admin. Guide; works fine, allowed 14-day PIT supporting one tape drive's worth of file-served data (approx. 65 GB in this case); that, plus diskpool used for storing primary copy (never migrated), tape slots used for two copy pools (one kept onsite, the other sent offsite) plus db backups. 14-days of PIT translates to approx. 1.7 x file-server-capacity (using 5% per day data change/add/delete, rule-of-thumb). This is the minimal, workable configuration for TSM (imho); minimum recommended configuration would be TWO tape drive library with sufficient slots to hold all backup data for desired number of versions, plus some slots for db backups daily copy pool tapes... can I do daily incremental db-backups to a single output tape (appending each day's data)?!? Never did reclamation -- all unexpired backup data kept in disk pool, never migrated... eventually, MOVE DATA could be used to vacate disk pool to allow for single drive reclamation of the onsite copy pool. Hope all this helps! Regards, Don - Original Message - From: Etienne Brodeur [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 7:28 AM Subject: Re: Single Drive Manual Library I HAD a client like your describe, small sites (less than 40 GB total storage) withan LTO 3580 tape drive. The problem is that you have to do reclamation on the disks (since you only have one tape drive), now with an LTO tape (100 to 200 GB depending of compression) that's a lot os space to leave empty on the server. So my client decided to NOT use reclamation. He routinely deleted the volumes manually to be able to reuse them. To make sure that he had a full copy of his files I configured a selective backup that took everything on his machines once per week. I had to setup TSM to work like the good old days of four incremental and then a full backup. As for the DB backups, he had to change the tape in his drive (doing a dismount vol _volname_ first) manually before the schedule DB backup at 10:00 AM (he didn't want to have to type the commands himself). Then he loads the tapes for tonight checking to make sure there is enough space on it. If there isn't enough space then he does a delete volume _volname_ discarddata=yes. In other words it's pretty horrible. We added an old tape drive he had lying around and use that for the DB backups which helped a little. I guest if you have reclamation it would help a lot, but you still have to manipulate the tapes a lot and check for free space on them before using them. I have setup sites in collocation with small library 5-8 slots and one drive and that works well as long as you have
Re: Piping a file to dsmc
You need adsmpipe. Look in ftp://www.redbooks.ibm.com/redbooks/SG244335/ Unsupported but works. _ William Mansfield Senior Consultant Solution Technology, Inc Behdashti, Farshid [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 04/22/2002 09:27 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Piping a file to dsmc Hello, We are using ADSM in the following environment: ADSM server Version 3, Release 7, Level 0.0 runs on Sun E6500 Solaris 5.7. IBM tape library is 3494(robot) with 3590-B1A drives. DSM client Version 3, Release 7, Level 2.0 runs on many other Sun E1 servers without any tape drives. I need to do a full database reorganization on a database of about 450GB. The export file(s) will be around 150GB which cannot be stored on disk. I need to run the export and pipe or redirect the output to tape. Is there a way to pipe a file to dsmc for backup - something like cat /etc/hosts | dsmc to backup contents of /etc/hosts ? Thanks, Farshid Behdashti
Re: Can TSM API be used alone without ba client?
Yes, during the installation, select only the API component. -- Joshua S. Bassi Sr. Solutions Architect @ rs-unix.com IBM Certified - AIX/HACMP, SAN, Shark Tivoli Certified Consultant- ADSM/TSM Cell (415) 215-0326 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Fred Zhang Sent: Friday, April 19, 2002 11:07 AM To: [EMAIL PROTECTED] Subject: Can TSM API be used alone without ba client? Hi all, I am new to TSM. Can I use the TSM API in a machine without BA client installed? Thanks = Fred Zhang NetiQ Corporation 3553 N. First St. San Jose, CA 95134 phone: (408)856-3102 fax: (408)856-3102 e-mail: [EMAIL PROTECTED] =
Re: ADSM 3.1 - really need some assistance
Nick Thanks for the response. I have used the 'help' option fairly frequently just recently it seems! It does not, however, indicate any possible solution to correct the page error and there are no other messages or errors relating to the volume in question. I thought that there must be some way of 'fixing' the erroneous copy from the good copy. The database is reported as being 'in sync'. I am stumped right now. Stu -Original Message- From: Nicholas Cassimatis [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 1:39 PM To: [EMAIL PROTECTED] Subject: Re: ADSM 3.1 - really need some assistance Stuart, Not to pick on you (not to mention that this could be a fairly complex issue), but did you do a help anr0207e on your ADSM server? It indicates to look for other error messages. Look in your actlog for other errors, both at the same timestamp and on the same database volume - F: \ADSM_SERVER\DB\DB5.DSM. Let us know what other errors you're getting, and we may be able to help more. I won't make any guesses from this point, but I do have a feeling of what may have happened. The ADSM/TSM online help is often actually, well, helpful. I'm amazed at how many questions from people I can answer just by looking at the help and following what it says to do. And I'm amazed at how people think I'm so smart when I can find the answers so quickly. Sometimes interpreting what the help screen says takes some doing, but quite often it's pretty plain and simple. Nick Cassimatis [EMAIL PROTECTED] Today is the tomorrow of yesterday.
Re: Installing TDP for SQL 2.2
David, What do the parameters of your schedule look like on the TSM server?? Matt Adams Tivoli Storage Manager Team Hermitage Site Tech Deloitte Touche USA LLP 615.882.6861 -Original Message- From: Tyree, David [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: Installing TDP for SQL 2.2 We are trying to install the TDP for SQL version 2.2 on to a WinNT4 machine running MS-SQL. So far we have the client (version 4.2.1.20) installed to catch all the non SQL files. It's set up to be called by the TSM server to run and it's doing fine. All the non SQL backups are fine. We have the SQL folders set to be excluded. We are now trying to install the SQL part now and it does not want to play nice. We loaded version 2.2.0.0 and we have gotten it working to point where we can do a SQL backup from the command line and from within the GUI. We can't get it run when it's called from the TSM server. The programs are all installed to the default locations and I ran the dsmcutil install command from the baclient folder to create a new scheduler service for the SQL part. I referred it to the dsm file in the tdpsql folder just like the docs said. I've got a schedule on the TSM server set to kick off at a certain time but nothing happens. I've looked at the assorted log files nothing shows up. If I run tdpsqlc backup * full it runs just fine. Am I missing something here? Do I need to call the sqlfull.cmd from one of the dsm.opt files? David Tyree Microcomputer Specialist South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. - This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. - If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.
Re: ADSM 3.1 - really need some assistance
The one fix I can think of would be to delete the dbvol giving errors, then recreate it. Hard to explain, but if you send a q dbv f=d to the list, I can sort it out from that (or someone else may see a different fix). Nick Cassimatis [EMAIL PROTECTED] Today is the tomorrow of yesterday.
Re: ADSM 3.1 - really need some assistance
Volume Name (Copy 1): F:\ADSM_SERVER\DB\DB5.DSM Copy Status: Sync'd Volume Name (Copy 2): E:\ADSM_SERVER\DB\DB5COPY.DSM Copy Status: Sync'd Volume Name (Copy 3): Copy Status: Undefined Available Space (MB): 30,000 Allocated Space (MB): 30,000 Free Space (MB): 0 Simple, but hope it helps. Stu -Original Message- From: Nicholas Cassimatis [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:23 PM To: [EMAIL PROTECTED] Subject: Re: ADSM 3.1 - really need some assistance The one fix I can think of would be to delete the dbvol giving errors, then recreate it. Hard to explain, but if you send a q dbv f=d to the list, I can sort it out from that (or someone else may see a different fix). Nick Cassimatis [EMAIL PROTECTED] Today is the tomorrow of yesterday.
Re: Installing TDP for SQL 2.2
If I run tdpsqlc backup * full it runs just fine. Am I missing something here? Do I need to call the sqlfull.cmd from one of the dsm.opt files? Yes, set up schedule on TSM server as type command with the full path to sqlfull.cmd in the objects parameter. David Longo [EMAIL PROTECTED] 04/22/02 01:58PM We are trying to install the TDP for SQL version 2.2 on to a WinNT4 machine running MS-SQL. So far we have the client (version 4.2.1.20) installed to catch all the non SQL files. It's set up to be called by the TSM server to run and it's doing fine. All the non SQL backups are fine. We have the SQL folders set to be excluded. We are now trying to install the SQL part now and it does not want to play nice. We loaded version 2.2.0.0 and we have gotten it working to point where we can do a SQL backup from the command line and from within the GUI. We can't get it run when it's called from the TSM server. The programs are all installed to the default locations and I ran the dsmcutil install command from the baclient folder to create a new scheduler service for the SQL part. I referred it to the dsm file in the tdpsql folder just like the docs said. I've got a schedule on the TSM server set to kick off at a certain time but nothing happens. I've looked at the assorted log files nothing shows up. If I run tdpsqlc backup * full it runs just fine. Am I missing something here? Do I need to call the sqlfull.cmd from one of the dsm.opt files? David Tyree Microcomputer Specialist South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. MMS health-first.org made the following annotations on 04/22/02 16:14:46 -- 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. ==
FW: Installing TDP for SQL 2.2
I've got the script name correct in the schedule. I had someone else look at it make sure I hadn't gone blind. I'm watching the console messages go by and I see the messages showing the session starting and then end for the node. I go back to the logs on the client and nothing shows up as being done. All I see is an entry in the dsmerror.log ANS1029E Communications have been dropped at the time the schedule ran. -Original Message- From: Bill Maloney [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:54 PM To: [EMAIL PROTECTED] Subject: Re: Installing TDP for SQL 2.2 David, Make sure that script name in the schedule is identical to the name of the script on the NT box. Check the .extension of the script. Bill - Original Message - From: Tyree, David [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 1:58 PM Subject: Installing TDP for SQL 2.2 We are trying to install the TDP for SQL version 2.2 on to a WinNT4 machine running MS-SQL. So far we have the client (version 4.2.1.20) installed to catch all the non SQL files. It's set up to be called by the TSM server to run and it's doing fine. All the non SQL backups are fine. We have the SQL folders set to be excluded. We are now trying to install the SQL part now and it does not want to play nice. We loaded version 2.2.0.0 and we have gotten it working to point where we can do a SQL backup from the command line and from within the GUI. We can't get it run when it's called from the TSM server. The programs are all installed to the default locations and I ran the dsmcutil install command from the baclient folder to create a new scheduler service for the SQL part. I referred it to the dsm file in the tdpsql folder just like the docs said. I've got a schedule on the TSM server set to kick off at a certain time but nothing happens. I've looked at the assorted log files nothing shows up. If I run tdpsqlc backup * full it runs just fine. Am I missing something here? Do I need to call the sqlfull.cmd from one of the dsm.opt files? David Tyree Microcomputer Specialist South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
FW: Installing TDP for SQL 2.2
Except for some minor changes it's almost exactly what it has in the book on page 199. Def sched current sql_webtrend desc=Webtrend SQL action=command objects=d:\sqlfull.cmd priority=2 starttime=16:00 duration=15 duru=minutes period=1 perunits=day dayofweek=any -Original Message- From: Adams, Matt (US - Hermitage) [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:20 PM To: [EMAIL PROTECTED] Subject: Re: Installing TDP for SQL 2.2 David, What do the parameters of your schedule look like on the TSM server?? Matt Adams Tivoli Storage Manager Team Hermitage Site Tech Deloitte Touche USA LLP 615.882.6861 -Original Message- From: Tyree, David [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: Installing TDP for SQL 2.2 We are trying to install the TDP for SQL version 2.2 on to a WinNT4 machine running MS-SQL. So far we have the client (version 4.2.1.20) installed to catch all the non SQL files. It's set up to be called by the TSM server to run and it's doing fine. All the non SQL backups are fine. We have the SQL folders set to be excluded. We are now trying to install the SQL part now and it does not want to play nice. We loaded version 2.2.0.0 and we have gotten it working to point where we can do a SQL backup from the command line and from within the GUI. We can't get it run when it's called from the TSM server. The programs are all installed to the default locations and I ran the dsmcutil install command from the baclient folder to create a new scheduler service for the SQL part. I referred it to the dsm file in the tdpsql folder just like the docs said. I've got a schedule on the TSM server set to kick off at a certain time but nothing happens. I've looked at the assorted log files nothing shows up. If I run tdpsqlc backup * full it runs just fine. Am I missing something here? Do I need to call the sqlfull.cmd from one of the dsm.opt files? David Tyree Microcomputer Specialist South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. - This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. - If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.
Re: TDP Oracle on AIX 5.1
Luis, Yes, here is the site, it should be accessable from the internet. ftp://service.boulder.ibm.com/storage/tivoli-storage-management/ -- Date:Fri, 19 Apr 2002 19:12:21 + From:Luis Tapia [EMAIL PROTECTED] Subject: Re: TDP Oracle on AIX 5.1 Thanks Neil, yes, it4s AIX 5.1 32bit, which ftp site are you talking about? the one at service.boulder? it4s accesible from the internet? thanks again Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: Installing TDP for SQL 2.2
David, I have the same environment as you are. The TSMclient version 4.1.2.20 has many problems. What I did was, I upgraded mine to 4.1.3.11 It's now working fine. Also install the latest patch for TDP ver 2.2.0.0 , TDPver 2.2.0.1. Here's my sample dsm.opt file. Be sure to specify the correct TCPCLIENTADDRESS (client ip address) and TCPCLIENTPORT(1502 - be sure this is not used by other network) (See attached file: dsm) This is the command that you need to define in your service schedule ( under object). You can try running in the command line. (See attached file: sqlfull) You need this also. Please take note: you may either run using integrated ( NT authentication) or sqluserid ( sql defined id). Either of this need to have a SA privilege in the SQL and NT system admin. (See attached file: tdpsql) Ed Moso From: Adams, Matt (US - Hermitage) [EMAIL PROTECTED] on 04/22/2002 03:20 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Re: Installing TDP for SQL 2.2 David, What do the parameters of your schedule look like on the TSM server?? Matt Adams Tivoli Storage Manager Team Hermitage Site Tech Deloitte Touche USA LLP 615.882.6861 -Original Message- From: Tyree, David [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: Installing TDP for SQL 2.2 We are trying to install the TDP for SQL version 2.2 on to a WinNT4 machine running MS-SQL. So far we have the client (version 4.2.1.20) installed to catch all the non SQL files. It's set up to be called by the TSM server to run and it's doing fine. All the non SQL backups are fine. We have the SQL folders set to be excluded. We are now trying to install the SQL part now and it does not want to play nice. We loaded version 2.2.0.0 and we have gotten it working to point where we can do a SQL backup from the command line and from within the GUI. We can't get it run when it's called from the TSM server. The programs are all installed to the default locations and I ran the dsmcutil install command from the baclient folder to create a new scheduler service for the SQL part. I referred it to the dsm file in the tdpsql folder just like the docs said. I've got a schedule on the TSM server set to kick off at a certain time but nothing happens. I've looked at the assorted log files nothing shows up. If I run tdpsqlc backup * full it runs just fine. Am I missing something here? Do I need to call the sqlfull.cmd from one of the dsm.opt files? David Tyree Microcomputer Specialist South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. - This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. - If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. dsm Description: Binary data sqlfull Description: Binary data tdpsql Description: Binary data
Consolidating TSM servers.
HiAnybody out there know if it's possible to do a export server, without having to export all filedata, and then do a import and use the existing tapes.We have one STK 9310 and one IBM 3494. Each TSM server has a copypool and a primary tape pool in the different libraries. All equipment is SAN connected, so if I could first do a DB backup/restore to the new machine of one of the TSM servers, and then export everything except for the file data from the second TSM server to the new machine, it would be perfect.Doing a export server filedata=all, would create about1500 new tapes, according to a export server preview=yes (about 31TB of data) and this would probbaly not work at all.So, anybody done this before?Best RegardsDaniel Sparrman---DanielSparrmanExistiStockholmABPropellervägen6B18362HÄGERNÄSVäxel:08-7549800Mobil:070-3992751
Re: Installing TDP for SQL 2.2
FYI... The latest PTF available for TDP for SQL is 2.2.1. You can get it here: ftp://ftp.software.ibm.com/storage/tivoli-storage-management/maintenance/tivoli-data-protection/ntsql/v221/ Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] - Leave everything a little better than you found it. - Smile a lot: it costs nothing and is beyond price.
Re: Installing TDP for SQL 2.2
While I've been fighting this, I downloaded the 2.2.0.1 version of SQL. I'll update the client tomorrow. I'll get the newer client and do the same with it. Thanks for the files, I'll look them over and see how they are different from what I've been trying to do. -Original Message- From: Edgardo Moso [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 4:25 PM To: [EMAIL PROTECTED] Subject: Re: Installing TDP for SQL 2.2 David, I have the same environment as you are. The TSMclient version 4.1.2.20 has many problems. What I did was, I upgraded mine to 4.1.3.11 It's now working fine. Also install the latest patch for TDP ver 2.2.0.0 , TDPver 2.2.0.1. Here's my sample dsm.opt file. Be sure to specify the correct TCPCLIENTADDRESS (client ip address) and TCPCLIENTPORT(1502 - be sure this is not used by other network) (See attached file: dsm.opt) This is the command that you need to define in your service schedule ( under object). You can try running in the command line. (See attached file: sqlfull.cmd) You need this also. Please take note: you may either run using integrated ( NT authentication) or sqluserid ( sql defined id). Either of this need to have a SA privilege in the SQL and NT system admin. (See attached file: tdpsql.cfg) Ed Moso From: Adams, Matt (US - Hermitage) [EMAIL PROTECTED] on 04/22/2002 03:20 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Re: Installing TDP for SQL 2.2 David, What do the parameters of your schedule look like on the TSM server?? Matt Adams Tivoli Storage Manager Team Hermitage Site Tech Deloitte Touche USA LLP 615.882.6861 -Original Message- From: Tyree, David [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: Installing TDP for SQL 2.2 We are trying to install the TDP for SQL version 2.2 on to a WinNT4 machine running MS-SQL. So far we have the client (version 4.2.1.20) installed to catch all the non SQL files. It's set up to be called by the TSM server to run and it's doing fine. All the non SQL backups are fine. We have the SQL folders set to be excluded. We are now trying to install the SQL part now and it does not want to play nice. We loaded version 2.2.0.0 and we have gotten it working to point where we can do a SQL backup from the command line and from within the GUI. We can't get it run when it's called from the TSM server. The programs are all installed to the default locations and I ran the dsmcutil install command from the baclient folder to create a new scheduler service for the SQL part. I referred it to the dsm file in the tdpsql folder just like the docs said. I've got a schedule on the TSM server set to kick off at a certain time but nothing happens. I've looked at the assorted log files nothing shows up. If I run tdpsqlc backup * full it runs just fine. Am I missing something here? Do I need to call the sqlfull.cmd from one of the dsm.opt files? David Tyree Microcomputer Specialist South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. - This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. - If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.
Re: What to do with a volume that won't ITSM mount in a 3570library?
Here is the SENSE data from the actlog when I try to do an audit volume fix=yes: 04/22/02 15:36:06 ANR8302E I/O error on drive DRIVE2 (/dev/rmt2) (OP=READ, Error Number=110, CC=0, KEY=03, ASC=11, ASCQ=00, SENSE=F0.00.03.00.00.00.50.58.00.00.00.00.11.00.FE.0A.3- 6.3F.10.00.00.03.01.91.00.45.30.51.E5.8D.08.00.05.33.35- .00.80.33.35.40.88.33.3D.9E.0E.00.00.00.00.03.00.00.02.- 00.00.00.00.00.00.00.00.00.00.00.00.00.00.02.80.15.20.0- 0.34.36.36.20.20.20.20.00.C0.00.47.31.30.46.37.31.34.00- .00.00.00.00.00.00, Description=An undetermined error has occurred). Refer to Appendix D in the 'Messages' manual for recommended action. 04/22/02 15:36:06 ANR8355E I/O error reading label for volume 10F714 in drive DRIVE2 (/dev/rmt2). I went into the 3570 Magstar maintenance manual and this decodes into: error number = 110, unrecoverable media read error key =03, medium error ASC/ASCQ = 11 00, unrecoverable read error I guess this means its a bad tape! 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 David Longo David.Longo@HEALTH- To: [EMAIL PROTECTED] FIRST.ORG cc: Sent by: ADSM: Dist Subject: Re: What to do with a volume that won't ITSM mount in a Stor Manager 3570library? [EMAIL PROTECTED] U 04/22/2002 11:57 AM Please respond to ADSM: Dist Stor Manager Look at the actlog at the time operation is attempted and see what error message is and tell us. If it is something like: ANR8779E Unable to open drive /dev/rmt4, error number=46 then most likely tape is broken. Manually inspect tape - open access door on tape and see if tape is damaged there. I've had many cases of broken 3570 tapes, this is the error you get attempting to mount a broken tape. I've seen a couple of times where this error means something else, but most of the time - broke! David Longo [EMAIL PROTECTED] 04/22/02 11:36AM ITSM'ers: Enviro: AIX 4.3.3.04 H70 TSM 4.2.1.10 server MP Magstar 3570-C12 library I have 1 tape that won't mount in the 3570 via ITSM. There is still data on it and I can't figure out how to get the data off the tape if it won't mount. I don't have the SENSE data error message, though. So, how do I get data off this volume if it won't mount in ITSM? 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 MMS health-first.org made the following annotations on 04/22/02 12:11:53 -- 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. ==
a client could not backup?
There is a problem with one of our client. we have reinstalled the client and we could not find the problem. The following is the shedule error log in the client: 04/22/2002 14:58:37 TransWin32RC(): Win32 RC 123 from fioScanDirEntry(): getFileSecuritySize 04/22/2002 14:59:11 TransWin32RC(): Win32 RC 123 from fioScanDirEntry(): getFileSecuritySize 04/22/2002 16:51:03 ntConsoleEventHandler(): Caught Logoff console event . 04/22/2002 16:51:03 ntConsoleEventHandler(): Process Detached. 04/23/2002 03:25:31 TcpRead: Zero byte buffer read. 04/23/2002 03:25:31 sessRecvVerb: Error -50 from call to 'readRtn'. 04/23/2002 03:25:31 ANS1017E Session rejected: TCP/IP connection failure 04/23/2002 03:25:31 ANS1017E Session rejected: TCP/IP connection failure 04/23/2002 09:06:32 TcpRead: Zero byte buffer read. 04/23/2002 09:06:32 sessRecvVerb: Error -50 from call to 'readRtn'. 04/23/2002 09:06:32 ANS1017E Session rejected: TCP/IP connection failure 04/23/2002 09:06:32 ANS1017E Session rejected: TCP/IP connection failure 04/23/2002 09:46:47 TcpRead: Zero byte buffer read. 04/23/2002 09:46:47 sessRecvVerb: Error -50 from call to 'readRtn'. 04/23/2002 09:46:47 ANS1017E Session rejected: TCP/IP connection failure 04/23/2002 09:46:47 ANS1017E Session rejected: TCP/IP connection failure 04/23/2002 09:46:48 ANS1512E Scheduled event 'BACKUP' failed. Return code = 1. 04/23/2002 09:46:48 cuSignOnResp: Server rejected session; result code: 55 04/23/2002 09:46:48 sessOpen: Error 55 receiving SignOnResp verb from server 04/23/2002 09:46:53 ntConsoleEventHandler(): Caught Logoff console event . 04/23/2002 09:46:53 ntConsoleEventHandler(): Process Detached. This client has been retried to backup many times until I cancel the session on server. Any comments will be appreciated Thanks in advance Julie Xu Unix/Network Administrator Information Technology Directorate University of Westen Sydney, Campbelltown Campbelltown NSW 2560 Phone: 61 02 4620-3098 Mobile: 0416 179 868 Email: [EMAIL PROTECTED]
Re: Consolidating TSM servers.
= On Mon, 22 Apr 2002 21:59:45 +0200, Daniel Sparrman [EMAIL PROTECTED] said: From: Daniel Sparrman [EMAIL PROTECTED] Subject: Consolidating TSM servers. To: [EMAIL PROTECTED] PEZPTlQgZmFjZT0iRGVmYXVsdCBTYW5zIFNlcmlmLCBWZXJkYW5hLCBBcmlhbCwgSGVsdmV0aWNh LCBzYW5zLXNlcmlmIiBzaXplPTI+PERJVj5IaTwvRElWPjxESVY+Jm5ic3A7PC9ESVY+PERJVj5B bnlib2R5IG91dCB0aGVyZSBrbm93IGlmIGl0J3MgcG9zc2libGUgdG8gZG8gYSBleHBvcnQgc2Vy dmVyLCB3aXRob3V0IGhhdmluZyB0byBleHBvcnQgYWxsIGZpbGVkYXRhLCBhbmQgdGhlbiBkbyBh IGltcG9ydCBhbmQgdXNlIHRoZSBleGlzdGluZyB0YXBlcy48L0RJVj48RElWPiZuYnNwOzwvRElW PjxESVY+V2UgaGF2ZSBvbmUgU1RLIDkzMTAgYW5kIG9uZSBJQk0gMzQ5NC4gRWFjaCBUU00gc2Vy dmVyIGhhcyBhIGNvcHlwb29sIGFuZCBhIHByaW1hcnkgdGFwZSBwb29sIGluIHRoZSBkaWZmZXJl bnQgbGlicmFyaWVzLiBBbGwgZXF1aXBtZW50IGlzIFNBTiBjb25uZWN0ZWQsIHNvIGlmIEkgY291 bGQgZmlyc3QgZG8gYSBEQiBiYWNrdXAvcmVzdG9yZSB0byB0aGUgbmV3IG1hY2hpbmUgb2Ygb25l IG9mIHRoZSBUU00gc2VydmVycywgYW5kIHRoZW4gZXhwb3J0IGV2ZXJ5dGhpbmcgZXhjZXB0IGZv ciB0aGUgZmlsZSBkYXRhIGZyb20gdGhlIHNlY29uZCBUU00gc2VydmVyIHRvIHRoZSBuZXcgbWFj aGluZSwgaXQgd291bGQgYmUgcGVyZmVjdC48L0RJVj48RElWPiZuYnNwOzwvRElWPjxESVY+RG9p bmcgYSBleHBvcnQgc2VydmVyIGZpbGVkYXRhPWFsbCwgd291bGQgY3JlYXRlIGFib3V0Jm5ic3A7 MTUwMCBuZXcgdGFwZXMsIGFjY29yZGluZyB0byBhIGV4cG9ydCBzZXJ2ZXIgcHJldmlldz15ZXMg KGFib3V0IDMxVEIgb2YgZGF0YSkgYW5kIHRoaXMgd291bGQgcHJvYmJhbHkgbm90IHdvcmsgYXQg YWxsLjwvRElWPjxESVY+PEJSPlNvLCBhbnlib2R5IGRvbmUgdGhpcyBiZWZvcmU/PC9ESVY+PERJ Vj4mbmJzcDs8L0RJVj48RElWPkJlc3QgUmVnYXJkczwvRElWPjxESVY+Jm5ic3A7PC9ESVY+PERJ Vj5EYW5pZWwgU3BhcnJtYW48L0RJVj48QlI+PERJVj4tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLTxCUj5EYW5pZWwmbmJzcDtTcGFycm1hbjxCUj5FeGlzdCZuYnNwO2kmbmJzcDtT dG9ja2hvbG0mbmJzcDtBQjxCUj5Qcm9wZWxsZXJ25GdlbiZuYnNwOzZCPEJSPjE4MyZuYnNwOzYy Jm5ic3A7SMRHRVJOxFM8QlI+VuR4ZWw6Jm5ic3A7MDgmbmJzcDstJm5ic3A7NzU0Jm5ic3A7OTgm bmJzcDswMDxCUj5Nb2JpbDombmJzcDswNzAmbmJzcDstJm5ic3A7Mzk5Jm5ic3A7MjcmbmJzcDs1 MTxCUj48L0RJVj48L0ZPTlQ+ ... You might want to consider changing your email client's settings... - Allen S. Rout