Re: OS390 TSM Performance questions.
Hi all, I followed your discussion with much interest, as I'm suffering from huge performance problem problem too. Unfortunately I'm not under OS390, but using AIX 4.3.3 : could someone tell me if there is some some trick like this one, that should be considered, when using this OS ? Another thing that annoys me : using show memu SHORT on my server (TSM 4.2.3.1) returns : ANR2000E Unknown command - SHOW MEMU Could it be that this command is only available for OS390 TSM version ? Thanks in advance. Arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -Original Message- From: Alan Davenport [mailto:[EMAIL PROTECTED]] Sent: Thursday, 13 February, 2003 21:41 To: [EMAIL PROTECTED] Subject: Re: OS390 TSM Performance questions. Hi Bill, Another thing that came up in our discussion was that the DB buffpoolsize should not exceed 131072 (128K). You might want to try that was well. Sounds like you have little to lose, like I did when I tried reducing the region size. Another observation. My cache hit ratio has gone up nearly a full percentage point after I made my adjustment this morning. I'm fairly happy at this point but I sure wish I knew WHY this has worked! I can see me trying to explain this to management. I solved the TSM performance problem! Really! How? I gave is less than half the memory to work with! OK Al, just stay calm the men with the white coats will be along shortly! At least it would be vacation time! (: Al -Original Message- From: Bill Kelly [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 2:49 PM To: [EMAIL PROTECTED] Subject: Re: OS390 TSM Performance questions. Hi, We seem to be experiencing symptoms similar (identical?) to Alan's. We're at z/OS 1.2, running on a 2066-002 w/ 8GB of memory and virtually no paging; TSM is at 4.2.3.0.; database is 55% of 106 GB. Network connectivity is via GB ethernet. Disk pool is 190GB on an ESS. Nightly backup load is approximately 230 clients (a mix of desktops and servers), averaging in the 130-140GB range per night total. For some weeks now (I'm not sure when this started, but I know the problem was there at 4.2.2.10), we've been seeing horrible performance after TSM has been up for a few hours. For example, I can watch 3 migration processes that run along fine for a little while, each getting approx. 400 MB/min throughput, then suddenly CPU utilization by TSM shoots up to 95% and throughput on the migrations drops to approx. 50 MB/min per process. Stopping and restarting the processes does no good, but cycling the server clears up the problem. I'm certain this problem affects other server activities, such as client backups, storage pool backups, etc. Like Alan, I've been ratcheting up the region size (up to 1.5 GB) and the db bufferpool size (up to 384 MB) in a vain attempt to help matters. I recently resorted to cycling the server 4 times per day just to get the performance needed to keep up with things. Based on the comments in this thread, I last night changed our region size to 512 MB and db bufferpool size to 128 MB. Until now, I wasn't aware of the 'show memu' diagnostic command (thanks Alan/Mark! I finally have *something* to quantify directly); here's the output from our server: MAX initial storage 536870912 (512.0 MB) Freeheld bytes 63678 (0.1 MB) MaxQuickFree bytes 10390159 (9.9 MB) 83 Page buffers of 12683 : 0 buffers of 1585. 0 Large buffers of 792 : 1 XLarge buffers of 99. 68 buffers free: 134 hiAlloc buffers: 66 current buffers. 12 units of 56 bytes hiAlloc: 11 units of 88 bytes hiCur. So apparently I still have the 'tiny Freeheld' problem; I suspect strongly I had the same trouble at 1.5 GB region size. (I don't suppose the functions of and relationships among these buffer pools is documented anywhere? I haven't found anything in the list archives or at the support web site.) I wonder if there's a factor other than db bufferpool size and region size that's affecting these buffer pool allocations? I suspect that our server performance goes south once we run out of one/some type(s) of these buffers and the server starts GETMAINing/FREEMAINing itself to death? Lacking any further information, I plan to do some bouncing of our server this weekend to see if I can come up with a region and db bufpool combination that will get the 'Freeheld bytes' (and presumably the 'buffers free') numbers into a reasonable range. Perhaps if I can do that, I'll be able to stop this insane cycling of the server every 5-8 hours. Thanks for your help and insight! Bill Bill Kelly Auburn University [EMAIL PROTECTED] On Thu, 13 Feb 2003, Alan Davenport wrote: I had my region size at 1280M and TSM was running just
Delete a file
Hi to all, How can i delete a file which resides on 3590 tape? Thanks in advance Nick Privileged/Confidential information may be contained in this message and may be subject to legal privilege. Access to this e-mail by anyone other than the intended recipient is unauthorised. If you are not the intended recipient (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver to anyone this message (or any part of its contents) or take any action in reliance on it. In such case, you should destroy this message, and notify us immediately. If you have received this email in error, please notify us immediately by e-mail or telephone and delete the e-mail from any computer. If you or your employer does not consent to internet e-mail messages of this kind, please notify us immediately. All reasonable precautions have been taken to ensure no viruses are present in this e-mail. As we cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments we recommend that you subject these to your virus checking procedures prior to use. The views, opinions, conclusions and other information expressed in this electronic mail are not given or endorsed by Laiki Group unless otherwise indicated by an authorised representative independent of this message.
Unsubscribe
Please remove me from the list. Thanks.
Undocumented TSM commands!!!
Hi All, Can any one help me in finding complete set of undocumented TSM commands or share with me if you have it, I was searching for these commands for a long time. Thanks, C.R.Chandrasekhar. Systems Executive. Tivoli Certified Consultant(TSM). TIMKEN Engineering Research - INDIA (P) Ltd., Bangalore. Phone No: 91-80-5536113 Ext:3032. Email:[EMAIL PROTECTED] ** This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not forward, copy, print, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. The Timken Company **
Backup eventlogs NT4
In the past i had 2 schedules for backup on NT4 and TSM V4: one for data and Registry and one for eventlogs. Since we use NT2000 and TSM V5 i was lucky since i had to use only one schedule for all. Now i want to use TSM V5 on NT4 and wonder, if there is no possibility (no pre script) to avoid the 2nd schedule. It seems, that everything has been as i had been in the past with V4. Why? Regards Stefan Holzwarth -Ursprüngliche Nachricht- Von: Raminder Braich [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 13. Februar 2003 21:51 An: [EMAIL PROTECTED] Betreff: NT restore to different hardware revisited.. A few weeks ago I sent an email asking if anyone could give me some directions on how to restore WINNT on different hardware. Thanks to everyone who responded. I was able to accomplish the restore. It is a little tricky but not hard. If anyone else likes to know the process, please send me an email individually. Regards Raminder Braich [EMAIL PROTECTED]
Re: LTO 3583 doesn't end audit lib
Humberto, you probably checked in tapes, which heve not been labeled with label libvolume. If you use option checklabel=bar, it is possible. Try checkout this volume from library and then do label libvolume. Regards Ing. Jozef Zatko Login a.s. Dlha 2, Stupava tel.: (421) (2) 60252618 Humberto Gmez Lpez To: [EMAIL PROTECTED] hugomez@UCABcc: .EDU.VE Subject: LTO 3583 doesn't end audit lib Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] RIST.EDU 13.02.2003 15:50 Please respond to ADSM: Dist Stor Manager Platform: W2k, TSM 5.1.6, San Data Gateway 2108 R03. I keep getting this on actlog after submitting audit lib, could anyone help on this? 40:04 ANR0609I AUDIT LIBRARY started as process 5. 02/13/2003 09:41:30 ANR8941W The volume from slot-element 4098 in drive MT0.4.0.3 (\\.\Tape1) in library LB0.1.0.3 is blank. 02/13/2003 09:41:37 ANR8941W The volume from slot-element 4097 in drive MT0.2.0.3 (\\.\Tape0) in library LB0.1.0.3 is blank. 02/13/2003 09:41:57 ANR8300E I/O error on library LB0.1.0.3 (OP=8401C058, CC=305, KEY=05, ASC=53, ASCQ=01, SENSE=70.00.05.00.00.00- .00.0A.00.00.00.00.53.01.00.00.00.00., Description=Drive failure). Refer to Appendix D in the 'Messages' manual for recommended action. 02/13/2003 09:41:57 ANR8942E Could not move volume NOT KNOWN from slot-element 257 to slot-element 4098. 02/13/2003 09:42:14 ANR8460E AUDIT LIBRARY process for library LB0.1.0.3 failed. 02/13/2003 09:42:14 ANR0985I Process 5 for AUDIT LIBRARY running in the BACKGROUND completed with completion state FAILURE at 09:42:14. - This mail sent through IMP: http://horde.org/imp/
Re: Undocumented TSM commands!!!
Hi C.R., You could try here : http://msgs.adsm.org/cgi-bin/get/adsm9809/116.html Or eventually, use the search fonction here : http://msgs.adsm.org/cgi-bin/get/adsm-current.html Richard Simms web page http://people.bu.edu/rbs/ADSM.QuickFacts would also be very usefull, concerning any *SM problem. My 2 (euro)cents ... Arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -Original Message- From: Chandrasekhar, C.R [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 February, 2003 12:00 To: [EMAIL PROTECTED] Subject: Undocumented TSM commands!!! Hi All, Can any one help me in finding complete set of undocumented TSM commands or share with me if you have it, I was searching for these commands for a long time. Thanks, C.R.Chandrasekhar. Systems Executive. Tivoli Certified Consultant(TSM). TIMKEN Engineering Research - INDIA (P) Ltd., Bangalore. Phone No: 91-80-5536113 Ext:3032. Email:[EMAIL PROTECTED] ** This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not forward, copy, print, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. The Timken Company **
auditdb: how to estimate number of records?
Hi list! I have a auditdb just now running on a test-machine. I can see a lot of lines telling me how much database entries have been processed. two questions: 1) Is there a possibility to estimate how much database entries there will be finally? 2) Why is that number of database entries so much bigger than the number of objects the expiration process reports? Thanks in advance best regards Paul
Re: Delete a file
How can i delete a file which resides on 3590 tape? If it was via a Backup, you don't directly delete it: TSM policies expire it. If it was an Archived file, you use the B/A client to delete the instance. I'd strongly recommend reading the TSM documentation to get more familiar with the product you are trying to use. Start with the Backup/Archive Clients manual, and then review the Admin manual.
Re: OS390 TSM Performance questions.
Post us some details iostat vmstat and how much memory disks e.t.c. The big quick win on AIX is vmtune -p5 -P10 But I guess you a.ready know that. -Original Message- From: PAC Brion Arnaud [mailto:[EMAIL PROTECTED]] Sent: Friday 14 February 2003 09:44 To: [EMAIL PROTECTED] Subject: Re: OS390 TSM Performance questions. Hi all, I followed your discussion with much interest, as I'm suffering from huge performance problem problem too. Unfortunately I'm not under OS390, but using AIX 4.3.3 : could someone tell me if there is some some trick like this one, that should be considered, when using this OS ? Another thing that annoys me : using show memu SHORT on my server (TSM 4.2.3.1) returns : ANR2000E Unknown command - SHOW MEMU Could it be that this command is only available for OS390 TSM version ? Thanks in advance. Arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -Original Message- From: Alan Davenport [mailto:[EMAIL PROTECTED]] Sent: Thursday, 13 February, 2003 21:41 To: [EMAIL PROTECTED] Subject: Re: OS390 TSM Performance questions. Hi Bill, Another thing that came up in our discussion was that the DB buffpoolsize should not exceed 131072 (128K). You might want to try that was well. Sounds like you have little to lose, like I did when I tried reducing the region size. Another observation. My cache hit ratio has gone up nearly a full percentage point after I made my adjustment this morning. I'm fairly happy at this point but I sure wish I knew WHY this has worked! I can see me trying to explain this to management. I solved the TSM performance problem! Really! How? I gave is less than half the memory to work with! OK Al, just stay calm the men with the white coats will be along shortly! At least it would be vacation time! (: Al -Original Message- From: Bill Kelly [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 2:49 PM To: [EMAIL PROTECTED] Subject: Re: OS390 TSM Performance questions. Hi, We seem to be experiencing symptoms similar (identical?) to Alan's. We're at z/OS 1.2, running on a 2066-002 w/ 8GB of memory and virtually no paging; TSM is at 4.2.3.0.; database is 55% of 106 GB. Network connectivity is via GB ethernet. Disk pool is 190GB on an ESS. Nightly backup load is approximately 230 clients (a mix of desktops and servers), averaging in the 130-140GB range per night total. For some weeks now (I'm not sure when this started, but I know the problem was there at 4.2.2.10), we've been seeing horrible performance after TSM has been up for a few hours. For example, I can watch 3 migration processes that run along fine for a little while, each getting approx. 400 MB/min throughput, then suddenly CPU utilization by TSM shoots up to 95% and throughput on the migrations drops to approx. 50 MB/min per process. Stopping and restarting the processes does no good, but cycling the server clears up the problem. I'm certain this problem affects other server activities, such as client backups, storage pool backups, etc. Like Alan, I've been ratcheting up the region size (up to 1.5 GB) and the db bufferpool size (up to 384 MB) in a vain attempt to help matters. I recently resorted to cycling the server 4 times per day just to get the performance needed to keep up with things. Based on the comments in this thread, I last night changed our region size to 512 MB and db bufferpool size to 128 MB. Until now, I wasn't aware of the 'show memu' diagnostic command (thanks Alan/Mark! I finally have *something* to quantify directly); here's the output from our server: MAX initial storage 536870912 (512.0 MB) Freeheld bytes 63678 (0.1 MB) MaxQuickFree bytes 10390159 (9.9 MB) 83 Page buffers of 12683 : 0 buffers of 1585. 0 Large buffers of 792 : 1 XLarge buffers of 99. 68 buffers free: 134 hiAlloc buffers: 66 current buffers. 12 units of 56 bytes hiAlloc: 11 units of 88 bytes hiCur. So apparently I still have the 'tiny Freeheld' problem; I suspect strongly I had the same trouble at 1.5 GB region size. (I don't suppose the functions of and relationships among these buffer pools is documented anywhere? I haven't found anything in the list archives or at the support web site.) I wonder if there's a factor other than db bufferpool size and region size that's affecting these buffer pool allocations? I suspect that our server performance goes south once we run out of one/some type(s) of these buffers and the server starts GETMAINing/FREEMAINing itself to death? Lacking any further information, I plan to do some bouncing of our server this weekend to see if I can come up with a region and db bufpool combination that will get the 'Freeheld bytes' (and presumably the 'buffers
Re: Delete a file
Hi, to delete any file from backups before normal expiration, we allocate a new file with same name, then bind it to a special management class with 1 0 0 0 as retention parameters(include x SPECMGT). Next backup will send this new (empty) file into this special management class, immediately deleting all previous backup versions. Next thing is to delete the new file on the client. Next expiration process will then expire the last inactive backup, you can then delete the include statement from the dsm.opt/inclexcl.list and that's it ! Regards, René LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center Information Technology Av. Nestlé 55 CH-1800 Vevey (Switzerland) tél +41 (0)21 924 35 43 fax +41 (0)21 703 30 17 local UBS-Nestec, Bussigny mailto:[EMAIL PROTECTED] This message is intended only for the use of the addressee and may contain information that is privileged and confidential. -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED]] Sent: Friday,14. February 2003 14:04 To: [EMAIL PROTECTED] Subject: Re: Delete a file How can i delete a file which resides on 3590 tape? If it was via a Backup, you don't directly delete it: TSM policies expire it. If it was an Archived file, you use the B/A client to delete the instance. I'd strongly recommend reading the TSM documentation to get more familiar with the product you are trying to use. Start with the Backup/Archive Clients manual, and then review the Admin manual.
volume in volhistory as STGDELETE
quick question we've got some tapes in our vault that apparantly dont show up anywhere in tsm under the volume or libvolume listing. the only place i have been able to find information about them is in the volhistory table which shows they were placed into a STGDELETE state back in november 2002. again.. these tapes do not show up anywhere else... not in volumes, libvolumes, contents, drmedia or media. can i safely assume there is nothing on these tapes? this is version 4.2.2
Re: volume in volhistory as STGDELETE
Yes, these tapes are as good as scratch. Check them in as scratch, and reuse them. When volhistory says STGDELETE, the volume has been removed from TSM usage, and can be reused. Just make sure there isn't a later input in volhistory, where tape has been reallocated to TSM. (STGNEW). Rgds Geirr G. Halvorsen -Original Message- From: Conko, Steven [mailto:[EMAIL PROTECTED]] Sent: 14. februar 2003 15:07 To: [EMAIL PROTECTED] Subject: volume in volhistory as STGDELETE quick question we've got some tapes in our vault that apparantly dont show up anywhere in tsm under the volume or libvolume listing. the only place i have been able to find information about them is in the volhistory table which shows they were placed into a STGDELETE state back in november 2002. again.. these tapes do not show up anywhere else... not in volumes, libvolumes, contents, drmedia or media. can i safely assume there is nothing on these tapes? this is version 4.2.2
TSM4.2 server and SNMP on HP-UX
Hi there, I cannot get the tivoli snmp subagent to talk with the local snmp agent on the os. Do you have any ideas ? TSM server is 4.2.2.7 on HP-UX 11.0 - SNMP was yesterday updated with the latest patch level from HP. output from dsmsnmp : by . SNMP Subagent Program for HP-UX Version 4, Release 2, Level 1.0 Licensed Materials - Property of IBM 5698-TSM (C) Copyright IBM Corporation 1997, 2001. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. ANR0900I Processing options file /opt/tivoli/tsm/server/bin/dsmserv.opt. ANR4681W Connect to SNMP agent failed, will keep trying. /etc/snmpd.conf : get-community-name: public set-community-name: admin #contact: # enter contact person for agent #location: # enter location of agent #max-trap-dest: # enter max no. of trap-dest entries to be maintained. #trap-dest: # enter trap destination # trap-dest: # trap-dest: 147.29.184.?? trap-dest: 194.89.157.179 dsmserv.opt : COMMMETHOD SNMP SNMPSUBAGENThost 127.0.0.1 comm public timeout 60 SNMPsubagentport1521 SNMPHEARTBEATINTERVAL 1 SNMPMESSAGECATEGORY individual Regards, Carsten Moldrup
Re: OS390 TSM Performance questions.
Richard, I totally agree with you, but if I tell you that my current situation happened due to the help from IBM support, what would you answer ? I had a rock solid system running TSM 4.2.2.1, until we had a problem with a tape library wich was unable to locate some tapes, I was then asked to update the library microcode, what I did. Off course another problem appeared, that this time should be corrected by upgradation from TSM server : I followed IBM expert advices, and this was the beginning of an upgradation waltz : microcode again, server etc etc ... Until the current state ! Sorry to tell you that, but I have 3 years of practice with TSM, and from what I'm seeing since approx 6 month, the product and service quality is really sinking. Just look at this list : why are so many people asking what version of TSM they should use ? Response : because ex-tivoli/IBM is not even able to deliver a non bugged version of its product. The last time I opened a PMR with IBM, do you know what their answer was : wait until next M.L. delivery, and jump to Version 5 ! Sorry but with such conditions, I can't afford buying another 6H0 and two 3584 libraries , just to test if experts advice would better or impair my productive environment : I (unfortunately) have to trust them ! Please, do not consider this as a personal attack, as I consider this list (and it's eminent members) as the most reliable source of information concerning TSM, but I'm really bored getting white hair for problems that would not exist if some people had done their job properly ... Thanks anyway. Arnaud (now calmed). =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 February, 2003 14:22 To: [EMAIL PROTECTED] Subject: Re: OS390 TSM Performance questions. I followed your discussion with much interest, as I'm suffering from huge performance problem problem too. Unfortunately I'm not under OS390, but using AIX 4.3.3 : could someone tell me if there is some some trick like this one, that should be considered, when using this OS ? Arnaud - Your posting did not say whether you've first pursued the recommendations in the TSM Performance Tuning Guide. If you are not also the AIX systems programmer at your site, you should confer with those people to have them review the environment in which you are running. In http://people.bu.edu/rbs/ADSM.QuickFacts I've collected various performance factors to check for. Rather than looking for tricks, it is far better to master the facets of your hardware and software environment, and thus have a solid grasp of maximum performance capabilities so as to recognize when things aren't working right and know what to do. Anything from overloaded SCSI adapters to misconfigured ethernet connections can be a factor. I can't stress strongly enough one major aspect of implementing systems that novices always overlook: doing a benchmark, first. It is vital that you road test whatever you implement before committing it to production. At a minimum, that should be your basis for accepting hardware and software from vendors, to see if they measure up to brochure specifications. Simple example: a printer which the vendor states will run at 100 pages per minute. If you don't initially test it, to discover that it ony produces 82 ppm when printing duplex, you're going to be in frantic mode when full-load printing comes along. The basic principle is that you MUST first assure that new hardware and software can perform at expected levels before committing them to production so as to be certain of their capabilities, and thus to truly know what is normal and what is abnormal when a problem situation occurs. And repeat your measurements if at all possible when doing firmware or microcode upgrades to avoid unpleasant surprises. Never assume that newer stuff is better: it may indeed have been created by someone equally new in the vendor company. Richard Sims, BU
Re: Estimating size of backup sets
Be careful using virtual volumes for backupsets. A backupset is not a recognized type of virtual volumes and if you run the RECONCILE VOLUMES command, the virtual volume will be deleted, but not the backupset reference to it. If you can absolutely guarantee that no one will ever run the RECONCILE VOLUMES command, virtual volumes would be good for backupsets, as you're not wasting a entire tape volume for a small node. Unless Tivoli changed this since I did initial testing back when 5.1 first came out... Bill Boyer Hit any user to continue! - ??? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Joerg Pohlmann Sent: Thursday, February 13, 2003 9:37 PM To: [EMAIL PROTECTED] Subject: Re: Estimating size of backup sets Graham, an estimate is the sum of (capacity * percent utilized) for the filespaces for a given client if you are including all filespaces in your GENERATE BACKUPSET. Realize that if you are using a tape device class, the minimum amount of media is one tape cartridge per backupset. So, for small clients, you may have a low utilization for backupset tapes. In your case, you will have a minimum of 700 tapes for the backupsets. You may want to consider a non-tape device class, such as a server device class if you have multiple TSM servers, or even setting up a virtual volume environment on a single TSM server as backupsets are then archive objects (that is virtual volumes) that can co-reside on a physical tape. The amount of space is then the sum of capacity * percent utilized for all 700 clients in MB - you can then take the capacity of the tape media to calculate the actual amount of space required. Use the capacity you achieved for full tapes as a realistic capacity. Joerg Pohlmann 604-535-0452 Graham Trigge [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 2003-02-13 14:35 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Estimating size of backup sets TSMers, Is there anyway people know of to estimate how large a backupset is going to be? I have close to 700 nodes I want to generate backupsets for and I want to know what sort of space I will be using up with them. I am assuming it will be some sort of SQL statement looking at active files, but I can't figure it out past that. Any help would be appreciated. Regards, -- Graham Trigge IT Technical Specialist Server Support Telstra Australia Phone: (02) 9882 5831 Fax: (02) 9882 5993 Mobile: 0409 654 434 The information contained in this e-mail and any attachments to it: (a) may be confidential and if you are not the intended recipient, any interference with, use, disclosure or copying of this material is unauthorised and prohibited. If you have received this e-mail in error, please delete it and notify the sender; (b) may contain personal information of the sender as defined under the Privacy Act 1988 (Cth). Consent is hereby given to the recipient(s) to collect, hold and use such information for any reasonable purpose in the ordinary course of TES' business, such as responding to this email, or forwarding or disclosing it to a third party.
Re: OS390 TSM Performance questions.
Hi, I hoped I made it clear it was pure supposition as to what the number meant. (: I'm trying to make sense of why, by reducing my region size by 768M performance increased dramatically. My daily maintenance cycle was a good 3+ hours ahead of schedule when I left for the day yesterday. I'm on track to see a similar completion time today. Who knows why this is so? Perhaps noone. My reaction is I am glad that it has helped solve my problem. At least it has provided a lively discussion! Take care, Al -Original Message- From: Bill Kelly [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 8:59 AM To: [EMAIL PROTECTED] Subject: Re: OS390 TSM Performance questions. Hi, I wanted to clarify, or perhaps retract, something about the 'show memu SHORT' command that has been mentioned in this thread. Not surprisingly, the numbers you get from this command vary depending on what's been going on in the server. Specifically, just after startup in a 512 MB region, I get: MAX initial storage 536870912 (512.0 MB) Freeheld bytes 69409 (0.1 MB) MaxQuickFree bytes 10390159 (9.9 MB) 83 Page buffers of 12683 : 0 buffers of 1585. 0 Large buffers of 792 : 1 XLarge buffers of 99. 61 buffers free: 148 hiAlloc buffers: 87 current buffers. 12 units of 56 bytes hiAlloc: 12 units of 104 bytes hiCur. A couple of hours later, after a storage pool copy has run and nightly backups are in full swing, I get: MAX initial storage 536870912 (512.0 MB) Freeheld bytes 10397099 (9.9 MB) MaxQuickFree bytes 10390159 (9.9 MB) 83 Page buffers of 12683 : 14 buffers of 1585. 2 Large buffers of 792 : 18 XLarge buffers of 99. 21616 buffers free: 48260 hiAlloc buffers: 13604 current buffers. 13400 units of 104 bytes hiAlloc: 4879 units of 56 bytes hiCur. Note that the Freeheld number, which intially looked 'bad', now looks 'good'. As has been pointed out to me off-list, unless you know how to interpret the numbers, they're just that - a bunch of numbers. I should've known better. :-) Regards, Bill Bill Kelly Auburn University [EMAIL PROTECTED]
Re: Setting up Shared Libraries
The redbook is wrong. You don't define the drives on the library client. You define a PATH on the library manager: define path library client server name drive name on library manager SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=library name DEVICE=device name on library client You need to make sure that the DEVICE= name is the same physical drive as the drive name on the library manager. For Fibre drives, make sure the WWN's match. You also need to make sure that the library manager and library client(s) are at the same code level. Bill Boyer I haven't lost my mind -- it's backed up on tape somewhere. - ??? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Jason Lee Sent: Thursday, February 13, 2003 6:49 PM To: [EMAIL PROTECTED] Subject: Setting up Shared Libraries Hi, I'm attempting to setup a shared 3494 library between linux boxes. I'm running 5.1.5.4 on all the boxes. Drives are Fibre channel 3590s. I've defined server to server communication etc., the library and drives on the manager, and the library on the clients. However, when I go to define the drives on the clients, I get a tsm: TSM-SLAVE-2define drive atl IBMTAPE0 ANR8403E DEFINE DRIVE: Operation not allowed for SHARED libraries. ANS8001I Return code 3. before I even get to create a path. Has anyone gone through this, and what am I doing wrong? Thanks *very* much for your help. Jason
Re: OS390 TSM Performance questions.
Richard, I totally agree with you, but if I tell you that my current situation happened due to the help from IBM support, what would you answer ? ... I'd agree with your frustration, Arnaud, given the premium price being paid to a top vendor. Generally, though, unless a vendor specialist is one I know, who is familiar with my site, I accept the advice as suggestive, and thereafter check it to the extent possible for usability in my site, and test it if at all possible first, as for example deploying new drive microcode on just one drive first. Some technician on the other end of the phone line knows nothing about your site and is just rendering an isolated suggestion - which we *expect* has been reasonably tested by the product specialists. For new products, we can often look to the various industry reviews for the worthiness of offerings, and do web searches for customer experiences. As for chronic problem areas like certain software or 8mm drives - well, that's its own story, which we know painfully well. ...but I'm really bored getting white hair for problems that would not exist if some people had done their job properly... Hah! I'm way ahead of you: vendor exasperation started giving me gray hair when I was about 34! Richard Sims, BU Most vendors have a view of time that would amaze Albert Einstein.
Re: OS390 TSM Performance questions.
Well you dont mention the stripe size used for the database and logs file systems. We had our database and log on a striped filesystem and we had a really bad expire perf srtipe size was 64 kb. From memory all database actions are 4kbyte. Are these ssa disk if yes do you have write cache installed if yes is it enabled for these disks ? We moved the database and logs back to old normal lv's and we had a marked inprovement in expirary perf. We also did a unload load which also really helped. Before the changes we were receiving more objects per day than we could expire. You seem to have 4 way mirroring TSM and And AIX or am I misreading this. We use only AIX lvm mirroring. Be aware that using AIX mirroring you get hit by the mirror write consistency update. To mimimize this have the busiest lv's postioned at the outer edge right next to track 0 Write cache eliminates the perf hit of mwcc. Also the setup of multple vg's can alos result in having multiple active jfslogs whereas with one large vg you can isloate the jfslog to one or more disks but I assume that the jfslog would not be very busy. Filemon can answer that question. the -W 256 in vmtune could this be your problem ? Here is our vmtune stuff for comparison use it if you dare. # ./vmtune vmtune: current values: -p -P-r -R -f -F -N-W minperm maxperm minpgahead maxpgahead minfree maxfree pd_npages maxrandwrt 2621352426 2128 10001 5242880 -M -w -k -c-b -B -u-l -d maxpin npswarn npskill numclust numfsbufs hd_pbuf_cnt lvm_bufcnt lrubucket defps 419411 163844096 1 930560 64 131072 1 -s -n -S -L -g -h sync_release_ilock nokilluid v_pinshm lgpg_regions lgpg_size strict_maxperm 0 0 0 000 -t maxclient 418588 number of valid memory pages = 524263 maxperm=10.0% of real memory maximum pinable=80.0% of real memoryminperm=5.0% of real memory number of file memory pages = 92187 numperm=17.6% of real memory number of compressed memory pages = 0 compressed=0.0% of real memory number of client memory pages = 0 numclient=0.0% of real memory # of remote pgs sched-pageout = 0 maxclient=79.8% of real memory
Re: When comes the supportTDP for Oracle 9.2.x.x
Michael, We support 9.2 with Data Protection for Oracle 2.2.1 (Data Protection for Oracle 5.1.5 on AIX 5L 64bit). -- Date:Thu, 13 Feb 2003 08:26:46 +0100 From:Schmitz Garnebode [EMAIL PROTECTED] Subject: When comes the supportTDP for Oracle 9.2.x.x Good morning, can anybody tell me when Tivoli support Oracle 9.2.x.x with TDP ?? MfG Michael Garnebode Diplom-Informatiker Schmitz Rz Consult GmbH Bachstr.1 50259 Pulheim Tel.: 02238/922266 Fax: 02238/922267 EMail: [EMAIL PROTECTED] Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: volume in volhistory as STGDELETE
can i safely assume there is nothing on these tapes? Steven - I initially presume so, but always check my Activity Log for the circumstances surrounding last use, just to be completely sure. Boo-boos can be expensive.Richard
Re: Mksysb directly into TSM 5.1
It looks like the new version of sysback will be able to do this. At least thats what I read between the lines of the pre-informatie on the web. I would not waste my time with adsmpipe. -Original Message- From: Lambelet,Rene,VEVEY,GL-CSC [mailto:[EMAIL PROTECTED]] Sent: Friday 14 February 2003 15:04 To: [EMAIL PROTECTED] Subject: Mksysb directly into TSM 5.1 Hello, any idea to send mksysb directly to tsm 5.1 (AIX)? I've heard adsmpipe is not officialy supported, does anybody use named pipe to write their mksysb ? If yes, how do you read back form the file ? For now we use a NIM server and NFS, this is not optimum. Thanks a lot, René LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center Information Technology Av. Nestlé 55 CH-1800 Vevey (Switzerland) tél +41 (0)21 924 35 43 fax +41 (0)21 703 30 17 local UBS-Nestec, Bussigny mailto:[EMAIL PROTECTED] This message is intended only for the use of the addressee and may contain information that is privileged and confidential.
Re: When comes the supportTDP for Oracle 9.2.x.x
Hi Neil! I have mentioned it here before, but nobody seems to bother: TDP for Oracle 2.2 is end of support after April 15th. What next? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Neil Rasmussen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 16:21 To: [EMAIL PROTECTED] Subject: Re: When comes the supportTDP for Oracle 9.2.x.x Michael, We support 9.2 with Data Protection for Oracle 2.2.1 (Data Protection for Oracle 5.1.5 on AIX 5L 64bit). -- Date:Thu, 13 Feb 2003 08:26:46 +0100 From:Schmitz Garnebode [EMAIL PROTECTED] Subject: When comes the supportTDP for Oracle 9.2.x.x Good morning, can anybody tell me when Tivoli support Oracle 9.2.x.x with TDP ?? MfG Michael Garnebode Diplom-Informatiker Schmitz Rz Consult GmbH Bachstr.1 50259 Pulheim Tel.: 02238/922266 Fax: 02238/922267 EMail: [EMAIL PROTECTED] Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED] ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Mksysb directly into TSM 5.1
Clark, which version of sysback? it seems to me that last announced one is not able to interface to TSM... yours, René LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center Information Technology Av. Nestlé 55 CH-1800 Vevey (Switzerland) tél +41 (0)21 924 35 43 fax +41 (0)21 703 30 17 local UBS-Nestec, Bussigny mailto:[EMAIL PROTECTED] This message is intended only for the use of the addressee and may contain information that is privileged and confidential. -Original Message- From: Rodney clark [mailto:[EMAIL PROTECTED]] Sent: Friday,14. February 2003 16:27 To: [EMAIL PROTECTED] Subject: Re: Mksysb directly into TSM 5.1 It looks like the new version of sysback will be able to do this. At least thats what I read between the lines of the pre-informatie on the web. I would not waste my time with adsmpipe. -Original Message- From: Lambelet,Rene,VEVEY,GL-CSC [mailto:[EMAIL PROTECTED]] Sent: Friday 14 February 2003 15:04 To: [EMAIL PROTECTED] Subject: Mksysb directly into TSM 5.1 Hello, any idea to send mksysb directly to tsm 5.1 (AIX)? I've heard adsmpipe is not officialy supported, does anybody use named pipe to write their mksysb ? If yes, how do you read back form the file ? For now we use a NIM server and NFS, this is not optimum. Thanks a lot, René LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center Information Technology Av. Nestlé 55 CH-1800 Vevey (Switzerland) tél +41 (0)21 924 35 43 fax +41 (0)21 703 30 17 local UBS-Nestec, Bussigny mailto:[EMAIL PROTECTED] This message is intended only for the use of the addressee and may contain information that is privileged and confidential.
Re: OS390 TSM Performance questions.
I am resending this to the list, because I only copied it to Bill earlier, and the thread is still going so there may be some interest in it -- Forwarded by John Naylor/HAV/SSE on 02/14/2003 03:54 PM --- John Naylor 02/14/2003 09:43 AM To: Bill Kelly [EMAIL PROTECTED] cc: Subject: Re: OS390 TSM Performance questions. (Document link: John Naylor) Hi Bill, We are running TSM 4.2.2 on os390 2.10 pn a 9672 (5 cpus) I have region at 512 mb. and bufferpool at 48 mb. I am running alongside other business applications, and it is only when they are busy and the lpar becomes cpu constrained especially when a DB2 application is very busy that TSM suffers significantly performance wise. This morning I ran migration from disk to tape alongside expiration and and I got 450 mb. per minute, I do occasionally bounce the server, maybe every three weeks if my perception is that the performance is a bit more sluggish than normal. Do you have access to RMF or similar performance tools, as this should help to isolate what is causing your performance issue. I personally would look at your bufferpool size, maybe reducing it. What do your stats show, I ran the show memu see results below, but unless someone who really understands the figures explains what they mean?, what are good figures?, what are bad figures?, how are they impacted by the current TSM activity? , I do not think they are worth very much. For example my Freeheld bytes shows (0.7 MB) Good, bad, indifferent.? Who knows? MAX initial storage 536870912 (512.0 MB) Freeheld bytes 741499 (0.7 MB) MaxQuickFree bytes 10391797 (9.9 MB) 35 Page buffers of 12685 : 79 buffers of 1585. 6 Large buffers of 792 : 54 XLarge buffers of 99. 1221 buffers free: 5544 hiAlloc buffers: 4323 current buffers. 3290 units of 40 bytes hiAlloc: 3289 units of 40 bytes hiCur. So in summary my advice would be make sure TSM is getting the cpu it needs Check your RMF or similar Ensure you are running MPthreading Have a look through ADSM.org (search region) regards, John Bill Kelly [EMAIL PROTECTED] on 02/13/2003 07:48:37 PM Please respond to Bill Kelly [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSE) Subject: Re: OS390 TSM Performance questions. Hi, We seem to be experiencing symptoms similar (identical?) to Alan's. We're at z/OS 1.2, running on a 2066-002 w/ 8GB of memory and virtually no paging; TSM is at 4.2.3.0.; database is 55% of 106 GB. Network connectivity is via GB ethernet. Disk pool is 190GB on an ESS. Nightly backup load is approximately 230 clients (a mix of desktops and servers), averaging in the 130-140GB range per night total. For some weeks now (I'm not sure when this started, but I know the problem was there at 4.2.2.10), we've been seeing horrible performance after TSM has been up for a few hours. For example, I can watch 3 migration processes that run along fine for a little while, each getting approx. 400 MB/min throughput, then suddenly CPU utilization by TSM shoots up to 95% and throughput on the migrations drops to approx. 50 MB/min per process. Stopping and restarting the processes does no good, but cycling the server clears up the problem. I'm certain this problem affects other server activities, such as client backups, storage pool backups, etc. Like Alan, I've been ratcheting up the region size (up to 1.5 GB) and the db bufferpool size (up to 384 MB) in a vain attempt to help matters. I recently resorted to cycling the server 4 times per day just to get the performance needed to keep up with things. Based on the comments in this thread, I last night changed our region size to 512 MB and db bufferpool size to 128 MB. Until now, I wasn't aware of the 'show memu' diagnostic command (thanks Alan/Mark! I finally have *something* to quantify directly); here's the output from our server: MAX initial storage 536870912 (512.0 MB) Freeheld bytes 63678 (0.1 MB) MaxQuickFree bytes 10390159 (9.9 MB) 83 Page buffers of 12683 : 0 buffers of 1585. 0 Large buffers of 792 : 1 XLarge buffers of 99. 68 buffers free: 134 hiAlloc buffers: 66 current buffers. 12 units of 56 bytes hiAlloc: 11 units of 88 bytes hiCur. So apparently I still have the 'tiny Freeheld' problem; I suspect strongly I had the same trouble at 1.5 GB region size. (I don't suppose the functions of and relationships among these buffer pools is documented anywhere? I haven't found anything in the list archives or at the support web site.) I wonder if there's a factor other than db bufferpool size and region size that's affecting these buffer pool allocations? I suspect that our server performance goes south once we run out of one/some type(s) of these buffers and the server starts GETMAINing/FREEMAINing itself to death? Lacking any further information, I plan to do some bouncing of our server this weekend to see if I can come up with a region and db bufpool combination that
Re: volume in volhistory as STGDELETE
That's one of the REALLY TERRIFIC features of the TSM server - Check the tapes back in as scratch and try to use them. TSM WONT LET YOU reuse them if there is still valid data on them! -Original Message- From: Conko, Steven [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 9:07 AM To: [EMAIL PROTECTED] Subject: volume in volhistory as STGDELETE quick question we've got some tapes in our vault that apparantly dont show up anywhere in tsm under the volume or libvolume listing. the only place i have been able to find information about them is in the volhistory table which shows they were placed into a STGDELETE state back in november 2002. again.. these tapes do not show up anywhere else... not in volumes, libvolumes, contents, drmedia or media. can i safely assume there is nothing on these tapes? this is version 4.2.2
Re: Mksysb directly into TSM 5.1
Well we got an email from our local dealer. Here is the info TSM for SBR version 5.5 apparantly it will support BMR on AIX plus all the other stuff. And quote FULL TSM intergration 1 Quarter 03 Contact your reseller for details. -Original Message- From: Lambelet,Rene,VEVEY,GL-CSC [mailto:[EMAIL PROTECTED]] Sent: Friday 14 February 2003 16:53 To: [EMAIL PROTECTED] Subject: Re: Mksysb directly into TSM 5.1 Clark, which version of sysback? it seems to me that last announced one is not able to interface to TSM... yours, René LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center Information Technology Av. Nestlé 55 CH-1800 Vevey (Switzerland) tél +41 (0)21 924 35 43 fax +41 (0)21 703 30 17 local UBS-Nestec, Bussigny mailto:[EMAIL PROTECTED] This message is intended only for the use of the addressee and may contain information that is privileged and confidential. -Original Message- From: Rodney clark [mailto:[EMAIL PROTECTED]] Sent: Friday,14. February 2003 16:27 To: [EMAIL PROTECTED] Subject: Re: Mksysb directly into TSM 5.1 It looks like the new version of sysback will be able to do this. At least thats what I read between the lines of the pre-informatie on the web. I would not waste my time with adsmpipe. -Original Message- From: Lambelet,Rene,VEVEY,GL-CSC [mailto:[EMAIL PROTECTED]] Sent: Friday 14 February 2003 15:04 To: [EMAIL PROTECTED] Subject: Mksysb directly into TSM 5.1 Hello, any idea to send mksysb directly to tsm 5.1 (AIX)? I've heard adsmpipe is not officialy supported, does anybody use named pipe to write their mksysb ? If yes, how do you read back form the file ? For now we use a NIM server and NFS, this is not optimum. Thanks a lot, René LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center Information Technology Av. Nestlé 55 CH-1800 Vevey (Switzerland) tél +41 (0)21 924 35 43 fax +41 (0)21 703 30 17 local UBS-Nestec, Bussigny mailto:[EMAIL PROTECTED] This message is intended only for the use of the addressee and may contain information that is privileged and confidential.
SELECTing from the CONTENTS table
We're attempting to extract file name and size information from the database with SELECT. It appears the data we want is in the CONTENTS table. The SELECT command takes an excessive amount of time to return when not using the table key, VOLUME_NAME. Is it possible to add an index to a TSM database table? How does the client (eg Windows) return active file information so quickly? thanks! Jay Jackson University of Buffalo [EMAIL PROTECTED]
Another Expiration question
Does anyone know the particulars on how expiration works. Normally we are run expiration with a time limit or 6 hours. When we ran it without the time limit it ran for 15 hours and never finished. Does expiration start reviewing the db from the beginning or is there some sort of flag set on where to start. I'm trying to figure out if we never let it run through completely will I ever get back all the data that has expired or not. Thanks for the help
Re: Mksysb directly into TSM 5.1
I'd like to play the devil's advocate for just a second and ask why NIM and NFS don't work? We have an SP and I use a NFS mounted directory from my CWS (NIM sever) to perform MKSYSBs of the nodes and it works just great. If your using NIM then the MKSYSB files have to be on your NIM server anyway. [EMAIL PROTECTED] 14-Feb-03 8:03:41 AM Hello, any idea to send mksysb directly to tsm 5.1 (AIX)? I've heard adsmpipe is not officialy supported, does anybody use named pipe to write their mksysb ? If yes, how do you read back form the file ? For now we use a NIM server and NFS, this is not optimum. Thanks a lot, René LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center Information Technology Av. Nestlé 55 CH-1800 Vevey (Switzerland) tél +41 (0)21 924 35 43 fax +41 (0)21 703 30 17 local UBS-Nestec, Bussigny mailto:[EMAIL PROTECTED] This message is intended only for the use of the addressee and may contain information that is privileged and confidential.
Re: Another Expiration question
I am not certain on the order in which filespaces are processed during expiration, but, from looking at the log of my expiration processing, it appears to go in node (or perhaps filespace) order, based on when they were added to TSM (certainly not alphabetical). Oldest node (or filespace) gets processed first, newest gets processed last. I am unaware if there is a flag indicating where you would like to start. I doubt there is, though. If you never let the expiration processing complete, you will never expire all of the files that can be expired. Hope this helps. |+ || Michael Raine | || Michael.Raine@ALL| || FIRST.COM| || Sent by: ADSM: | || Dist Stor Manager| || [EMAIL PROTECTED]| || EDU | ||| ||| || 02/14/2003 11:40 | || AM| || Please respond to | || ADSM: Dist Stor | || Manager | ||| |+ -| | | | To: [EMAIL PROTECTED] | | cc: | | Fax to: | | Subject: Another Expiration question | -| Does anyone know the particulars on how expiration works. Normally we are run expiration with a time limit or 6 hours. When we ran it without the time limit it ran for 15 hours and never finished. Does expiration start reviewing the db from the beginning or is there some sort of flag set on where to start. I'm trying to figure out if we never let it run through completely will I ever get back all the data that has expired or not. Thanks for the help
select, index, and active files
Hi All, I am posting this on behalf of my colleague. Thanks, Steve Roder, University at Buffalo HOD Service Coordinator VM Systems Programmer UNIX Systems Administrator (Solaris and AIX) TSM/ADSM Administrator ([EMAIL PROTECTED] | (716)645-3564) -- Forwarded message -- Date: Fri, 14 Feb 2003 11:59:48 -0500 From: Jackson, Jay [EMAIL PROTECTED] To: Roder, Steve [EMAIL PROTECTED] Subject: Listserv question We're attempting to extract file name and size information from the database with SELECT. It appears the data we want is in the CONTENTS table. The SELECT command takes an excessive amount of time to return when not using the table key, VOLUME_NAME. Is it possible to add an index to a TSM database table? How does the client (eg Windows) return active file information so quickly? thanks! Jay Jackson University of Buffalo [EMAIL PROTECTED]
Re: Another Expiration question
Does anyone know the particulars on how expiration works. There's information in the Admin Guide, and under the EXPIre Inventory entry in http://people.bu.edu/rbs/ADSM.QuickFacts . The process was recently discussed on ADSM-L, relative to Cancel Process vs. Cancel Expiration - also noted in QuickFacts. Richard Sims, BU
Re: When comes the supportTDP for Oracle 9.2.x.x
From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]] I have mentioned it here before, but nobody seems to bother: TDP for Oracle 2.2 is end of support after April 15th. What next? Uh...Tivoli Data Protection for Databases (Oracle) 5.1.5? Just a wild guess. :oP -- Mark Stapleton ([EMAIL PROTECTED])
Re: SELECTing from the CONTENTS table
How does the client (eg Windows) return active file information so quickly? You'll find many, many references to Select vs. client access to the TSM db in the ADSM-L archives. The gist of the matter is that Select is a virtualized convenience for us server administrators to look at the information in the database, whereas the client knows the inside scoop and can more directly go after the data. Select is much more generalized, and entails more overhead. Richard Sims, BU
Re: Undocumented TSM commands!!!
IBM's position on this subject is that these commands are intended for use ONLY at the direction of IBM Service or Development. Any other usage is unsupported, and therefore at your own risk. 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. Sias Dealy [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/14/2003 06:57 Please respond to hnre To: [EMAIL PROTECTED] cc: Subject:Re: Undocumented TSM commands!!! The show commands from Richard Simms web page: http://people.bu.edu/rbs/ADSM.QuickFacts Do not use wildcard with the show command, it will crash the TSM server. It happen to me. My 2 US Cents. Sias Get your own 800 number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag On, PAC Brion Arnaud ([EMAIL PROTECTED]) wrote: Hi C.R., You could try here : http://msgs.adsm.org/cgi- bin/get/adsm9809/116.html Or eventually, use the search fonction here : http://msgs.adsm.org/cgi-bin/get/adsm-current.html Richard Simms web page http://people.bu.edu/rbs/ADSM.QuickFacts would also be very usefull, concerning any *SM problem. My 2 (euro)cents ... Arnaud
expiration
Here, if expiration does not finish, next expire picks up where the last one left off. Tsm v4.2.0 solaris 2.8. Hope this helps. Gary Lee Senior Operating Systems Analyst Ball State University phone 765-285-1310
Re: SELECTing from the CONTENTS table
Richard - Thanks! I had suspected as much... Jay Jackson University of Buffalo [EMAIL PROTECTED] --On Friday, February 14, 2003, 2:00 PM -0500 Richard Sims [EMAIL PROTECTED] wrote: How does the client (eg Windows) return active file information so quickly? You'll find many, many references to Select vs. client access to the TSM db in the ADSM-L archives. The gist of the matter is that Select is a virtualized convenience for us server administrators to look at the information in the database, whereas the client knows the inside scoop and can more directly go after the data. Select is much more generalized, and entails more overhead. Richard Sims, BU
Re: Undocumented TSM commands!!!
I have not used all documented commands yet :-) ,I will try to find for you .. Cheers SD Chandrasekhar, C.R [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/14/2003 05:59 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Undocumented TSM commands!!! Hi All, Can any one help me in finding complete set of undocumented TSM commands or share with me if you have it, I was searching for these commands for a long time. Thanks, C.R.Chandrasekhar. Systems Executive. Tivoli Certified Consultant(TSM). TIMKEN Engineering Research - INDIA (P) Ltd., Bangalore. Phone No: 91-80-5536113 Ext:3032. Email:[EMAIL PROTECTED] ** This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not forward, copy, print, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. The Timken Company **
Re: Undocumented TSM commands!!!
** High Priority ** Chandra.check these. mani [EMAIL PROTECTED] 02/14/03 05:59AM Hi All, Can any one help me in finding complete set of undocumented TSM commands or share with me if you have it, I was searching for these commands for a long time. Thanks, C.R.Chandrasekhar. Systems Executive. Tivoli Certified Consultant(TSM). TIMKEN Engineering Research - INDIA (P) Ltd., Bangalore. Phone No: 91-80-5536113 Ext:3032. Email:[EMAIL PROTECTED] ** This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not forward, copy, print, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. The Timken Company ** + This electronic mail transmission contains information from Joy Mining Machinery which is confidential, and is intended only for the use of the proper addressee. If you are not the intended recipient, please notify us immediately at the return address on this transmission, or by telephone at (724) 779-4500, and delete this message and any attachments from your system. Unauthorized use, copying, disclosing, distributing, or taking any action in reliance on the contents of this transmission is strictly prohibited and may be unlawful. + Some other usefull show commands are: =20 SHow commands Unsupported commands to reveal various supplementary information. SHow Archives PolicySet NodeName Undocumented ADSM server command = to show archives for a given Node within a Policy Set. SHow BUFVars Undocumented ADSM server command to show database buffer pool global variables. SHow CART Undocumented ADSM server command to show Cart Info from mounted volumes. SHow CONFIG Undocumented ADSM server command to show Configuration. SHow CSVars Undocumented ADSM server command to show client schedule variables. SHow DBVars Undocumented ADSM server command to show database variables. SHow DEV Undocumented ADSM server command to show Server Development Team + Server Contributors. SHow DISK Undocumented ADSM server command to show DISKfiles datas. SHow LIBrary Undocumented ADSM server command to show=3D the status of the library and its drives Meaning of fields: busy=3D3D0 means the drive is not mounted or even acquired by ADSM. busy=3D3D1 should reflect ADSM using the drive (Query MOunt). But this could result from drive maintenance. Fix by trying 'cfgmgr' AIX command, or killing the lmcpd AIX process and then doing 'cfgmgr' or '/etc/lmcpd'. online=3D3D0 means the drive is offline. In Version 2, this will only be if the polled=3D3D1. In V3, you can update a drive to be offline, in which case the polled flag will be 0. polled=3D3D1 means that ADSM could not use the drive for one of three reasons: - The drive is loaded with a Non-ADSM volume (eg a cleaner cartridge, or a volume from the other ADSM server); - The drive is unavailable to the library manager (usually set this way by load/unload failures) - The drive cannot be opened (some other application has it open, or there's some connection problem, etc) polled=3D3D1 means the server is polling the drive every 30 seconds to see when the above three conditions all clear. (It also means that the online flag
Someone with a problem with an LTO, AIX 5.1 conn refused.
On this day someone submitted and issue about getting always connection refused with the LTO, and always timeout on the drive 1. This link could get responses to him... http://www-1.ibm.com/support/docview.wss?uid=ssg1S1001470aid=1
Please watch this short movie.....
http://www.theanswerto.com/whoswhoguide
Re: NpPeek : no data with journaling
I have seen this before. To correct it we stopped the journal service on the server. Paul chris rees wrote: Hi All Following on from the previous mails regarding journaling and pipes, thanks Pete, I am getting the following scenario on a win2k client, TSM client 5.1.5.2 The incremental starts and uses the journal. I then get loads of NpPeek : No data messages and the backup does not finish. The schedule has a status of missed but in the dsmsched.log the last lines are : 11-02-2003 23:46:50 --- SCHEDULEREC OBJECT BEGIN DAILY_INCR 11-02-2003 11-02-2003 23:46:51 Using journal for '\\etvdcrsfcs01\i$' Any ideas as to what I can do to stop this happening? What is the best way to recover from this? Should I stop journal service, start journal service and run a manual backup.? Thanks alot Chris _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus begin:vcard n:Bergh;Paul tel;fax: tel;work:518-928-9413 x-mozilla-html:FALSE org:Northwood Information Solutions version:2.1 email;internet:[EMAIL PROTECTED] title:President - Consultant adr;quoted-printable:;;17 Northwood Drive =0D=0A;Ballston Spa;New York;12020; note;quoted-printable:IBM Business Partner=0D=0ACertified for Tivoli Storage Manager=0D=0ASales and Installation Services fn:Paul Bergh end:vcard
Re: Please watch this short movie.....
I read just about every TSM mail in this list as they come in. Why do I do this even though it takes time out of a busy schedule? Because I either learn or refresh my mind on some TSM subject everyday. If I haven't already experienced a problem that comes up, I can pretty much count on having that same problem down the line or hopefully avoid it from learning something on this list. I really resent having to take the time to go to some salespersons web site to watch something that isn't even TSM related! This is one of the rudest things I have ever experienced on the web. Shannon Bach Madison Gas Electric Co. Operations Analyst - Data Center Services Office 608-252-7260 Fax 608-252-7098 e-mail [EMAIL PROTECTED]
Re: Please watch this short movie.....
truedat! Shannon Bach [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: ADSM: cc: Dist StorSubject: Re: Please watch this short movie. Manager [EMAIL PROTECTED] .EDU 02/14/2003 04:39 PM Please respond to ADSM: Dist Stor Manager I read just about every TSM mail in this list as they come in. Why do I do this even though it takes time out of a busy schedule? Because I either learn or refresh my mind on some TSM subject everyday. If I haven't already experienced a problem that comes up, I can pretty much count on having that same problem down the line or hopefully avoid it from learning something on this list. I really resent having to take the time to go to some salespersons web site to watch something that isn't even TSM related! This is one of the rudest things I have ever experienced on the web. Shannon Bach Madison Gas Electric Co. Operations Analyst - Data Center Services Office 608-252-7260 Fax 608-252-7098 e-mail [EMAIL PROTECTED]
Re: Please watch this short movie.....
What that person did is spamming. They need to talk to that person and let them know that this is illegal. It does waste ours and company time. David C. Pearson IS Production Support Analyst System Network Service Snohomish County PUD # 1 ole0.bmp Phone: 425.347.4420 Pager: 425.290.0944 FAX: 425.267.6380 E-mail: [EMAIL PROTECTED] -Original Message- From: Justin Bleistein [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 1:34 PM To: [EMAIL PROTECTED] Subject:Re: Please watch this short movie. truedat! Shannon Bach [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: ADSM: cc: Dist StorSubject: Re: Please watch this short movie. Manager [EMAIL PROTECTED] .EDU 02/14/2003 04:39 PM Please respond to ADSM: Dist Stor Manager I read just about every TSM mail in this list as they come in. Why do I do this even though it takes time out of a busy schedule? Because I either learn or refresh my mind on some TSM subject everyday. If I haven't already experienced a problem that comes up, I can pretty much count on having that same problem down the line or hopefully avoid it from learning something on this list. I really resent having to take the time to go to some salespersons web site to watch something that isn't even TSM related! This is one of the rudest things I have ever experienced on the web. Shannon Bach Madison Gas Electric Co. Operations Analyst - Data Center Services Office 608-252-7260 Fax 608-252-7098 e-mail [EMAIL PROTECTED] ole0.bmp
Re: OS390 TSM Performance questions.
Hello, Bill. I fully concur with your statement - i.e., that As has been pointed out..., unless you know how to interpret the numbers, they're just that - a bunch of numbers.. This tool (i.e. show memu SHORT) has a very limited and specific use. It is intended for internal use only by the TSM support staff and it is, simply put, not a formally supported tool. Also, as I indicated to Alan in a private discussion with him: if improperly used, it can emit a huge volume of output regarding memory allocation details in the server address space. Use it at YOUR own risk. With that said, however, it can be somewhat useful (at least, on the S/390 server platform) - as long the consumer of it fully understands their limitations in interpreting its content (and uses SHORT). I know only the following about this, and I only know it from a S/390-specific viewpoint. However, since the server is written in C, I would assume that (except for those specific pieces of it, if any, that are tailor-made for the S/390 platform) some or all (or none) of the information may pertain to any of the other platforms on which the TSM server runs. Here's what I understand (thanks to the TSM support staff with whom I have had the distinct pleasure of dealing over the past several years)... During initialization (at some point), the TSM server performs a GETMAIN to determine the size of the region in which it is running. For those of you who are interested and don't understand, the region parameter is used to govern/control/limit the size of addressable virtual storage for a given process (in our case, it's called an address space). This memory-related control point allows the MVS operating system (i.e., currently that's OS/390 and z/OS) to limit the use of virtual memory right up front and, thus, defines the maximum virtual storage available to the TSM server - in toto. I do not know how (or if) this is accomplished on any other platform. Upon determining the region available to it, the TSM server frees the storage obtained, thus, and uses 2% of that amount (just freed) for what show memu SHORT displays as MaxQuickFree. ...a little digression may be in order here... During its life, the TSM server must manage its use of memory as efficiently as possible, because inefficient memory management techniques can seriously degrade the performance of a busy TSM server and (as I have personally encountered with TSM on OS/390) unproductively consume CPU cycles with an inordinate amount of GETMAIN/FREEMAIN activity. Memory management design is an important consideration in any application, but it can be a particularly problematic issue for some C-language programs, and perhaps many of you understand this critical design issue even better than I (which ain't sayin' too much). Generally speaking, poorly designed algorithms in code and/or ill-configured heap and stack storage use can cause serious memory-related performance problems. I assume the intent of the TSM designers was to mitigate this problem with MaxQuickFree. MaxQuickFree is used as a threshold below which dynamically obtained memory will NOT be freed, thus, preventing the inefficient memory-thrashing that could occur if the thousands of tiny pieces of memory used by the server were continually obtained and released, over and over again. The point, here, is that the server uses MaxQuickFree (at least on the S/390 platform) to maintain internal control over at least this amount of the virtual storage footprint in which it runs, thus, removing any of the C and/or operating system-specific memory-management inefficiencies from the performance picture (at least for that portion/amount of memory applicable to MaxQuickFree). The server obtains the memory in question and carves it up as required to fulfill its memory needs throughout its lifetime. It just doesn't release memory it has acquired below the amount indicated by MaxQuickFree. It could be that, at times, the server will still engage in the thrashing to which I have alluded above. This will occur when the specific memory needs of the server simply do not fit the freeheld allocations that the server is maintaining, so dynamic memory needs may, never-the-less, still cause some inefficient memory management to occur. They may not fit because the memory initially allocated (up to the MaxQuickFree threshold) could consist (for example) mainly of 12682-byte, 1585-byte, and 792-byte buffers, whereas, the subsequent needs for memory might be composed of smaller-sized buffers. The memory allocated up to the point at which MaxQuickFree is reached is the memory (and the specifically allocated sizes) that will be held (i.e., not released) by the server. Not to open yet another can of worms, but this can be increased, by the way, if you really need to do so. I doubt you will ever need that, but if GETMAIN/FREEMAIN activity rises to a point where it does severely degrade performance AND you have some way of determining that it
Re: OS390 TSM Performance questions.
On Friday, Feb 14, 2003, at 19:44 Australia/Sydney, PAC Brion Arnaud wrote: Hi all, I followed your discussion with much interest, as I'm suffering from huge performance problem problem too. Unfortunately I'm not under OS390, but using AIX 4.3.3 : could someone tell me if there is some some trick like this one, that should be considered, when using this OS ? Is the system paging, by any chance? When we were running TSM on AIX, we needed to do the following to prevent the AIX file/VM cache from paging out TSM (as must be done on any SAP database server): /usr/samples/kernel/vmtune -p 5 -P 8 Another thing that annoys me : using show memu SHORT on my server (TSM 4.2.3.1) returns : ANR2000E Unknown command - SHOW MEMU Could it be that this command is only available for OS390 TSM version ? I'm guessing so. -- Paul Ripke Unix/OpenVMS/TSM/DBA 101 reasons why you can't find your Sysadmin: 68: It's 9AM. He/She is not working that late. -- Koos van den Hout
