Re: TSM Scheduler on WinNT and Win2K
Someone on this list noted that this problem seems to occur on multi-processor systems. I use the restart recover action to avoid the problem. On Thu, 19 Sep 2002, Martinez, Matt wrote: Hi all, The TSM Scheduler Service on most of my Win2k and NT4.0 boxes will not start up after a reboot. When I go in and start the service manually it starts up fine. I can't seem to find any errors in the Event Log. Any help you can provide will be appreciated. Thanks, Matt
(Silly?) DB2 Backup question
Hi guys and girls, this question is one of the general sort, so forgive me if it has been answered here or in some manual I haven't red yet. Probably, I just need a simpler description. AFAIK, there are three ways to backup a database: 1. Offline filesystem backup 2. Offline backup in the databases quiesced mode via some api 3. Online backup via api The first question I have is about the transaction log archiving. With which of the above does it make sense and why? The second one: does it make sense to run offline AND online backups in a backup cylce, or will one of them be save enough? I read through the TSM Redbook on DB2 UDB implementation. It just explains the ways RDBMS backups can be done not which combinations are useful. As far as I could extract, it is rather useless doing offline backups and log file archiving but no online backups, right?? Thanks in advance Lars
Re: Select for Scratches
Hi Bill, the device class is needed since the output is parsed by an awk script for further processing. Still, you pointed me into the right direction since I remembered we were creating a second device class on the same librarey for testing the other day. So the select shows scratch tapes for both these device classes. I removed the devclass and it works perfectly. Thanks a lot Paul, the device class does not come in here, so this select works w/o problems. Thanks for the fast reply Lars On 19.09.2002 19:33:16 ADSM: Dist Stor Manager wrote: I run something similar every day. I have 1 devclass per library and the command works fine without duplicating the count of scratch tapes. Do you have multiple device classes in the same library? My scratch are not assigned to a specific device class they are scratch for the entire library. If you don't require the deviceclass in the output you could simplify: select library_name, count(*) as volumes from libvolumes where upper(status) like 'SCRATCH%' and library_name='$i' group by library_name You could also improve the scratch query by changing upper(status) like 'SCRATCH%' to status='Scratch' I hope this helps. Bill -Original Message- From: Lars Bebensee [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 5:35 AM To: [EMAIL PROTECTED] Subject: Select for Scratches Hi folks, I am not that good with select queries yes, so I will have to ask one of the SQL gurus here: we wanted to show how many scratch tapes each library has with a query like this: select a.library_name,count(*) as volumes, b.devtype from libvolumes as a, devclasses as b where upper(status) like 'SCRATCH%' and a.library_name ='$i' and a.library_name=b.library_name group by a.library_name,b.devtype $i will be filled with the name of the library before. The funny thing, it shows exactly as twice as many scratches. Is there someone amongst you who can exctract this little monster for me and show me what I am doing wrong. Thanks for helping out Lars
Netware and 4gb of ram
We've just upgraded two of our netware 5.1 boxes (latest service packs) to 4gb of ram to test the improvement in caching. Problem is the last two night since it was upgraded they have failed with memory errors while doing the backup, the memory was swapped out both times for new tested memory and then failed the next night. I justw anted to see if anyone else was using 4gb ram on their netware boxes or if you've heard of found any problems with this. Thanks in advance ..Rikk Equitas Limited, 33 St Mary Axe, London EC3A 8LL, UK NOTICE: This message is intended only for use by the named addressee and may contain privileged and/or confidential information. If you are not the named addressee you should not disseminate, copy or take any action in reliance on it. If you have received this message in error please notify [EMAIL PROTECTED] and delete the message and any attachments accompanying it immediately. Equitas reserve the right to monitor and/or record emails, (including the contents thereof) sent and received via its network for any lawful business purpose to the extent permitted by applicable law Registered in England: Registered no. 3173352 Registered address above
RV: Scheduler Managed
Hello We are running TSM 4.2.2.0 on an OS/390. Recently I moved in some TSM clients the Client Scheduler from not managed to managed and when I started a new incremental backup the whole system has been backed up again. Does anyone has got the same experience? Angel Antsn IZFE. S.A. Plaza de Pinares, 1-3 Donostia 20001 Tlf.: +34 943.482.869/811 , Fax: +34 943.321.023 E-Mail : [EMAIL PROTECTED]
TSM Retrieve ends with no action
We are having a problem with retrieving a file from TSM archive. Basically, the retrieve command is issued and we are simply returned to the TSM prompt, eg tsm retrieve /prod1/archive.tar /prod1/recovery/ tsm There are no error messages on TSM client or TSM server, nothing aborts etc. There are no OS messages in any log. Server is HP-UX 11.0 TSM 4.2.2.10 and client is HP-UX 11.0 TSM 4.2.1.0. If we run a trace we do see the following messages, but don't know whether they are relevant: rpDoIt: About to restore 1 files Retrieve processing starting... dsmNFSsyscall lstat for path /prod1/recovery/ RestoreFile: Server aborted sub-transaction. Reason code: 5 ProcessFile: Got rc: 5 Anyone seen this problem on TSM? Thanks
Re: Problem deleting filespace SYSTEM OBJECT
and did it solve the problem and were you on 5.1.1.6? On Thu, 19 Sep 2002, Burton, Robert wrote: we are having the same problemand the auditdb for a 37 GB database took over 26 HRs... thanks Robert Burton Enterprise Storage Network Analyst Royal Bank of Canada 315 Front St West Toronto, On, M5V 3A4 * 416-348-3849 * [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Gerhard Rentschler [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 11:42 AM To: [EMAIL PROTECTED] Subject: Problem deleting filespace SYSTEM OBJECT Hello, I ran into the following problem with TSM 5.1.1.4 on AIX 4.3.3. Using the command del filespace rus_zsdsinz 'SYSTEM OBJECT' I get the following messages in the activity log: 09/18/02 16:20:33 ANR0984I Process 452 for DELETE FILESPACE started in the BACKGROUND at 16:20:33. 09/18/02 16:20:33 ANR0800I DELETE FILESPACE * (fsId=4) for node RUS_ZSDSINZ started as process 452. 09/18/02 16:20:33 ANR0802I DELETE FILESPACE * (fsId=4) (backup/archive data) for node RUS_ZSDSINZ started. 09/18/02 16:20:34 ANRD imfsdel.c(1860): ThreadId84 Error 1123 deleting group leader 0 585684848. 09/18/02 16:20:34 ANR0985I Process 452 for DELETE FILESPACE running in the BACKGROUND completed with completion state FAILURE at 16:20:34. I opened a PMR. Level 1 suggested to run the command cleanup backupgroup and retry the delete filespace command. It didn't help. The next advice was to upgrade to TSM 5.1.1.6 and retry the cleanup backupgroup and del filespace. The next thing to do would be a dsmserv auditdb. However, this would take a lot of time with my 55 GB database. Has anyone else seen this? Level 1 told me that he found only one similar problem. Best regards Gerhard --- Gerhard Rentschleremail:[EMAIL PROTECTED] Regional Computing Center tel. ++49/711/685 5806 University of Stuttgart fax: ++49/711/682357 Allmandring 30a D 70550 Stuttgart Germany -- This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de courriel ou par un autre moyen. ==
Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
To me is seems as though the worker sessions should be informing the control session as to the amount of work they have done. Each time the worker reports in, the control session would send a heart beat to the server thus avoiding this annoying timeout. On Wed, 18 Sep 2002, Seay, Paul wrote: The problem is the summary table is broken right now. I just got off the phone with Level 2. We think we have identified the cause of the problem. As it turns out the SUMMARY table records are written by the control session, not the actual backup sessions. What is happening is the control sessions are timing out and a new control session is being formed to send the statistics information. If you look at the start and end timestamps with the following select and then look at the activity log you will see what I am talking about. This select lists all sessions that have a byte count of zero. You will notice the start and end timestamps are usually the same or only a few seconds apart. The reason is the wrong numbers are being recorded. select entity, number, start_time, end_time from summary where bytes=0 and start_time current_timestamp-5 days and activity = 'BACKUP' order by 1,3 The issue is I can envision this is going to be very difficult to fix in the current design. It will be interesting. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Mark Bertrand [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 2:39 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting Paul and all, When I attempt to use any of the following select statements my Total MB returned is always 0. I get my list of nodes but there is never any numbers for size. Since this is my first attempt at select statements, I am sure I doing something wrong. I have tried from command line and through macro's. I am trying this on a W2K TSM v4.2.2 server. Thanks, Mark B. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 11:43 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting See if these will help: /* SQL Script: */ /* */ /* backup_volume_last_24hours.sql*/ /* Date Description*/ /* 2002-06-10 PDS Created*/ /* Create Report of total MBs per each session */ select entity as Node Name , cast(bytes/1024/1024 as decimal(10,3)) as Total MB , cast(substr(cast(end_time-start_time as char(17)),3,8) as char(8)) as Elapsed , substr(cast(start_time as char(26)),1,19) as Date/Time , case when cast((end_time-start_time) seconds as decimal) 0 then cast(bytes/cast((end_time-start_time) seconds as decimal)/1024/1024 as decimal(6,3)) else cast(0 as decimal(6,3)) end as MB/Sec from summary where start_time=current_timestamp - 1 day and activity='BACKUP' /* Create Report of total MBs and length of backup for each node */ select entity as Node Name , cast(sum(bytes/1024/1024) as decimal(10,3)) as Total MB, substr(cast(min(start_time) as char(26)),1,19) as Date/Time , cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as char(8)) as Lengthfrom summary where start_time=current_timestamp - 22 hours and activity='BACKUP' group by entity /* Create Report of total backed up*/ select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) Total GB Backup from summary where start_time=current_timestamp - 1 day and activity='BACKUP'
Antwort: TSM Scheduler on WinNT and Win2K
Hi, We have same problem on our environment. I'm still searching real solution, but I solved some of nodes wich are still working as regular. Many problemly node occured after TSM client update (v4.x to 5.1.1.0). my way as follows; - remove the scheduler service - uninstall complete old TSM client, - clean the registry entries - install the new TSM client - recreate the service with dsmcutil command. - also check the environment settings for DSM_CONFIG and DSM_DIR. this is not a solution but sometimes it works :) MfG Zafer [EMAIL PROTECTED]@VM.MARIST.EDU am 09/19/2002 09:46:53 PM Bitte antworten an [EMAIL PROTECTED] Gesendet von: [EMAIL PROTECTED] An: [EMAIL PROTECTED] Kopie: Thema: TSM Scheduler on WinNT and Win2K Hi all, The TSM Scheduler Service on most of my Win2k and NT4.0 boxes will not start up after a reboot. When I go in and start the service manually it starts up fine. I can't seem to find any errors in the Event Log. Any help you can provide will be appreciated. Thanks, Matt
Re: LAN-free backup goes SAN, LAN, SAN
I already made it work as I wanted and it works well. When the APAR gets fixed it would become perfect. The trick is that we do not have maxsize-redirecting. Everything is set intentionally and dispatched LAN or LAN-free by class bindings. I still did not read the limitations footnotes but if what I did was not supported the APAR will close enhancement request instead of bug :-) In both cases my opinion is that such functionality is useful. --- In the USA we place these type of animals in a zoo. I am missing something here but as you know I am not native English-speaker. Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:Re: LAN-free backup goes SAN, LAN, SAN Zlatko, I hope you can make it work. We had been unsuccessful. But, the recent client levels that have come out, we have not tried. It would really be nice for the thing to work correctly. Andy has corrected my understanding and he is going to test some more. The issue we had was the maxsize would kick in or rebinds of data that had gone down the LAN pathway. The storage agent would go nuts. Essentially, we found that you had to rebind using the LAN method and then turn LANFREE back on. In the USA we place these type of animals in a zoo. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180
Re: Problem deleting filespace SYSTEM OBJECT
Yes I have this problem. The reason I needed to delete the system objects was because they were not being deleted by EXPIRE INVENTORY and they were consuming 30% of my database space. My suggestion to all TSM admins is to do a QUERY OCCUPANCY * SYSTEM OBJECT to verify that you do not have excessive copies. On 5.1.1.4, I did the CLEANUP BACKUPGROUP and I still could not delete the system objects. I reran the cleanup command numerous times and each time it reported inspecting and deleting fewer objects than the previous run. The number was still in the 2000 range when I gave up and installed 5.1.1.6. On this level, expiration still failed to delete the system objects but I could manually delete most of them. As of now I have 6 servers where I can not delete the system objects. I have an open PMR. On Thu, 19 Sep 2002, Gerhard Rentschler wrote: Hello, I ran into the following problem with TSM 5.1.1.4 on AIX 4.3.3. Using the command del filespace rus_zsdsinz 'SYSTEM OBJECT' I get the following messages in the activity log: 09/18/02 16:20:33 ANR0984I Process 452 for DELETE FILESPACE started in the BACKGROUND at 16:20:33. 09/18/02 16:20:33 ANR0800I DELETE FILESPACE * (fsId=4) for node RUS_ZSDSINZ started as process 452. 09/18/02 16:20:33 ANR0802I DELETE FILESPACE * (fsId=4) (backup/archive data) for node RUS_ZSDSINZ started. 09/18/02 16:20:34 ANRD imfsdel.c(1860): ThreadId84 Error 1123 deleting group leader 0 585684848. 09/18/02 16:20:34 ANR0985I Process 452 for DELETE FILESPACE running in the BACKGROUND completed with completion state FAILURE at 16:20:34. I opened a PMR. Level 1 suggested to run the command cleanup backupgroup and retry the delete filespace command. It didn't help. The next advice was to upgrade to TSM 5.1.1.6 and retry the cleanup backupgroup and del filespace. The next thing to do would be a dsmserv auditdb. However, this would take a lot of time with my 55 GB database. Has anyone else seen this? Level 1 told me that he found only one similar problem. Best regards Gerhard --- Gerhard Rentschleremail:[EMAIL PROTECTED] Regional Computing Center tel. ++49/711/685 5806 University of Stuttgart fax: ++49/711/682357 Allmandring 30a D 70550 Stuttgart Germany
Re: Select command to q client name and version
select left(platform_name,13) as PLATFORM_NAME - , left(node_name,13) as NODE_NAME - , cast(client_version as CHAR(1)) || '.' - || cast(client_release as CHAR(1)) || '.' - || cast(client_levelas CHAR(1)) || '.' - || cast(client_sublevel as CHAR(2)) as LEVEL - , left(option_set,6) as OPTION_SET - , contact as Contact - from nodes On Thu, 19 Sep 2002, Alexander Verkooijen wrote: On 19-Sep-02 Karla Ross wrote: Does anyone have a select command that will show me the clients and what version of TSM they are running? My TSM servers are running TSM v4.1, 4.2, and 5.1. select node_name,client_version,client_release,client_sublevel from nodes --- Alexander Verkooijen([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
TDP(?) error
Hi We are trying to perform an Informix onbar restore from one node to another. We get the following errors (please note there are no TDP messages registed in the activity log): dsierror.log == 19/09/02 13:40:58 TcpOpen: TCP/IP error connecting to server. 19/09/02 13:40:58 sessOpen: Failure in communications open call. rc: -50 dsmerror.log == blank bar_act.log == 2002-09-19 13:40:58 23326 21832 /s026/informix/bin/onbar_d -r -p 2002-09-19 13:40:58 23326 21832 XBSA Error (BSAInit): An unspecified XBSA error has occurred: 96 2002-09-19 13:40:58 23326 21832 Due to the previous error, logical restore will not be attempted. 2002-09-19 13:40:58 23326 21832 /s026/informix/bin/onbar_d: process exit 96 (0x60) 2002-09-19 13:42:00 21840 23334 /s026/informix/bin/onbar_d -r -l 2002-09-19 13:42:00 21840 23334 ERROR: Unable to start logical restore before physical restore. 2002-09-19 13:42:00 21840 23334 /s026/informix/bin/onbar_d: process exit 151 (0x97) actlog = tsm: LITS-ADSM-SERVERq act begint=13:20 Date/Time Message -- 19/09/02 13:26:20ANR0407I Session 26 started for administrator ADMIN (AIX) (Tcp/Ip 25.109.195.161(33184)). 19/09/02 13:26:23ANR2017I Administrator ADMIN issued command: QUERY ACTLOG 19/09/02 13:27:23ANR0405I Session 26 ended for administrator ADMIN (AIX). 19/09/02 13:28:42ANR0406I Session 27 started for node S00026 (AIX) (Tcp/Ip 25.109.195.161(33185)). 19/09/02 13:28:55ANR0403I Session 27 ended for node S00026 (AIX). 19/09/02 13:41:36ANR0407I Session 28 started for administrator ADMIN (AIX) (Tcp/Ip 25.109.195.161(33191)). 19/09/02 13:41:36ANR2017I Administrator ADMIN issued command: ISSUE MESSAGE e Restore failed on rcadb. Please check logs 19/09/02 13:41:36ANR1498E Restore failed on rcadb. Please check logs 19/09/02 13:41:36ANR0405I Session 28 ended for administrator ADMIN (AIX). /usr/tivoli/tsm/client/informix/tdpipswd yields the following message: * * Tivoli Data Protection for Informix * * Password file initialization/update program * * ROOT privilege needed to update value on UNIX * * Enter your current password: Enter your new password: For verification, enter your new password again: Server signon failed: ANS1017E (RC-50) Session rejected: TCP/IP connection failure Any help would be appreciated. Debbie
Re: how can i clear up the content of a diskpool?
migrate it to zero becase i don't want to delete the diskpool volume ,but the content in the diskpool are useless. thanks When you say clear it up, AUDIT it or Migrate it to Zero? Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: fenglimian [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 10:24 PM To: [EMAIL PROTECTED] Subject: how can i clear up the content of a diskpool? what is the operation? thanks
DB Volume Reorg using Delete DBVOLUME
One of our TSM Support Staff members went to the advanced class and was led to believe you could get some reorg benefits doing the following Define New DB Volumes whereever you want them. Perform DELETE DBVOLUME commands on each of the existing DBVOLUMEs one at a time which causes the data to be moved. Our DBVOLUMES are on ESS disk so they are not mirrored. Thus, the delete causes a move of all the current data to other volumes. Has anyone ever heard of doing this to get some reorganization benefits? If so, were the benefits, mild or significant? I would not be surprised if massive filespace deletes could be recaptured by doing this. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180
Re: dsmcsvc.exe will not die
For the last two nights, I have disabled realtime virus check by Norton. Backups were successfull both nights. Now that I know the problem, I have to find the fix. Thanks all for your helpful responses. regards; Hussein A. -Original Message- From: Bill Boyer [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 3:29 PM To: [EMAIL PROTECTED] Subject: Re: dsmcsvc.exe will not die It was a known issue between OFM and McAfee. The client upgraded OFM to the lates 8.x version. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Hussein Abdirahman Sent: Wednesday, September 18, 2002 3:42 PM To: [EMAIL PROTECTED] Subject: Re: dsmcsvc.exe will not die Bill; How did you fix it? regards; Hussein A. -Original Message- From: Bill Boyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 2:57 PM To: [EMAIL PROTECTED] Subject: Re: dsmcsvc.exe will not die We had a problem like this at a client site that turned out to be a problem between McAfee Anti-vitus software and St. Bernard Open File Manager (OFM). Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Pitur Ey~srsson Sent: Wednesday, September 18, 2002 11:56 AM To: [EMAIL PROTECTED] Subject: Re: dsmcsvc.exe will not die yes i have had some problems with Anti-virus programs. But is almost impossible to say what caused it there can be so mutch. What kind of applications are running on your TSM Client? What version, maintenance, fix and patch is the Client you are using? What kind of configurations are you using in your dsm.opt file? 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 Hussein Abdirahman Sent: 18. september 2002 14:34 To: [EMAIL PROTECTED] Subject: dsmcsvc.exe will not die Hello All; I have a win2k client that its backup fails and the dsmsvc.exe process seems to consume a lot of CPU. 40-50% even when there is no backup running. I can not kill this process with the kill -f PID command or through the task manager. Stopping the service would not stop it either. The dsmerror.log contains the following. 09/18/2002 07:33:04 cuConfirm: Received rc: -50 trying to receive ConfirmResp verb 09/18/2002 07:33:04 ANS1809W Session is lost; initializing session reopen procedure. 09/18/2002 07:33:05 ANS1809W Session is lost; initializing session reopen procedure. 09/18/2002 07:33:20 ANS1810E TSM session has been reestablished. 09/18/2002 07:33:21 ANS1005E TCP/IP read error on socket = 844, errno = 10035, reason : 'A non-blocking socket operation could not be completed immediately.'. 09/18/2002 07:33:21 ANS1809W Session is lost; initializing session reopen procedure. 09/18/2002 07:33:22 ANS1809W Session is lost; initializing session reopen procedure. 09/18/2002 07:33:37 ANS1810E TSM session has been reestablished. Any suggestions on the cause and the cure of this? Environment: Client: Windows 2000 SP2 (contains a shared drive) Which is, looking the scheduler log, where the backup hangs. TSM client version is 5.1.1.0 Server; AIX 4.3.3.0 ML10 TSM version 5.1.1.0 TIA and regards; Hussein M. Abdirahman UNIX Administrator IrwinToy LTD
Re: binding WWN and SCSI on NT with QLOGIC
We've been working this same problem with the Qlogic 2300's. We downloaded a new version of the utility that is supposed to let you save the mapping. I'll get the version, and post back. After some preliminary testing (moving library to different port on swith, etc...) it appears to be working... Jason Livie wrote: Greetings, Is there a way to permanently bind a WWN address to a SCIS ID in w2K with a QLOGIC QLA2200. If so, what is the utility available and the driver version necessary for this. We are currently using driver version 8.1.5.60 on a QLA2200 and W2K. There seems to be a problem whenever the SAN glitches, the drive attribution on NT changes from the original setting, therefore our drivemapping on TSM is no longer valid in our lanfree environment. sincerely, Jason Livie e-Business Process/Storage Team - Service Delivery IBM Global Services - La Gaude Tél.: 04 9211 5943 - email : [EMAIL PROTECTED]
!Urgent - SDLT/TSM slow after upgrade from v. 4.2.1.7 to v. 4 .2.2.12
We had same kind of problems when we upgraded from ADSM 3.2.1.30 to TSM 4.2.1 o look at an archive , it tooks a very very long time.. To resolve we have executed a convert archive on each clients. it is a time consuming operation (average of 8 hours by node) but for my 20 clients and my DB of 11 Gb, expiration time have been reduced of 80% (30 to 40 hours before to 4 to 6 hours after the convert). I have no idea if it can be the same kind of problem by upgrading from 4.2.1.7 to 4.2.2.12 but... we run TSM on an IBM Netfinity 5000 NT4.0 sp6a 450 Mhz 500 Mb ram. Bruno Dostie e-mail[EMAIL PROTECTED] www:www.premiertech.com
Re: Antwort: TSM Scheduler on WinNT and Win2K
solution yoksa ne oyaliyon kardesim milleti [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 20.09.2002 14:39 Please respond to ADSM-L To: [EMAIL PROTECTED] cc: Subject: Antwort: TSM Scheduler on WinNT and Win2K Hi, We have same problem on our environment. I'm still searching real solution, but I solved some of nodes wich are still working as regular. Many problemly node occured after TSM client update (v4.x to 5.1.1.0). my way as follows; - remove the scheduler service - uninstall complete old TSM client, - clean the registry entries - install the new TSM client - recreate the service with dsmcutil command. - also check the environment settings for DSM_CONFIG and DSM_DIR. this is not a solution but sometimes it works :) MfG Zafer [EMAIL PROTECTED]@VM.MARIST.EDU am 09/19/2002 09:46:53 PM Bitte antworten an [EMAIL PROTECTED] Gesendet von: [EMAIL PROTECTED] An: [EMAIL PROTECTED] Kopie: Thema: TSM Scheduler on WinNT and Win2K Hi all, The TSM Scheduler Service on most of my Win2k and NT4.0 boxes will not start up after a reboot. When I go in and start the service manually it starts up fine. I can't seem to find any errors in the Event Log. Any help you can provide will be appreciated. Thanks, Matt
AIX client patch 4.2.2.5?
Can someone point me to the TSM AIX client 4.2.2.5 patch URL?? This patch contains the fix APAR IC3316. 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: How can I tell what tapes are in a BackupSet?
Thanks Joshua, When I do a query backupset, I do not recieve a list of volume names, just something like: Node Name: TSM Backup Set Name: FULL.53022439 Date/Time: 09/16/2002 10:58:00 Retention Period: 30 Device Class Name: LTOCLASS1 Description: TSM Full Any sugestions. What I would like is the ability to know which tapes are part of a specific backupset. TIA ... Jack -Original Message- From: Joshua Bassi [SMTP:[EMAIL PROTECTED]] [Coats, Jack] [snip] Subject: Re: How can I tell what tapes are in a BackupSet? Query backupset -- Joshua S. Bassi [Coats, Jack] [snip]
Re: How can I tell what tapes are in a BackupSet?
q volhist type=backupset
Error when backup Oracle 734 database through EBU
Dear all, I am using ADSM 3.1.2.1 to backup a Oracle734 database. The backup seems runs smoothly and successfully. However, when I try to run show version node_name /adsmorc, I found that nothing is backup to the backup server. Moreover, I found the following error in the dsierror.log. Can anyone help me on this issue? Thanks. 09/20/02 20:56:43 Oracle Connect Agent 09/20/02 20:56:43 (27364): 09/20/2002:20:56:43 =(KL) closeSend(): ANS0266I (RC2302) The dsmEndTxn vote is ABORT, so check the reason field. 09/20/02 20:56:43 Oracle Connect Agent 09/20/02 20:56:43 (27364): 09/20/2002:20:56:43 =(KL) sbtclose(): ADSM dsmEndTxn reason code=11 Regards, Kathy
Re: How can I tell what tapes are in a BackupSet?
I use the follwoing statement in excel to return the volumehistory information tied to the backupset information. Notice it is keyed off of the date and time so it is possible (although rare) to get some invalid information. SELECT VOLHISTORY.VOLUME_NAME, BACKUPSETS.NODE_NAME, BACKUPSETS.BACKUPSET_NAME, BACKUPSETS.DATE_TIME, BACKUPSETS.RETENTION, VOLHISTORY.TYPE, VOLHISTORY.COMMAND FROM BACKUPSETS BACKUPSETS, VOLHISTORY VOLHISTORY WHERE BACKUPSETS.DATE_TIME = VOLHISTORY.DATE_TIME Coats, Jack [EMAIL PROTECTED] on 09/19/2002 02:32:34 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Joseph Pendergast/Corona/Watson) Subject: How can I tell what tapes are in a BackupSet? Anyone have a suggestion for a select statement that could return this a list of the tapes in each BackupSet that is still active?
Reuse Delay
Does a Reuse Delay of 1 mean 24 hours or does it mean after midnight? What process caused a tape to move from Pending to Empty once the reuse delay time is up? David
Re: 3584 tape questions
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of David Longo Do you know how to access the info on the chip? I've seen the few comments in sales lit/manuals that have a couple of sentences but no info on how to access. It's supposed to have for one thing the total/partial stats for the life of the tape. I assumed the library or drive was updating that info. Any way to access with tapeutil or 3584 library Storwatch? We've had this discussion at the office. As far as we have been able to tell, the specs for chip access are published (although I've not been able to find them), but no one appears to have written anything to access them. If you're so inclined, go for it. Supposedly the chip stores data such as number of mounts and dismounts, total mileage (inchage?) the tape has undergone, date of last mount, etc. -- Mark Stapleton ([EMAIL PROTECTED]) Certified TSM consultant Certified AIX system engineer MCSE
Re: How can I tell what tapes are in a BackupSet?
q volhist t=backupset Will show which volume was used for the backupset, but I'm sure there are a few select statements that will also show them, sorry I'm not up to par on the select statements. Mark B. -Original Message- From: Coats, Jack [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 7:57 AM To: [EMAIL PROTECTED] Subject: Re: How can I tell what tapes are in a BackupSet? Thanks Joshua, When I do a query backupset, I do not recieve a list of volume names, just something like: Node Name: TSM Backup Set Name: FULL.53022439 Date/Time: 09/16/2002 10:58:00 Retention Period: 30 Device Class Name: LTOCLASS1 Description: TSM Full Any sugestions. What I would like is the ability to know which tapes are part of a specific backupset. TIA ... Jack -Original Message- From: Joshua Bassi [SMTP:[EMAIL PROTECTED]] [Coats, Jack] [snip] Subject: Re: How can I tell what tapes are in a BackupSet? Query backupset -- Joshua S. Bassi [Coats, Jack] [snip]
Re: serverfree - lanfree ?
http://searchstorage.techtarget.com/tip/1,289483,sid5_gci809457,00.html for more info on server-free vs. lan-free (current as of 6/2001) From: Zlatko Krastev/ACIT [EMAIL PROTECTED] Reply-To: ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: serverfree - lanfree ? Date: Fri, 20 Sep 2002 00:28:49 +0300 Chris, I try to explain to my customers in the following order: 1. Normal behavior (LAN) is in three steps - Node storage - TSM Client - TSM Server - Tape 2. LAN-free transfer reduces them to two steps eliminating one by combining last two in one - Node storage - TSM Client/Storage agent - Tape (last step requires SAN-shared tape) 3. server-free eliminates one more step, skipping both TSM server (as in LAN-free) and TSM client (new add-on) - Node storage - SAN-tape The last single-step is accomplished using SAN data mover, i.e. device on SAN capable to perform data transfer between a disk (Node storage) and tape (TSM server storage) without any host involvement (neither server nor client). Currently supported data movers are IBM SAN Data Gateway (2108-G07 and same module in IBM 3583) and Pathlight 5000. Hope this helps to you to understand. This will prove my customer explanation :-) Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:serverfree - lanfree ? Hi All Can someone please explain the difference between serverfree and lanfree backup? My understanding is that LAN free still involves the clients they just send their data over the SAN, and Serverfree uses some method to backup without involving the client. What software/clients/agents do you need to achieve both of these solutions? Working on a big implementation at the moment, including win2000, HSM, 2000 clusters, Exchange clusters new SAN, new storage etc etc etc. I think you going to be hearing a lot from me over the next couple of months, ! !! Chris Have a look at http://www.geocities.com/rees_chris _ Send and receive Hotmail on your mobile device: http://mobile.msn.com _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx
Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
They are working on a fix. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Joel Fuhrman [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 5:13 AM To: [EMAIL PROTECTED] Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND To me is seems as though the worker sessions should be informing the control session as to the amount of work they have done. Each time the worker reports in, the control session would send a heart beat to the server thus avoiding this annoying timeout. On Wed, 18 Sep 2002, Seay, Paul wrote: The problem is the summary table is broken right now. I just got off the phone with Level 2. We think we have identified the cause of the problem. As it turns out the SUMMARY table records are written by the control session, not the actual backup sessions. What is happening is the control sessions are timing out and a new control session is being formed to send the statistics information. If you look at the start and end timestamps with the following select and then look at the activity log you will see what I am talking about. This select lists all sessions that have a byte count of zero. You will notice the start and end timestamps are usually the same or only a few seconds apart. The reason is the wrong numbers are being recorded. select entity, number, start_time, end_time from summary where bytes=0 and start_time current_timestamp-5 days and activity = 'BACKUP' order by 1,3 The issue is I can envision this is going to be very difficult to fix in the current design. It will be interesting. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Mark Bertrand [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 2:39 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting Paul and all, When I attempt to use any of the following select statements my Total MB returned is always 0. I get my list of nodes but there is never any numbers for size. Since this is my first attempt at select statements, I am sure I doing something wrong. I have tried from command line and through macro's. I am trying this on a W2K TSM v4.2.2 server. Thanks, Mark B. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 11:43 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting See if these will help: /* SQL Script: */ /* */ /* backup_volume_last_24hours.sql*/ /* Date Description*/ /* 2002-06-10 PDS Created*/ /* Create Report of total MBs per each session */ select entity as Node Name , cast(bytes/1024/1024 as decimal(10,3)) as Total MB , cast(substr(cast(end_time-start_time as char(17)),3,8) as char(8)) as Elapsed , substr(cast(start_time as char(26)),1,19) as Date/Time , case when cast((end_time-start_time) seconds as decimal) 0 then cast(bytes/cast((end_time-start_time) seconds as decimal)/1024/1024 as decimal(6,3)) else cast(0 as decimal(6,3)) end as MB/Sec from summary where start_time=current_timestamp - 1 day and activity='BACKUP' /* Create Report of total MBs and length of backup for each node */ select entity as Node Name , cast(sum(bytes/1024/1024) as decimal(10,3)) as Total MB, substr(cast(min(start_time) as char(26)),1,19) as Date/Time , cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as char(8)) as Lengthfrom summary where start_time=current_timestamp - 22 hours and activity='BACKUP' group by entity /* Create Report of total backed up*/ select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) Total GB Backup from summary where start_time=current_timestamp - 1 day and activity='BACKUP'
tapes getting marked PRIVATE
It looks to me that each time I run a db backup TSM will attempt to grab a tape, think it finds an I/O error on the label read, then marks the tape PRIVATE and then moves on to the next tape. That wouldn't be such a problem except that it will do this to almost every tape in my library. I have had the drive hardware checked in the library and had both drives replaced. Did not have the picker checked. This problem does not seem to be happening during a regular data backup - only during the DB backup. Anyone seen this before or have any ideas.? Theresa Whitney Technical Systems Admin Northside ISD ph: (210) 706-8837 fax: (210) 706-8877 email: [EMAIL PROTECTED]
Re: how can i clear up the content of a diskpool?
Update stgpool stgpool_name hi=0 lo=0 This will get the whole pool. Migration will automatically start and empty the volume. A move data command will also do it if you just want the data from that one volume. Move data volume_name Yes, it works against primary storage pool volumes. But unless you set the volume to readonly it will start filling back up again. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: fenglimian [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 11:54 PM To: [EMAIL PROTECTED] Subject: Re: how can i clear up the content of a diskpool? migrate it to zero becase i don't want to delete the diskpool volume ,but the content in the diskpool are useless. thanks When you say clear it up, AUDIT it or Migrate it to Zero? Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: fenglimian [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 10:24 PM To: [EMAIL PROTECTED] Subject: how can i clear up the content of a diskpool? what is the operation? thanks
Trace File
This is the output of my trace file on a WINNT4.0 client with the PERFORM trace flag. TSM Gurus can help me figure out problems if any. I think that the EndTxn Verb parameter is on the high side. Also need a remedy if any. This client backs up to an AIX TSM server 4.2.1.11. Final Detailed Instrumentation statistics Elapsed time: 45388.537 s Section Total Time(sec) Average Time(msec) Frequency used -- Client Setup0.204 204.0 1 Process Dirs13964.102 238.7 58506 Solve Tree 0.0000.0 0 Compute11.9350.0 471566 Transaction 2988.1411.42073961 BeginTxn Verb 0.0160.0650 File I/O 3941.7506.6 599436 Compression 0.0000.0 0 Encryption 0.7990.0 471566 Delta 0.0000.0 0 Data Verb3080.8146.5 471566 Confirm Verb9.915 413.1 24 EndTxn Verb 24665.11937946.3650 Client Cleanup 2.718 2718.0 1 Any help is appreciated. _ Play the Elvis. Scratch Win for your chance to instantly win $10,000 Cash - a 2003 Harley Davidson. Sportster. - 1 of 25,000 CD's - and more! http://r.lycos.com/r/sagel_mail_scratch_tl/http://win.ipromotions.com/lycos_020801/index.asp?tc=7087
Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
Yeah, but this used to work just fine. If we're assuming that the problem is that the multiple backup sessions (RESOURCEUTILIZATION) is causing the error, then why did it work after this came out in the V3.7? It only broke sometime in the late 4.1/4.2 and 5.1 versions of the server. If it used to work, and now doesn't,...why is it so hard to fix it?? So many of us developed scripts/code and in the case of Lindsay Morris, commercial software (ServerGraph/TSM), that is not working, giving incorrect results, and making us look bad in the eye of our management. Bill -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Joel Fuhrman Sent: Friday, September 20, 2002 5:13 AM To: [EMAIL PROTECTED] Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND To me is seems as though the worker sessions should be informing the control session as to the amount of work they have done. Each time the worker reports in, the control session would send a heart beat to the server thus avoiding this annoying timeout. On Wed, 18 Sep 2002, Seay, Paul wrote: The problem is the summary table is broken right now. I just got off the phone with Level 2. We think we have identified the cause of the problem. As it turns out the SUMMARY table records are written by the control session, not the actual backup sessions. What is happening is the control sessions are timing out and a new control session is being formed to send the statistics information. If you look at the start and end timestamps with the following select and then look at the activity log you will see what I am talking about. This select lists all sessions that have a byte count of zero. You will notice the start and end timestamps are usually the same or only a few seconds apart. The reason is the wrong numbers are being recorded. select entity, number, start_time, end_time from summary where bytes=0 and start_time current_timestamp-5 days and activity = 'BACKUP' order by 1,3 The issue is I can envision this is going to be very difficult to fix in the current design. It will be interesting. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Mark Bertrand [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 2:39 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting Paul and all, When I attempt to use any of the following select statements my Total MB returned is always 0. I get my list of nodes but there is never any numbers for size. Since this is my first attempt at select statements, I am sure I doing something wrong. I have tried from command line and through macro's. I am trying this on a W2K TSM v4.2.2 server. Thanks, Mark B. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 11:43 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting See if these will help: /* SQL Script: */ /* */ /* backup_volume_last_24hours.sql*/ /* Date Description*/ /* 2002-06-10 PDS Created*/ /* Create Report of total MBs per each session */ select entity as Node Name , cast(bytes/1024/1024 as decimal(10,3)) as Total MB , cast(substr(cast(end_time-start_time as char(17)),3,8) as char(8)) as Elapsed , substr(cast(start_time as char(26)),1,19) as Date/Time , case when cast((end_time-start_time) seconds as decimal) 0 then cast(bytes/cast((end_time-start_time) seconds as decimal)/1024/1024 as decimal(6,3)) else cast(0 as decimal(6,3)) end as MB/Sec from summary where start_time=current_timestamp - 1 day and activity='BACKUP' /* Create Report of total MBs and length of backup for each node */ select entity as Node Name , cast(sum(bytes/1024/1024) as decimal(10,3)) as Total MB, substr(cast(min(start_time) as char(26)),1,19) as Date/Time , cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as char(8)) as Lengthfrom summary where start_time=current_timestamp - 22 hours and activity='BACKUP' group by entity /* Create Report of total backed up*/ select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) Total GB Backup from summary where start_time=current_timestamp - 1 day and activity='BACKUP'
Re: tapes getting marked PRIVATE
Yes i have a workaround for you. dont use scratch=yes. Use only tapes that you want to use spesificly on db backup. I never use scratch=yes. i always have 2-4 db tapes marked as private and use them on db backup. Regarding your problem i dont know how to solve it, but this will prevent the library from taking up all the scratch tapes. 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 Theresa Whitney Sent: 20. september 2002 13:45 To: [EMAIL PROTECTED] Subject: tapes getting marked PRIVATE It looks to me that each time I run a db backup TSM will attempt to grab a tape, think it finds an I/O error on the label read, then marks the tape PRIVATE and then moves on to the next tape. That wouldn't be such a problem except that it will do this to almost every tape in my library. I have had the drive hardware checked in the library and had both drives replaced. Did not have the picker checked. This problem does not seem to be happening during a regular data backup - only during the DB backup. Anyone seen this before or have any ideas.? Theresa Whitney Technical Systems Admin Northside ISD ph: (210) 706-8837 fax: (210) 706-8877 email: [EMAIL PROTECTED]
Re: how can i clear up the content of a diskpool?
Yes, but setting hi=0 causes migration to stop and start repeatedly if a user does a manual backup (say). We do update stgpool stgpool_name hi=100 lo=0 update stgpool stgpool_name hi=5 lo=0 setting it to 100 first, then down to 5, forces migration more reliably in some cases. Or you could set hi=0 momentarily, then hi=90 - migration will be forced by the first one and continue even though you immediately set hi=90. - Mr. Lindsay Morris Lead Architect, Servergraph 859-253-8000 ofc 425-988-8478 fax -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Seay, Paul Sent: Friday, September 20, 2002 10:07 AM To: [EMAIL PROTECTED] Subject: Re: how can i clear up the content of a diskpool? Update stgpool stgpool_name hi=0 lo=0 This will get the whole pool. Migration will automatically start and empty the volume. A move data command will also do it if you just want the data from that one volume. Move data volume_name Yes, it works against primary storage pool volumes. But unless you set the volume to readonly it will start filling back up again. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: fenglimian [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 11:54 PM To: [EMAIL PROTECTED] Subject: Re: how can i clear up the content of a diskpool? migrate it to zero becase i don't want to delete the diskpool volume ,but the content in the diskpool are useless. thanks When you say clear it up, AUDIT it or Migrate it to Zero? Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: fenglimian [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 10:24 PM To: [EMAIL PROTECTED] Subject: how can i clear up the content of a diskpool? what is the operation? thanks
Re: tapes getting marked PRIVATE
is the db backup from the dbbackuptrigger (based on log filling?)? check device class is this db backup from a command (check device class in use... -Original Message- From: Theresa Whitney [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 8:45 AM To: [EMAIL PROTECTED] Subject: tapes getting marked PRIVATE It looks to me that each time I run a db backup TSM will attempt to grab a tape, think it finds an I/O error on the label read, then marks the tape PRIVATE and then moves on to the next tape. That wouldn't be such a problem except that it will do this to almost every tape in my library. I have had the drive hardware checked in the library and had both drives replaced. Did not have the picker checked. This problem does not seem to be happening during a regular data backup - only during the DB backup. Anyone seen this before or have any ideas.? Theresa Whitney Technical Systems Admin Northside ISD ph: (210) 706-8837 fax: (210) 706-8877 email: [EMAIL PROTECTED]
Re: TSM sizing
We currently have in place, for every Client that is to be backed up, we need 50 tapes for TSM. Now that, that seems to supply the offsite and tape quantity (average), I am asking if anybody else does more. Case in point, we have a client that is going to increase with 900 GB Dasd. What about the DASD for the TSM server database, and storage pools, not to mention maybe more tape drives, (we currently have 10, 3590 E1A-x drives in a 3494 Tape Library SCSI attached) Does anybody have a scale of say 18 GB (2 %) for Database/Recovery Log, and 400 GB (50%) for storage pool increase, or whatever. If I don't stay up with the Jones/Clients, TSM will get left behind. Thanks for your help in advance. Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD
Off Topic: Upgrading RMU firmware on IBM3583 library
Has anyone updated the RMu firmware on a 3583? I'm looking at the docs, searching IBM's site and finding all kinds of stuff on the drives and library, but nothing on the RMU itself. It almost looks like you have to use the RMU to update the RMU, but there is a serial port on the back of it Any help would be VERY appreciated. Bill Boyer DSS, INc.
Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
The fix for this is at these levels (per apar doc): Apply patch 4.2.2.5, 5.1.1.1 or higher, available through Tivoli Web Page to resolve this problem, or fixing PTF when available. Here's a blerb from my etr/pmr (problem ticket): The APAR you are referring to is IC34462. This issue is specific to the summary table not being updated when client sessions are severed and the session has to be re-established. This APAR is currently open, but I have added you to the interested parties list for this APAR. There was also another APAR (IC33455) which addressed an issue with the summary table simply not being updated properly during client backups. Here's the actual 2 apars...the doc on the problem/issue: FYI Thanks Tim APAR Identifier .. IC34462 Last Changed..02/09/19 BYTES FIELD IN SUMMARY TABLE SHOWS VALUE 0 IF THE BACKUP SESSION IS LOST AND THEN REOPENED AGAIN (I.E. MSG ANS1809E) Symptom .. IN INCORROUT Status ... OPEN Severity ... 2 Date Closed . Component .. 5698ISMSV Duplicate of Reported Release . 51A Fixed Release Component Name TSM SERVER 510 Special Notice Current Target Date .. Flags SCP ... AIXRSC Platform AIX Status Detail: Not Available PE PTF List: PTF List: Parent APAR: Child APAR list: ERROR DESCRIPTION: When a backup session is lost and then reopened again successfully (e.g. MSG ANS1809E can be seen in the dsmsched.log), not all values in the SUMMARY TABLE of the TSM server will show the correct backup statistics. The BYTES field shows in that case a value of 0, while e.g the fields EXAMINED and AFFECTED show correct values. . Example: 1.) select * from summary where activity='BACKUP': START_TIME: 2002-08-28 19:32:06.00 END_TIME: 2002-08-28 19:54:17.00 ACTIVITY: BACKUP NUMBER: 366 ENTITY: LWLSAP2 COMMMETH: Tcp/Ip ADDRESS: 172.20.13.42:33133 SCHEDULE_NAME: MO-FR-1800 EXAMINED: 71137 AFFECTED: 251 FAILED: 0 BYTES: 0 = | IDLE: 0 MEDIAW: 0 PROCESSES: 1 SUCCESSFUL: YES VOLUME_NAME: DRIVE_NAME: LIBRARY_NAME: LAST_USE: . 2.) dsmsched.log: 08/28/02 18:01:25 Scheduler has been started by Dsmcad. 08/28/02 18:01:25 Querying server for next scheduled event. 08/28/02 18:01:25 Node Name: LWLSAP2 ... 08/28/02 18:59:19 ANS1898I * Processed66,000 files * 08/28/02 19:31:50 Normal File-- 2,048,008,192 /oracle/09p2/daten6/TBS_APOLLO4_IMG_TBS_2.ora Sent 08/28/02 19:31:50 ANS1809E Session is lost; initializing session reopen procedure. 08/28/02 19:32:06 ... successful 08/28/02 19:32:09 ANS1898I * Processed66,500 files * ... 08/28/02 19:54:16 Total number of objects inspected: 71,137 08/28/02 19:54:16 Total number of objects backed up: 251 08/28/02 19:54:16 Total number of objects updated: 0 08/28/02 19:54:16 Total number of objects rebound: 0 08/28/02 19:54:16 Total number of objects deleted: 0 08/28/02 19:54:16 Total number of objects expired: 63 08/28/02 19:54:16 Total number of objects failed: 0 08/28/02 19:54:16 Total number of bytes transferred: 6.46 GB 08/28/02 19:54:16 Data transfer time: 1,868.07 sec 08/28/02 19:54:16 Network data transfer rate: 3,629.75 KB/sec 08/28/02 19:54:16 Aggregate data transfer rate:1,001.56 KB/sec 08/28/02 19:54:16 Objects compressed by: 19% 08/28/02 19:54:16 Elapsed processing time: 01:52:50 It seems that when a session is lost and then reopened again, the new session descriptor does not hold the value for the bytes transfered so far anymore. . This problem was seen on a TSM AIX and NT 5.1.1.4 server, but maybe all TSM server levels will be affected which inlcude the fix for APAR IC33455. . Recreation: Unplug the network cable during a backup session = session lost Plug the network cable in again = backup session restarts Then check the SUMMARY TABLE for the BYTES field LOCAL FIX: Do not believe the values reported in the SUMMARY TABLE. Check the DSMSCHED.LOG or the ACTLOG for the correct backup statistics. APAR Identifier .. IC33455 Last Changed..02/07/19 SUMMARY TABLE NOT BEING FULLY UPDATED Symptom .. IN INCORROUT Status ... CLOSED PER Severity ... 2 Date Closed . 02/06/07 Component .. 5698TSMAX Duplicate of Reported Release . 420 Fixed Release 999 Component Name TSM AIX SERVER Special Notice Current Target Date .. Flags
Server Patch Level
Aix Server patch 5.1.1.5 is apparently not generally available. Is 5.1.1.6 stable or should I go to 5.1.1.4 instead? I am currently at Server and Storage Agent 5.1.1.0. Does the Server and the Storage Agent have to go to 5.1.1.x at the same time or can I take the Server to 5.1.1.x one week and do the Storage Agent upgrades the next week?
Re: tapes getting marked PRIVATE
I would carefully examine the actlog for instances of this happening and see what messages you are getting. If it's not obvious, then post messages here. David Longo [EMAIL PROTECTED] 09/20/02 09:44AM It looks to me that each time I run a db backup TSM will attempt to grab a tape, think it finds an I/O error on the label read, then marks the tape PRIVATE and then moves on to the next tape. That wouldn't be such a problem except that it will do this to almost every tape in my library. I have had the drive hardware checked in the library and had both drives replaced. Did not have the picker checked. This problem does not seem to be happening during a regular data backup - only during the DB backup. Anyone seen this before or have any ideas.? Theresa Whitney Technical Systems Admin Northside ISD ph: (210) 706-8837 fax: (210) 706-8877 email: [EMAIL PROTECTED] MMS health-first.org made the following annotations on 09/20/2002 10:46:54 AM -- 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. ==
Problem reading a backup set tape on UNIX client
I've created a DLT backup set tape on the TSM Server running Windows NT. I am able to query the contents of the backup set on the Windows TSM Server. When I take the DLT tape drive containing the backup set tape to a UNIX client machine and try to query the contents of the backup set I get a communications protocol error. I've mounted the tape device on the UNIX client and when I give it the query command the tape starts moving but I get the error message. Am I missing something when I create the tape or when I setup the query? Thanks, Doug
Re: tapes getting marked PRIVATE
Also, sometimes a tape gets funny. I've had to relabel tapes before with overwrite=yes in order to make them work at times. Something the first label gets funky or something. David N. Reiss TSM Support Engineer [EMAIL PROTECTED] 407-736-3912 -Original Message- From: Williams, Tim P {PBSG} [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 10:38 AM To: [EMAIL PROTECTED] Subject: Re: tapes getting marked PRIVATE is the db backup from the dbbackuptrigger (based on log filling?)? check device class is this db backup from a command (check device class in use... -Original Message- From: Theresa Whitney [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 8:45 AM To: [EMAIL PROTECTED] Subject: tapes getting marked PRIVATE It looks to me that each time I run a db backup TSM will attempt to grab a tape, think it finds an I/O error on the label read, then marks the tape PRIVATE and then moves on to the next tape. That wouldn't be such a problem except that it will do this to almost every tape in my library. I have had the drive hardware checked in the library and had both drives replaced. Did not have the picker checked. This problem does not seem to be happening during a regular data backup - only during the DB backup. Anyone seen this before or have any ideas.? Theresa Whitney Technical Systems Admin Northside ISD ph: (210) 706-8837 fax: (210) 706-8877 email: [EMAIL PROTECTED]
Re: tapes getting marked PRIVATE
Have you looked at the activity log messages? Could you provide them? Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Theresa Whitney [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 9:45 AM To: [EMAIL PROTECTED] Subject: tapes getting marked PRIVATE It looks to me that each time I run a db backup TSM will attempt to grab a tape, think it finds an I/O error on the label read, then marks the tape PRIVATE and then moves on to the next tape. That wouldn't be such a problem except that it will do this to almost every tape in my library. I have had the drive hardware checked in the library and had both drives replaced. Did not have the picker checked. This problem does not seem to be happening during a regular data backup - only during the DB backup. Anyone seen this before or have any ideas.? Theresa Whitney Technical Systems Admin Northside ISD ph: (210) 706-8837 fax: (210) 706-8877 email: [EMAIL PROTECTED]
Re: tapes getting marked PRIVATE
Good point! Suppose when the tapes were labeled the drive that labeled them was bad and now none of the drives can read them. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Reiss David IT751 (ext-CDI) [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 11:08 AM To: [EMAIL PROTECTED] Subject: Re: tapes getting marked PRIVATE Also, sometimes a tape gets funny. I've had to relabel tapes before with overwrite=yes in order to make them work at times. Something the first label gets funky or something. David N. Reiss TSM Support Engineer [EMAIL PROTECTED] 407-736-3912 -Original Message- From: Williams, Tim P {PBSG} [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 10:38 AM To: [EMAIL PROTECTED] Subject: Re: tapes getting marked PRIVATE is the db backup from the dbbackuptrigger (based on log filling?)? check device class is this db backup from a command (check device class in use... -Original Message- From: Theresa Whitney [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 8:45 AM To: [EMAIL PROTECTED] Subject: tapes getting marked PRIVATE It looks to me that each time I run a db backup TSM will attempt to grab a tape, think it finds an I/O error on the label read, then marks the tape PRIVATE and then moves on to the next tape. That wouldn't be such a problem except that it will do this to almost every tape in my library. I have had the drive hardware checked in the library and had both drives replaced. Did not have the picker checked. This problem does not seem to be happening during a regular data backup - only during the DB backup. Anyone seen this before or have any ideas.? Theresa Whitney Technical Systems Admin Northside ISD ph: (210) 706-8837 fax: (210) 706-8877 email: [EMAIL PROTECTED]
onsite and offsite tapes destroyed
Let's say for the sake of this discussion the following is true. Onsitetape1, 7, 9 and 11 are destroyed and not in the library, they have mixed node data on them. Offsitetape6, 9 and 15 have also been destroyed, they also have mixed node data on them. These tapes don't mirror each other but could have some of the same data on them. Question(s) 1. If all tapes are marked destroyed is TSM going to try and recreate anything automatically or do I have to manually perform an operation? 2. If someone wants to restore a file that happened to be on those, and both tapes have been destroyed, what do they see from their baclient GUI? Do they see the file backed up for that date? 3. Are all the files that were on those tapes simply expired from the inventory so they don't see anything? Thanks, Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
Re: tapes getting marked PRIVATE
We recently had this problem. We suspect that it was caused by one the 3590's in MTM (Media Test Mode). We had to re-label all the tapes and checkin as scratch -Original Message- From: Theresa Whitney [mailto:[EMAIL PROTECTED]] Sent: 20 September 2002 03:45 PM To: [EMAIL PROTECTED] Subject: tapes getting marked PRIVATE It looks to me that each time I run a db backup TSM will attempt to grab a tape, think it finds an I/O error on the label read, then marks the tape PRIVATE and then moves on to the next tape. That wouldn't be such a problem except that it will do this to almost every tape in my library. I have had the drive hardware checked in the library and had both drives replaced. Did not have the picker checked. This problem does not seem to be happening during a regular data backup - only during the DB backup. Anyone seen this before or have any ideas.? Theresa Whitney Technical Systems Admin Northside ISD ph: (210) 706-8837 fax: (210) 706-8877 email: [EMAIL PROTECTED] -- It is the strict policy of Truworths that its e-mail facility and all e-mail communications emanating therefrom, should be utilised for business purposes only and should conform to high professional and business standards. Truworths has stipulated certain regulations in terms whereof strict guidelines relating to the use and content of e-mail communications are laid down. The use of the Truworths e-mail facility is not permitted for the distribution of chain letters or offensive mail of any nature whatsoever. Truworths hereby distances itself from and accepts no liability in respect of the unauthorised use of its e-mail facility or the sending of e-mail communications for other than strictly business purposes. Truworths furthermore disclaims liability for any unauthorised instruction for which permission was not granted.Truworths Limited accepts no liability for any consequences arising from or as a result of reliance on this message unless it is in respect of bona fide Truworths business for which proper authorisation has been granted. Any recipient of an unacceptable communication, a chain letter or offensive material of any nature is requested to notify the Truworths e-mail administrator ([EMAIL PROTECTED]) immediately in order that appropriate action can be taken against the individual concerned.
Re: Off Topic: Upgrading RMU firmware on IBM3583 library
Simplest thing is have your IBM CE do it. David Longo [EMAIL PROTECTED] 09/20/02 10:18AM Has anyone updated the RMu firmware on a 3583? I'm looking at the docs, searching IBM's site and finding all kinds of stuff on the drives and library, but nothing on the RMU itself. It almost looks like you have to use the RMU to update the RMU, but there is a serial port on the back of it Any help would be VERY appreciated. Bill Boyer DSS, INc. MMS health-first.org made the following annotations on 09/20/2002 10:56:40 AM -- 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: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
For the record, Servergraph/TSM doesn't use the summary table, so problems there won't make it give incorrect results. It uses the accouting logs which have always been reliable. - Mr. Lindsay Morris Lead Architect, Servergraph 859-253-8000 ofc 425-988-8478 fax -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Boyer Sent: Friday, September 20, 2002 10:17 AM To: [EMAIL PROTECTED] Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND Yeah, but this used to work just fine. If we're assuming that the problem is that the multiple backup sessions (RESOURCEUTILIZATION) is causing the error, then why did it work after this came out in the V3.7? It only broke sometime in the late 4.1/4.2 and 5.1 versions of the server. If it used to work, and now doesn't,...why is it so hard to fix it?? So many of us developed scripts/code and in the case of Lindsay Morris, commercial software (ServerGraph/TSM), that is not working, giving incorrect results, and making us look bad in the eye of our management. Bill -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Joel Fuhrman Sent: Friday, September 20, 2002 5:13 AM To: [EMAIL PROTECTED] Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND To me is seems as though the worker sessions should be informing the control session as to the amount of work they have done. Each time the worker reports in, the control session would send a heart beat to the server thus avoiding this annoying timeout. On Wed, 18 Sep 2002, Seay, Paul wrote: The problem is the summary table is broken right now. I just got off the phone with Level 2. We think we have identified the cause of the problem. As it turns out the SUMMARY table records are written by the control session, not the actual backup sessions. What is happening is the control sessions are timing out and a new control session is being formed to send the statistics information. If you look at the start and end timestamps with the following select and then look at the activity log you will see what I am talking about. This select lists all sessions that have a byte count of zero. You will notice the start and end timestamps are usually the same or only a few seconds apart. The reason is the wrong numbers are being recorded. select entity, number, start_time, end_time from summary where bytes=0 and start_time current_timestamp-5 days and activity = 'BACKUP' order by 1,3 The issue is I can envision this is going to be very difficult to fix in the current design. It will be interesting. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Mark Bertrand [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 2:39 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting Paul and all, When I attempt to use any of the following select statements my Total MB returned is always 0. I get my list of nodes but there is never any numbers for size. Since this is my first attempt at select statements, I am sure I doing something wrong. I have tried from command line and through macro's. I am trying this on a W2K TSM v4.2.2 server. Thanks, Mark B. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 11:43 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting See if these will help: /* SQL Script: */ /* */ /* backup_volume_last_24hours.sql*/ /* Date Description*/ /* 2002-06-10 PDS Created*/ /* Create Report of total MBs per each session */ select entity as Node Name , cast(bytes/1024/1024 as decimal(10,3)) as Total MB , cast(substr(cast(end_time-start_time as char(17)),3,8) as char(8)) as Elapsed , substr(cast(start_time as char(26)),1,19) as Date/Time , case when cast((end_time-start_time) seconds as decimal) 0 then cast(bytes/cast((end_time-start_time) seconds as decimal)/1024/1024 as decimal(6,3)) else cast(0 as decimal(6,3)) end as MB/Sec from summary where start_time=current_timestamp - 1 day and activity='BACKUP' /* Create Report of total MBs and length of backup for each node */ select entity as Node Name , cast(sum(bytes/1024/1024) as decimal(10,3)) as Total MB, substr(cast(min(start_time) as char(26)),1,19) as Date/Time , cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as char(8)) as Lengthfrom summary where start_time=current_timestamp - 22 hours and activity='BACKUP' group by
Re: tapes getting marked PRIVATE
Hot Diggety! Seay, Paul was rumored to have written: Suppose when the tapes were labeled the drive that labeled them was bad and now none of the drives can read them. I had that issue pop up while setting up the 3584, and the culprit was when the /dev/rmtX and element ID mappings had fallen out of sync. End result? TSM loaded tape by element ID, then tried to access drive via its incorrect rmtX mapping -- so it hit on a drive that didn't have the tape loaded, got a read/open error, moved the tape back to its storage slot (via element ID), marked it as Private in the TSM db, and repeat for the next tape endlessly until TSM finally timed out this entire process. Fixing the mappings instantly fixed that particular problem. So I'd be more inclined to think that or some issue with DEVCLASS definition was the culprit since one of the original poster's key words were '...all tapes' -- if it was a bad tape, would have been an one-off. -Dan
Re: DB Volume Reorg using Delete DBVOLUME
Seay, Paul wrote: One of our TSM Support Staff members went to the advanced class and was led to believe you could get some reorg benefits doing the following Define New DB Volumes whereever you want them. Perform DELETE DBVOLUME commands on each of the existing DBVOLUMEs one at a time which causes the data to be moved. Our DBVOLUMES are on ESS disk so they are not mirrored. Thus, the delete causes a move of all the current data to other volumes. Has anyone ever heard of doing this to get some reorganization benefits? If so, were the benefits, mild or significant? I would not be surprised if massive filespace deletes could be recaptured by doing this. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 Paul, I have no inside information in order to answer this question, but I can give you my observations from many different customers who have done similar things in the past. My experience shows that the more frequently a customer adds, deletes, or moves (move data from DB Vol to DB Vol) DB volumes the more fragmented the DB becomes. In order to quantify DB fragmentation I look at general performance of the DB(in particular DB backups) as well as what happens after you do the unload/load DB, the greater the percentage that the DB was reduced the more fragmented I say it was. The way I understand the DB is structured is a B Tree like format. The reason the DB get bloat and poorer performance over time is due to the way the B Tree structure is maintained, i.e. just because I delete entries on the tree I do not delete a branch until all enttries down to the leaf are invalid. My understanding is that the only process that rebuilds the B Tree is the unload/load of the DB. Furthermore, the operation you are suggesting would simply move branches from location to location which may cause additional fragmentation. In addition, it may set the stage for more severe fragmentation if in fact fewer but longer branches were created. I would really like to hear from the developers on this. The key here would be what is ITSM doing when the del dbv command moves the data from the old vol to the new vol. I would love to hear that it would in fact solve the problem because as you know unload/load of the DB is quite time consuming and I beleive the above process would be much faster. -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. === MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE ===
Query client connectivity
To all: Is there a way to query client connectivity? What I mean is: Is there a way to see if at least basic connectivity is there (i.e. a scheduler running)? It would be nice to run a script just before I leave from work that lets me know that at least a scheduler is running on each machine, and not have to wait for the daily report that I get every morning to realize that 5 or 6 machines were missed during the night. Does TSM make something like this? A third party? Do I make my own? Any help would be appreciated! TIA. James Qualls Information Center Analyst III, CNE, CCNA Telephone: (509) 754-5088 ext. 2224 Direct Dial: (509) 754-6751 Email: [EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message and attachments have been scanned for the presence of computer viruses. **
Problems with EXPORT
Repeat message since no responses from original: This is mainly target at IBM/Tivoli but would appreciate any insight/suggestions/etc. Trying to EXPORT a node and get the following messages/failure. Tried twice, this one with PREVIEW: 09/19/2002 15:35:15 ANR0635I EXPORT NODE: Processing node ATLAS.VCU.EDU in domain UCSAC. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space / for node ATLAS.VCU.EDU. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space /home for node ATLAS.VCU.EDU. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space /home1 for node ATLAS.VCU.EDU. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space /home2 for node ATLAS.VCU.EDU. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space /home3 for node ATLAS.VCU.EDU. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space /home4 for node ATLAS.VCU.EDU. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space /home5 for node ATLAS.VCU.EDU. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space /usr/ac for node ATLAS.VCU.EDU. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space /usr/local for node ATLAS.VCU.EDU. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space /var/spool for node ATLAS.VCU.EDU. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space /home6 for node ATLAS.VCU.EDU. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space /home7 for node ATLAS.VCU.EDU. 09/19/2002 15:35:15 ANR0637I EXPORT NODE: Processing file space /src for node ATLAS.VCU.EDU. ... 09/19/2002 16:44:02 ANRD AFCPUTIL(1677): Row not found for bitfile 0.5885060. 09/19/2002 16:44:02 ANR0727E EXPORT NODE: Preview processing terminated abnormally - internal error. 09/19/2002 16:44:03 ANR0626I EXPORT NODE: Copied 1 node definitions. 09/19/2002 16:44:03 ANR0627I EXPORT NODE: Copied 13 file space 36498 archive files, 213857 backup files, and 0 space managed files. 09/19/2002 16:44:03 ANR0630I EXPORT NODE: Copied 12263360 kilobytes of data. 09/19/2002 16:44:03 ANR0611I EXPORT NODE started by ZFORRAY as process 84 has ended. 09/19/2002 16:44:03 ANR0986I Process 84 for EXPORT NODE running in the BACKGROUND processed 250369 items for a total of 12,557,680,961 bytes with a completion state of FAILURE at 16:44:03. I know for a fact the node has more data than this.
Re: onsite and offsite tapes destroyed
If both tape copies of a data file are destroyed and there is no copy anywhere else (disk/tape) then it is gone. You have to actually do a delete volume to destroy DB entires. The DB doesn't know that you can't get data, it just marks tape/disk volumes as unavailable so you can fix/figure it out. In situation where offsite tape only is destroyed, then use DEL VOL with DISCARDATA=YES. When this is complete, the do a BACKUP STG for appropriate stgpools and the data will be recopied to offsite pool from onsite pool. For onsite tape that is destroyed, do a RESTORE VOL blah PREVIEW=YES. When this process completes, examine actlog and see what offsite tapes are needed to rebuild this tape. Get them, checkin to library and set access mode to readonly for these tapes. Then run RESTORE VOL without PREVIEW and it will rebuild as much of the onsite tape as possible. Then check the offsite tapes back out, set access to offsite and send them back. When complete the onsite tape will be deleted and you can check it out of library if it's not already out, and trash it by your normal methods NOTE: If you do the PREVIEW and request then tapes back, then by the time you get them back, reclamation etc. can change what tapes are needed. When you are ready to put offsite tapes in, run the preview again and see what the updated list is. Most of the time it will be the same or close. You may need to get another tape or two back the next day to complete. I've done both of these scenarios a few times. David Longo [EMAIL PROTECTED] 09/20/02 11:20AM Let's say for the sake of this discussion the following is true. Onsitetape1, 7, 9 and 11 are destroyed and not in the library, they have mixed node data on them. Offsitetape6, 9 and 15 have also been destroyed, they also have mixed node data on them. These tapes don't mirror each other but could have some of the same data on them. Question(s) 1. If all tapes are marked destroyed is TSM going to try and recreate anything automatically or do I have to manually perform an operation? 2. If someone wants to restore a file that happened to be on those, and both tapes have been destroyed, what do they see from their baclient GUI? Do they see the file backed up for that date? 3. Are all the files that were on those tapes simply expired from the inventory so they don't see anything? Thanks, Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154 MMS health-first.org made the following annotations on 09/20/2002 11:43:45 AM -- 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: AIX client patch 4.2.2.5?
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Ken Sedlacek Can someone point me to the TSM AIX client 4.2.2.5 patch URL?? For AIX 4.3.3: ftp://service.boulder.ibm.com/storage/tivoli-storage-management/patches/clie nt /v4r2/AIX/v422/AIX43/ For AIX 5.1: ftp://service.boulder.ibm.com/storage/tivoli-storage-management/patches/clie nt /v4r2/AIX/v422/AIX51/ You're looking for IP22500_5.tar.Z, along with the relevant readmes. Don't depend on whatever link your email client says. Cut and paste both lines onto the address bar of your favorite web browser. (It's about time somebody finally went back to using .Z compression instead of .gz.) -- Mark Stapleton ([EMAIL PROTECTED]) Certified TSM consultant Certified AIX system engineer MCSE
Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
accounting logs...when you have resourceutilization higher than 1...there's multiple entries in the dsmaccnt.log file... I preferred to use a select statement and get totals out of the summary table, but that's screwed up now... argh! -Original Message- From: Mr. Lindsay Morris [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 10:03 AM To: [EMAIL PROTECTED] Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND For the record, Servergraph/TSM doesn't use the summary table, so problems there won't make it give incorrect results. It uses the accouting logs which have always been reliable. - Mr. Lindsay Morris Lead Architect, Servergraph 859-253-8000 ofc 425-988-8478 fax -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Boyer Sent: Friday, September 20, 2002 10:17 AM To: [EMAIL PROTECTED] Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND Yeah, but this used to work just fine. If we're assuming that the problem is that the multiple backup sessions (RESOURCEUTILIZATION) is causing the error, then why did it work after this came out in the V3.7? It only broke sometime in the late 4.1/4.2 and 5.1 versions of the server. If it used to work, and now doesn't,...why is it so hard to fix it?? So many of us developed scripts/code and in the case of Lindsay Morris, commercial software (ServerGraph/TSM), that is not working, giving incorrect results, and making us look bad in the eye of our management. Bill -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Joel Fuhrman Sent: Friday, September 20, 2002 5:13 AM To: [EMAIL PROTECTED] Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND To me is seems as though the worker sessions should be informing the control session as to the amount of work they have done. Each time the worker reports in, the control session would send a heart beat to the server thus avoiding this annoying timeout. On Wed, 18 Sep 2002, Seay, Paul wrote: The problem is the summary table is broken right now. I just got off the phone with Level 2. We think we have identified the cause of the problem. As it turns out the SUMMARY table records are written by the control session, not the actual backup sessions. What is happening is the control sessions are timing out and a new control session is being formed to send the statistics information. If you look at the start and end timestamps with the following select and then look at the activity log you will see what I am talking about. This select lists all sessions that have a byte count of zero. You will notice the start and end timestamps are usually the same or only a few seconds apart. The reason is the wrong numbers are being recorded. select entity, number, start_time, end_time from summary where bytes=0 and start_time current_timestamp-5 days and activity = 'BACKUP' order by 1,3 The issue is I can envision this is going to be very difficult to fix in the current design. It will be interesting. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Mark Bertrand [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 2:39 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting Paul and all, When I attempt to use any of the following select statements my Total MB returned is always 0. I get my list of nodes but there is never any numbers for size. Since this is my first attempt at select statements, I am sure I doing something wrong. I have tried from command line and through macro's. I am trying this on a W2K TSM v4.2.2 server. Thanks, Mark B. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 11:43 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting See if these will help: /* SQL Script: */ /* */ /* backup_volume_last_24hours.sql*/ /* Date Description*/ /* 2002-06-10 PDS Created*/ /* Create Report of total MBs per each session */ select entity as Node Name , cast(bytes/1024/1024 as decimal(10,3)) as Total MB , cast(substr(cast(end_time-start_time as char(17)),3,8) as char(8)) as Elapsed , substr(cast(start_time as char(26)),1,19) as Date/Time , case when cast((end_time-start_time) seconds as decimal) 0 then cast(bytes/cast((end_time-start_time) seconds as decimal)/1024/1024 as decimal(6,3)) else cast(0 as decimal(6,3)) end as MB/Sec from summary where start_time=current_timestamp - 1 day and
SQL to find # of mounts for tapes?
Hi there, I need the gurus help on this. I know my 3494 library keeps track of how many mounts each 3590 tape endures, but I was wondering if there was a way through tsm to find that out as well, most likely I assume through TSM/SQL. I'm looking for: Number of mounts for each tape Number of writing sessions to each tape (ie a backup or archive session, or reclamation write) Number of reading sessions from each tape (ie a restore session or a reclamation read) Any help would be greatly appreciated! I'm currently running Server Version 4.1.5 on AIX 4.3.3 however I will soon be migrating to 5.1.x Thanks in advance, Thomas Walker 212-408-8311 Unix Admin/TSM Admin EMI Recorded Music, NA This e-mail including any attachments is confidential and may be legally privileged. If you have received it in error please advise the sender immediately by return email and then delete it from your system. The unauthorized use, distribution, copying or alteration of this email is strictly forbidden. This email is from a unit or subsidiary of EMI Recorded Music, North America
tapes getting marked PRIVATE
Thanks to all who responded. I believe the original culprit was my bad tape drives in my 3575 library. I have now checkout and checked back in my tapes forcing it to write over the existing label. That seems to have solved my problem. Thanks again Theresa Whitney Technical Systems Admin Northside ISD ph: (210) 706-8837 fax: (210) 706-8877 email: [EMAIL PROTECTED]
Re: Problem reading a backup set tape on UNIX client
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Doug Thomson I've created a DLT backup set tape on the TSM Server running Windows NT. I am able to query the contents of the backup set on the Windows TSM Server. When I take the DLT tape drive containing the backup set tape to a UNIX client machine and try to query the contents of the backup set I get a communications protocol error. I've mounted the tape device on the UNIX client and when I give it the query command the tape starts moving but I get the error message. Neither. You're trying to run cross-platform operations. That won't work when you're doing local backupset restores. -- Mark Stapleton ([EMAIL PROTECTED]) Certified TSM consultant Certified AIX system engineer MCSE
Re: Problem reading a backup set tape on UNIX client
Doug, You can't do that, or at least that's what I was told. If you create the backupset on a Win server, you can only perform a local backupset restore on a Win server. Creating a backupset on a Win server and attempting to restore locally on a Unix client doesn't work (different tape formats). Regards, -Lloyd On Fri, 20 Sep 2002 12:02:03 -0300 Doug Thomson [EMAIL PROTECTED] wrote: I've created a DLT backup set tape on the TSM Server running Windows NT. I am able to query the contents of the backup set on the Windows TSM Server. When I take the DLT tape drive containing the backup set tape to a UNIX client machine and try to query the contents of the backup set I get a communications protocol error. I've mounted the tape device on the UNIX client and when I give it the query command the tape starts moving but I get the error message. Am I missing something when I create the tape or when I setup the query? Thanks, Doug -- - Lloyd Dieter- Senior Technology Consultant Synergy, Inc. http://www.synergyinc.cc [EMAIL PROTECTED] Main:585-389-1260fax:585-389-1267 -
Re: Query client connectivity
What I do is jsut put it in /etc/inittab as respawn. I'm not sure if there are Unix clients but that's what I do and I always know the scheduler is up and running unless there's some weird network glitch. --Justin Jim Qualls [EMAIL PROTECTED]To: [EMAIL PROTECTED] G cc: Sent by: ADSM: Subject: Query client connectivity Dist Stor Manager [EMAIL PROTECTED] .EDU 09/20/2002 11:29 AM Please respond to ADSM: Dist Stor Manager To all: Is there a way to query client connectivity? What I mean is: Is there a way to see if at least basic connectivity is there (i.e. a scheduler running)? It would be nice to run a script just before I leave from work that lets me know that at least a scheduler is running on each machine, and not have to wait for the daily report that I get every morning to realize that 5 or 6 machines were missed during the night. Does TSM make something like this? A third party? Do I make my own? Any help would be appreciated! TIA. James Qualls Information Center Analyst III, CNE, CCNA Telephone: (509) 754-5088 ext. 2224 Direct Dial: (509) 754-6751 Email: [EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message and attachments have been scanned for the presence of computer viruses. **
Re: SQL to find # of mounts for tapes?
The VOLUMES table has the information so long as the tape does not go scratch. Once it scratches it and reenters the counters are all reset. Do this Select to see what is there. The accounting log may have information that is permanently kept, but you will have to write your own code to process it. SELECT * from volumes where volume_name='vv' Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Walker, Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:31 PM To: [EMAIL PROTECTED] Subject: SQL to find # of mounts for tapes? Hi there, I need the gurus help on this. I know my 3494 library keeps track of how many mounts each 3590 tape endures, but I was wondering if there was a way through tsm to find that out as well, most likely I assume through TSM/SQL. I'm looking for: Number of mounts for each tape Number of writing sessions to each tape (ie a backup or archive session, or reclamation write) Number of reading sessions from each tape (ie a restore session or a reclamation read) Any help would be greatly appreciated! I'm currently running Server Version 4.1.5 on AIX 4.3.3 however I will soon be migrating to 5.1.x Thanks in advance, Thomas Walker 212-408-8311 Unix Admin/TSM Admin EMI Recorded Music, NA This e-mail including any attachments is confidential and may be legally privileged. If you have received it in error please advise the sender immediately by return email and then delete it from your system. The unauthorized use, distribution, copying or alteration of this email is strictly forbidden. This email is from a unit or subsidiary of EMI Recorded Music, North America
Re: (Silly?) DB2 Backup question
Log files are absolutely required if you are performing online backups. A. the database has to be in logretain mode to allow an online backup B. all transactions that occur during an online backup only go to log and won't be captured in the backup AFAIK. Otherwise logfile archiving is only necessary if you are interested in recovering the data that was committed after the last backup, if it is acceptable to lose all the data that is entered between backups then there is no need to archive log files. The practice I use is to perform offline backups every night (my outage window allows this) and log archives whenever a log is released, the log archives have a 30 day retention. Or you could hack together a script to backup the released logs and then delete them after the next successful offline DB2 backup so that TSM marks them as deleted. -Original Message- From: Lars Bebensee [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:18 AM To: [EMAIL PROTECTED] Subject: (Silly?) DB2 Backup question Hi guys and girls, this question is one of the general sort, so forgive me if it has been answered here or in some manual I haven't red yet. Probably, I just need a simpler description. AFAIK, there are three ways to backup a database: 1. Offline filesystem backup 2. Offline backup in the databases quiesced mode via some api 3. Online backup via api The first question I have is about the transaction log archiving. With which of the above does it make sense and why? The second one: does it make sense to run offline AND online backups in a backup cylce, or will one of them be save enough? I read through the TSM Redbook on DB2 UDB implementation. It just explains the ways RDBMS backups can be done not which combinations are useful. As far as I could extract, it is rather useless doing offline backups and log file archiving but no online backups, right?? Thanks in advance Lars This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you.
SQL - punting for help
Ok. This one is teasing me...puzzeling... trying to get, from the backups table files that ONLY are inactive (if the file has an active copy, I don't want to have this in the output). have tried...myself... anyone? have tried statestate, but this doesn't work ? Thanks tim
Re: SQL to find # of mounts for tapes?
Here's what I do from a ksh script . . . /usr/bin/dsmadmc -id=myuid -pass=mypasswd q actlog msgno=8337 begint=00:00 begind=-1 endd=-1 endt=23:59 | \ /usr/bin/grep -c ANR8337 This gives me a count of the number of tape mounts yesterday. I execute this script, log the output to a file, and then generate a graph using gnuplot to show the drive mounts over time. Mahesh [EMAIL PROTECTED] 09/20/02 01:36PM The VOLUMES table has the information so long as the tape does not go scratch. Once it scratches it and reenters the counters are all reset. Do this Select to see what is there. The accounting log may have information that is permanently kept, but you will have to write your own code to process it. SELECT * from volumes where volume_name='vv' Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Walker, Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:31 PM To: [EMAIL PROTECTED] Subject: SQL to find # of mounts for tapes? Hi there, I need the gurus help on this. I know my 3494 library keeps track of how many mounts each 3590 tape endures, but I was wondering if there was a way through tsm to find that out as well, most likely I assume through TSM/SQL. I'm looking for: Number of mounts for each tape Number of writing sessions to each tape (ie a backup or archive session, or reclamation write) Number of reading sessions from each tape (ie a restore session or a reclamation read) Any help would be greatly appreciated! I'm currently running Server Version 4.1.5 on AIX 4.3.3 however I will soon be migrating to 5.1.x Thanks in advance, Thomas Walker 212-408-8311 Unix Admin/TSM Admin EMI Recorded Music, NA This e-mail including any attachments is confidential and may be legally privileged. If you have received it in error please advise the sender immediately by return email and then delete it from your system. The unauthorized use, distribution, copying or alteration of this email is strictly forbidden. This email is from a unit or subsidiary of EMI Recorded Music, North America
Re: (Silly?) DB2 Backup question
There is a redbook, Backing up DB2 Using TSM SG24-6247 that has sample scripts for different full/log backup retention using the DB2ADUTL utility. I have this running using only ONLINE backups plus the DB2 user exit supplied by TSM for transaction log archiving. My biggest question has been if I only take ONLINE backups with the LOGS will I be able to restore the database, or do I need to do occassional OFFLINE backups to be able to recover? I also believe that the ONLINE backup does backup the log records that have occurred during the backup.I remember reading something about this somewhere, but I can't find it again. So I won't say I'm 100% sure about this. I do know that after an ONLINE backup the DB2ADUTL shows me with additional LOG backups, too. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Levinson, Donald A. Sent: Friday, September 20, 2002 1:40 PM To: [EMAIL PROTECTED] Subject: Re: (Silly?) DB2 Backup question Log files are absolutely required if you are performing online backups. A. the database has to be in logretain mode to allow an online backup B. all transactions that occur during an online backup only go to log and won't be captured in the backup AFAIK. Otherwise logfile archiving is only necessary if you are interested in recovering the data that was committed after the last backup, if it is acceptable to lose all the data that is entered between backups then there is no need to archive log files. The practice I use is to perform offline backups every night (my outage window allows this) and log archives whenever a log is released, the log archives have a 30 day retention. Or you could hack together a script to backup the released logs and then delete them after the next successful offline DB2 backup so that TSM marks them as deleted. -Original Message- From: Lars Bebensee [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:18 AM To: [EMAIL PROTECTED] Subject: (Silly?) DB2 Backup question Hi guys and girls, this question is one of the general sort, so forgive me if it has been answered here or in some manual I haven't red yet. Probably, I just need a simpler description. AFAIK, there are three ways to backup a database: 1. Offline filesystem backup 2. Offline backup in the databases quiesced mode via some api 3. Online backup via api The first question I have is about the transaction log archiving. With which of the above does it make sense and why? The second one: does it make sense to run offline AND online backups in a backup cylce, or will one of them be save enough? I read through the TSM Redbook on DB2 UDB implementation. It just explains the ways RDBMS backups can be done not which combinations are useful. As far as I could extract, it is rather useless doing offline backups and log file archiving but no online backups, right?? Thanks in advance Lars This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you.
Re: AIX client patch 4.2.2.5?
Thanks much Mark. I also agree about using .Z. So much easier to use. 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 Mark Stapleton stapleto@BERB To: [EMAIL PROTECTED] EE.COM cc: Sent by: Subject: Re: AIX client patch 4.2.2.5? ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 09/20/2002 11:46 AM Please respond to ADSM: Dist Stor Manager From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Ken Sedlacek Can someone point me to the TSM AIX client 4.2.2.5 patch URL?? For AIX 4.3.3: ftp://service.boulder.ibm.com/storage/tivoli-storage-management/patches/clie nt /v4r2/AIX/v422/AIX43/ For AIX 5.1: ftp://service.boulder.ibm.com/storage/tivoli-storage-management/patches/clie nt /v4r2/AIX/v422/AIX51/ You're looking for IP22500_5.tar.Z, along with the relevant readmes. Don't depend on whatever link your email client says. Cut and paste both lines onto the address bar of your favorite web browser. (It's about time somebody finally went back to using .Z compression instead of .gz.) -- Mark Stapleton ([EMAIL PROTECTED]) Certified TSM consultant Certified AIX system engineer MCSE
Re: SQL to find # of mounts for tapes?
Depending on your TSM level, you can get this information from the SUMMARY table. The column ACTIVITY will be TAPE MOUNT and there are columes for VOLUME_NAME, DRIVE_NAME, LIBRARY_NAME and LAST_USE. It won't tell you whether it was mounted for input or output, but the LAST_USE field could give you some hints: DbBackup- I would assume OUTPUT Backupset - I would also assume OUTPUT Data- couldn't tell. The END_TIME minus START_TIME will give you an elapsed time of how long the tape was mounted. This is one of my dream-graphs...to show each drive and it's total useage over a 24-hour period. the TSMManager package produces this graph. Plus you'll only be able to get these stats for however long your SUMMARYRETENTION options is set for. If you're an OS/390 user, don't bother... That information isn't kept in the summary table. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Mahesh Tailor Sent: Friday, September 20, 2002 2:11 PM To: [EMAIL PROTECTED] Subject: Re: SQL to find # of mounts for tapes? Here's what I do from a ksh script . . . /usr/bin/dsmadmc -id=myuid -pass=mypasswd q actlog msgno=8337 begint=00:00 begind=-1 endd=-1 endt=23:59 | \ /usr/bin/grep -c ANR8337 This gives me a count of the number of tape mounts yesterday. I execute this script, log the output to a file, and then generate a graph using gnuplot to show the drive mounts over time. Mahesh [EMAIL PROTECTED] 09/20/02 01:36PM The VOLUMES table has the information so long as the tape does not go scratch. Once it scratches it and reenters the counters are all reset. Do this Select to see what is there. The accounting log may have information that is permanently kept, but you will have to write your own code to process it. SELECT * from volumes where volume_name='vv' Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Walker, Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:31 PM To: [EMAIL PROTECTED] Subject: SQL to find # of mounts for tapes? Hi there, I need the gurus help on this. I know my 3494 library keeps track of how many mounts each 3590 tape endures, but I was wondering if there was a way through tsm to find that out as well, most likely I assume through TSM/SQL. I'm looking for: Number of mounts for each tape Number of writing sessions to each tape (ie a backup or archive session, or reclamation write) Number of reading sessions from each tape (ie a restore session or a reclamation read) Any help would be greatly appreciated! I'm currently running Server Version 4.1.5 on AIX 4.3.3 however I will soon be migrating to 5.1.x Thanks in advance, Thomas Walker 212-408-8311 Unix Admin/TSM Admin EMI Recorded Music, NA This e-mail including any attachments is confidential and may be legally privileged. If you have received it in error please advise the sender immediately by return email and then delete it from your system. The unauthorized use, distribution, copying or alteration of this email is strictly forbidden. This email is from a unit or subsidiary of EMI Recorded Music, North America
Re: SQL to find # of mounts for tapes?
We do someting similar, but we analyze all of the 50-or-so messages that pertain to drive mounts, and come up with the percent of time mounted during the day. That feeds into capacity planning - you can predict, with a wekk or two of history, when your library is going to be 100% utilized. - Mr. Lindsay Morris Lead Architect, Servergraph/TSM www.servergraph.com 859-253-8000 ofc 425-988-8478 fax -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Mahesh Tailor Sent: Friday, September 20, 2002 2:11 PM To: [EMAIL PROTECTED] Subject: Re: SQL to find # of mounts for tapes? Here's what I do from a ksh script . . . /usr/bin/dsmadmc -id=myuid -pass=mypasswd q actlog msgno=8337 begint=00:00 begind=-1 endd=-1 endt=23:59 | \ /usr/bin/grep -c ANR8337 This gives me a count of the number of tape mounts yesterday. I execute this script, log the output to a file, and then generate a graph using gnuplot to show the drive mounts over time. Mahesh [EMAIL PROTECTED] 09/20/02 01:36PM The VOLUMES table has the information so long as the tape does not go scratch. Once it scratches it and reenters the counters are all reset. Do this Select to see what is there. The accounting log may have information that is permanently kept, but you will have to write your own code to process it. SELECT * from volumes where volume_name='vv' Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Walker, Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:31 PM To: [EMAIL PROTECTED] Subject: SQL to find # of mounts for tapes? Hi there, I need the gurus help on this. I know my 3494 library keeps track of how many mounts each 3590 tape endures, but I was wondering if there was a way through tsm to find that out as well, most likely I assume through TSM/SQL. I'm looking for: Number of mounts for each tape Number of writing sessions to each tape (ie a backup or archive session, or reclamation write) Number of reading sessions from each tape (ie a restore session or a reclamation read) Any help would be greatly appreciated! I'm currently running Server Version 4.1.5 on AIX 4.3.3 however I will soon be migrating to 5.1.x Thanks in advance, Thomas Walker 212-408-8311 Unix Admin/TSM Admin EMI Recorded Music, NA This e-mail including any attachments is confidential and may be legally privileged. If you have received it in error please advise the sender immediately by return email and then delete it from your system. The unauthorized use, distribution, copying or alteration of this email is strictly forbidden. This email is from a unit or subsidiary of EMI Recorded Music, North America
Re: SQL to find # of mounts for tapes?
I wonder if I can get an initial report from my 3494 library and then use the VOLUMES table for TIMES_MOUNTED and the SUMMARY table for LAST_USE to at least get a close guess. Then just do an incremental report from then on. I also like the ksh idea of grabbing actlog entries. I just wish I could count writes and reads definitively. The main reason I'm doing this is that we're hearing here that there is a safety lifespan of tape media and it depends not only on the number of mounts but it's weighted (apparently, I'm still a little skeptical myself) towards writing. So after, say, 200 writes to the tape, it should be scrapped and and replaced with a shiny new one. But if it's primarily a read only tape, then it could stay in rotation for 700 reads. (The names and numbers are made up to protect my ignorance!) Regards, Thomas Walker 212-408-8311 Unix Admin/TSM Admin EMI Recorded Music, NA -Original Message- From: Bill Boyer [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:29 PM To: [EMAIL PROTECTED] Subject: Re: SQL to find # of mounts for tapes? Depending on your TSM level, you can get this information from the SUMMARY table. The column ACTIVITY will be TAPE MOUNT and there are columes for VOLUME_NAME, DRIVE_NAME, LIBRARY_NAME and LAST_USE. It won't tell you whether it was mounted for input or output, but the LAST_USE field could give you some hints: DbBackup- I would assume OUTPUT Backupset - I would also assume OUTPUT Data- couldn't tell. The END_TIME minus START_TIME will give you an elapsed time of how long the tape was mounted. This is one of my dream-graphs...to show each drive and it's total useage over a 24-hour period. the TSMManager package produces this graph. Plus you'll only be able to get these stats for however long your SUMMARYRETENTION options is set for. If you're an OS/390 user, don't bother... That information isn't kept in the summary table. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Mahesh Tailor Sent: Friday, September 20, 2002 2:11 PM To: [EMAIL PROTECTED] Subject: Re: SQL to find # of mounts for tapes? Here's what I do from a ksh script . . . /usr/bin/dsmadmc -id=myuid -pass=mypasswd q actlog msgno=8337 begint=00:00 begind=-1 endd=-1 endt=23:59 | \ /usr/bin/grep -c ANR8337 This gives me a count of the number of tape mounts yesterday. I execute this script, log the output to a file, and then generate a graph using gnuplot to show the drive mounts over time. Mahesh [EMAIL PROTECTED] 09/20/02 01:36PM The VOLUMES table has the information so long as the tape does not go scratch. Once it scratches it and reenters the counters are all reset. Do this Select to see what is there. The accounting log may have information that is permanently kept, but you will have to write your own code to process it. SELECT * from volumes where volume_name='vv' Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Walker, Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:31 PM To: [EMAIL PROTECTED] Subject: SQL to find # of mounts for tapes? Hi there, I need the gurus help on this. I know my 3494 library keeps track of how many mounts each 3590 tape endures, but I was wondering if there was a way through tsm to find that out as well, most likely I assume through TSM/SQL. I'm looking for: Number of mounts for each tape Number of writing sessions to each tape (ie a backup or archive session, or reclamation write) Number of reading sessions from each tape (ie a restore session or a reclamation read) Any help would be greatly appreciated! I'm currently running Server Version 4.1.5 on AIX 4.3.3 however I will soon be migrating to 5.1.x Thanks in advance, Thomas Walker 212-408-8311 Unix Admin/TSM Admin EMI Recorded Music, NA This e-mail including any attachments is confidential and may be legally privileged. If you have received it in error please advise the sender immediately by return email and then delete it from your system. The unauthorized use, distribution, copying or alteration of this email is strictly forbidden. This email is from a unit or subsidiary of EMI Recorded Music, North America
Re: DB Volume Reorg using Delete DBVOLUME
That would be a nice feature, but, at least on my Tivoli ADSM V3 server, doing a couple of volumes (about 5 gig out of 15 in use) had no effect on reported % utilization whatsoever.cheers, wayne Seay, Paul wrote, in part: One of our TSM Support Staff members went to the advanced class and was led to believe you could get some reorg benefits doing the following Define New DB Volumes whereever you want them. Perform DELETE DBVOLUME commands on each of the existing DBVOLUMEs one at a time which causes the data to be moved. Our DBVOLUMES are on ESS disk so they are not mirrored. Thus, the delete causes a move of all the current data to other volumes. Has anyone ever heard of doing this to get some reorganization benefits? If so, were the benefits, mild or significant? I would not be surprised if massive filespace deletes could be recaptured by doing this.
Re: SQL to find # of mounts for tapes?
Everytime a tape is ejected from the 3494 for offsite the numbers are reset. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Walker, Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:57 PM To: [EMAIL PROTECTED] Subject: Re: SQL to find # of mounts for tapes? I wonder if I can get an initial report from my 3494 library and then use the VOLUMES table for TIMES_MOUNTED and the SUMMARY table for LAST_USE to at least get a close guess. Then just do an incremental report from then on. I also like the ksh idea of grabbing actlog entries. I just wish I could count writes and reads definitively. The main reason I'm doing this is that we're hearing here that there is a safety lifespan of tape media and it depends not only on the number of mounts but it's weighted (apparently, I'm still a little skeptical myself) towards writing. So after, say, 200 writes to the tape, it should be scrapped and and replaced with a shiny new one. But if it's primarily a read only tape, then it could stay in rotation for 700 reads. (The names and numbers are made up to protect my ignorance!) Regards, Thomas Walker 212-408-8311 Unix Admin/TSM Admin EMI Recorded Music, NA -Original Message- From: Bill Boyer [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:29 PM To: [EMAIL PROTECTED] Subject: Re: SQL to find # of mounts for tapes? Depending on your TSM level, you can get this information from the SUMMARY table. The column ACTIVITY will be TAPE MOUNT and there are columes for VOLUME_NAME, DRIVE_NAME, LIBRARY_NAME and LAST_USE. It won't tell you whether it was mounted for input or output, but the LAST_USE field could give you some hints: DbBackup- I would assume OUTPUT Backupset - I would also assume OUTPUT Data- couldn't tell. The END_TIME minus START_TIME will give you an elapsed time of how long the tape was mounted. This is one of my dream-graphs...to show each drive and it's total useage over a 24-hour period. the TSMManager package produces this graph. Plus you'll only be able to get these stats for however long your SUMMARYRETENTION options is set for. If you're an OS/390 user, don't bother... That information isn't kept in the summary table. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Mahesh Tailor Sent: Friday, September 20, 2002 2:11 PM To: [EMAIL PROTECTED] Subject: Re: SQL to find # of mounts for tapes? Here's what I do from a ksh script . . . /usr/bin/dsmadmc -id=myuid -pass=mypasswd q actlog msgno=8337 begint=00:00 begind=-1 endd=-1 endt=23:59 | \ /usr/bin/grep -c ANR8337 This gives me a count of the number of tape mounts yesterday. I execute this script, log the output to a file, and then generate a graph using gnuplot to show the drive mounts over time. Mahesh [EMAIL PROTECTED] 09/20/02 01:36PM The VOLUMES table has the information so long as the tape does not go scratch. Once it scratches it and reenters the counters are all reset. Do this Select to see what is there. The accounting log may have information that is permanently kept, but you will have to write your own code to process it. SELECT * from volumes where volume_name='vv' Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Walker, Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:31 PM To: [EMAIL PROTECTED] Subject: SQL to find # of mounts for tapes? Hi there, I need the gurus help on this. I know my 3494 library keeps track of how many mounts each 3590 tape endures, but I was wondering if there was a way through tsm to find that out as well, most likely I assume through TSM/SQL. I'm looking for: Number of mounts for each tape Number of writing sessions to each tape (ie a backup or archive session, or reclamation write) Number of reading sessions from each tape (ie a restore session or a reclamation read) Any help would be greatly appreciated! I'm currently running Server Version 4.1.5 on AIX 4.3.3 however I will soon be migrating to 5.1.x Thanks in advance, Thomas Walker 212-408-8311 Unix Admin/TSM Admin EMI Recorded Music, NA This e-mail including any attachments is confidential and may be legally privileged. If you have received it in error please advise the sender immediately by return email and then delete it from your system. The unauthorized use, distribution, copying or alteration of this email is strictly forbidden. This email is from a unit or subsidiary of EMI Recorded Music, North America
Re: Query client connectivity
I thought I could do a telnet to port 1581 to a client to check this out. But on some servers with the service running, I can't connect to that port, some I can. I've never investigated further on why! -Original Message- From: Jim Qualls [mailto:[EMAIL PROTECTED]] Sent: September 20, 2002 10:30 AM To: [EMAIL PROTECTED] Subject: Query client connectivity To all: Is there a way to query client connectivity? What I mean is: Is there a way to see if at least basic connectivity is there (i.e. a scheduler running)? It would be nice to run a script just before I leave from work that lets me know that at least a scheduler is running on each machine, and not have to wait for the daily report that I get every morning to realize that 5 or 6 machines were missed during the night. Does TSM make something like this? A third party? Do I make my own? Any help would be appreciated! TIA. James Qualls Information Center Analyst III, CNE, CCNA Telephone: (509) 754-5088 ext. 2224 Direct Dial: (509) 754-6751 Email: [EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message and attachments have been scanned for the presence of computer viruses. **
Re: SQL - punting for help
It is probably not going to happen with the current database performance, but this would normally accomplish the task: select b.hl_name, b.ll_name from backups b where b.node_name='your node' and b.state=inactive_version and (b.hl_name || b.ll_name) not in (select a.hl_name || a.ll_name from backups a where a.node_name='your node' and a.state=active_version) I tried it on a single node and it did not find what I was looking for. I am going to turn in a problem record on it because it should work. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Williams, Tim P {PBSG} [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 1:59 PM To: [EMAIL PROTECTED] Subject: SQL - punting for help Ok. This one is teasing me...puzzeling... trying to get, from the backups table files that ONLY are inactive (if the file has an active copy, I don't want to have this in the output). have tried...myself... anyone? have tried statestate, but this doesn't work ? Thanks tim
Re: SQL - punting for help
Thanks!!! I'll give it a try!! -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 4:20 PM To: [EMAIL PROTECTED] Subject: Re: SQL - punting for help It is probably not going to happen with the current database performance, but this would normally accomplish the task: select b.hl_name, b.ll_name from backups b where b.node_name='your node' and b.state=inactive_version and (b.hl_name || b.ll_name) not in (select a.hl_name || a.ll_name from backups a where a.node_name='your node' and a.state=active_version) I tried it on a single node and it did not find what I was looking for. I am going to turn in a problem record on it because it should work. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Williams, Tim P {PBSG} [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 1:59 PM To: [EMAIL PROTECTED] Subject: SQL - punting for help Ok. This one is teasing me...puzzeling... trying to get, from the backups table files that ONLY are inactive (if the file has an active copy, I don't want to have this in the output). have tried...myself... anyone? have tried statestate, but this doesn't work ? Thanks tim
Re: SQL - punting for help
I just tried this, with some modifications (added the DISTINCT keyword and the FILESPACE_NAME column): select distinct b.filespace_name, b.hl_name, b.ll_name from backups b where b.node_name='MYNODE' and b.state=inactive_version and (b.filespace_name || b.hl_name || b.ll_name) not in (select a.filespace_name || a.hl_name || a.ll_name from backups a where a.node_name='MYNODE' and a.state=active_version) It worked for me. But I used a very small test case, so maybe my test was not entirely comprehensive. This was run on a 5.1.0.0 TSM server. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply) The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Seay, Paul [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 09/20/2002 14:19 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: SQL - punting for help It is probably not going to happen with the current database performance, but this would normally accomplish the task: select b.hl_name, b.ll_name from backups b where b.node_name='your node' and b.state=inactive_version and (b.hl_name || b.ll_name) not in (select a.hl_name || a.ll_name from backups a where a.node_name='your node' and a.state=active_version) I tried it on a single node and it did not find what I was looking for. I am going to turn in a problem record on it because it should work. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Williams, Tim P {PBSG} [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 1:59 PM To: [EMAIL PROTECTED] Subject: SQL - punting for help Ok. This one is teasing me...puzzeling... trying to get, from the backups table files that ONLY are inactive (if the file has an active copy, I don't want to have this in the output). have tried...myself... anyone? have tried statestate, but this doesn't work ? Thanks tim
Re: SQL - punting for help
Thank you too! some perspective...if you are wanting to know what has been deleted from a node (hence inactive)... vs active... and the expiredays (I believe).(delete last instances/versions/copies after x days have past)..hasn't completed...this will help you understand what you can attempt to restore -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 6:23 PM To: [EMAIL PROTECTED] Subject: Re: SQL - punting for help I just tried this, with some modifications (added the DISTINCT keyword and the FILESPACE_NAME column): select distinct b.filespace_name, b.hl_name, b.ll_name from backups b where b.node_name='MYNODE' and b.state=inactive_version and (b.filespace_name || b.hl_name || b.ll_name) not in (select a.filespace_name || a.hl_name || a.ll_name from backups a where a.node_name='MYNODE' and a.state=active_version) It worked for me. But I used a very small test case, so maybe my test was not entirely comprehensive. This was run on a 5.1.0.0 TSM server. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply) The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. Seay, Paul [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 09/20/2002 14:19 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: SQL - punting for help It is probably not going to happen with the current database performance, but this would normally accomplish the task: select b.hl_name, b.ll_name from backups b where b.node_name='your node' and b.state=inactive_version and (b.hl_name || b.ll_name) not in (select a.hl_name || a.ll_name from backups a where a.node_name='your node' and a.state=active_version) I tried it on a single node and it did not find what I was looking for. I am going to turn in a problem record on it because it should work. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Williams, Tim P {PBSG} [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 1:59 PM To: [EMAIL PROTECTED] Subject: SQL - punting for help Ok. This one is teasing me...puzzeling... trying to get, from the backups table files that ONLY are inactive (if the file has an active copy, I don't want to have this in the output). have tried...myself... anyone? have tried statestate, but this doesn't work ? Thanks tim