Re: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM system...is it possible ??
Hi Dave, If both servers are using the same kind of tapes, you could use export node - import node procedure ! Another possible way doing this would be using server to server communication, but that implies lots of work just for restoring a node ... My 2 cents ! Cheers. 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: Dave Myers [mailto:[EMAIL PROTECTED]] Sent: Thursday, 06 February, 2003 23:59 To: [EMAIL PROTECTED] Subject: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM system...is it possible ?? Customer asked me if I could recover (restore) the data from an OS/390 ADSM tape using another ADSM system that does not know anything about this tape Is this possible??? I have access to ADSM and TSM on both os/390 2.10 and z/os 1.4 Tia Dave
Re: Multiple Emails from this group
I have the same problem too. It started this morning. -Original Message- From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]] Sent: 07 February 2003 06:20 To: [EMAIL PROTECTED] Subject: Re: Multiple Emails from this group Strange, not me. Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154 -Original Message- From: Jeff G Kloek [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 4:33 PM To: [EMAIL PROTECTED] Subject: Multiple Emails from this group I am receiving tons of empty emails addressed from [EMAIL PROTECTED]. Is anyone else? The subject is simply Re:, and there is no text. Thanks. The contents of this email message and any attachments relating to the official business of Nedbank Limited (Nedbank) are proprietary to Nedbank. They are confidential, legally privileged and protected by law. Nedbank does not own nor endorse any other contents. Views and opinions are those of the sender and do not represent Nedbank's views and opinions nor constitute any commitment by or obligation on Nedbank unless otherwise stated or agreed to in writing by Nedbank. The person addressed in this email message is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the contents in any way. Nedbank cannot assure that the integrity of this communication has been maintained, nor that it is free of errors, viruses, interception or interference. Nedbank, therefore, does not accept liability or legal responsibility for the contents of this email message or its effect on electronic devices.
Re: Multiple Emails from this group
I have received about 6 blank emails so far all addressed the same. Anyone know why?? Thanks, Jason -Original Message- From: Jeff G Kloek [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 12:33 AM To: [EMAIL PROTECTED] Subject:Multiple Emails from this group I am receiving tons of empty emails addressed from [EMAIL PROTECTED]. Is anyone else? The subject is simply Re:, and there is no text. Thanks. ** 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 has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **
Re: LTO 3583 Drive errors with TSM 5.1.5.2 on AIX 5.1
Jose, The redbook is dated 14.12.2000 and I cannot recall when 6228 went out. It either was brand new or was not available. Thus was not cited in the redbook. But you are absolutely correct - it applies to both 6227 and 6228 adapters (in fact last installations I make are on 6228's :-). Zlatko Krastev IT Consultant Rivera, Jose Spri [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 06.02.2003 15:41 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: LTO 3583 Drive errors with TSM 5.1.5.2 on AIX 5.1 This is an interesting one - Also applies to FC6228 http://www-1.ibm.com/servers/eserver/pseries/library/hardware_docs/sa23/2325 50.pdf pg 24 Will try on new tsm server Thanks Zlatko Jose Rivera Ris Infrastructure 908-298-3568 1-800-PAGE-MCI#1376812 -Original Message- From: Zlatko Krastev/ACIT [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 1:59 AM To: [EMAIL PROTECTED] Subject: Re: LTO 3583 Drive errors with TSM 5.1.5.2 on AIX 5.1 Henry, sorry for delayed answer (have been on a training and was unable to read all mail on time). As expected you did not changed the adapter (to handle larger blocks for tape operations). Look at max_xfer_size parameter - it has to be changed to 0x100 (one zero more, in decimal from 1 MB to 16 MB). This is NOT described in any of TSM's manuals :-(( It can be found as Important note on p.52 in redbook Using TSM in SAN Environment (SG24-6132-00), Chapter 3 Building a SAN Environment, section 3.1.1. RS/6000. Zlatko Krastev IT Consultant Henrry Aranda [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 29.01.2003 23:01 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: LTO 3583 Drive errors with TSM 5.1.5.2 on AIX 5.1 Zlatko No, I did not changed any settings for the FC HBA. The output of the AIX command lsattr -El fcsN are the following: - For fcs0 bus_intr_lvl 20 Bus interruptlevel False intr_priority 3 Interrupt priority False bus_io_addr 0x2ec00Bus I/O addressFalse bus_mem_addr 0xc802 Bus memory address False lg_term_dma 0x20 N/ATrue max_xfer_size 0x10 Maximum Transfer Size True num_cmd_elems 200Maximum number of COMMANDS to queue to the adapter True pref_alpa 0x1Preferred AL_PATrue sw_fc_class 2 FC Class for FabricTrue init_link al INIT Link flagsTrue - For fcs1 ... max_xfer_size 0x10 Maximum Transfer Size True ... * This message and any attachments is solely for the intended recipient. If you are not the intended recipient, disclosure, copying, use or distribution of the information included in this message is prohibited -- Please immediately and permanently delete.
MSG. ACO5060E
Hi, I have a problem restoring from one SQLServer 7.0 to another SQLServer 2000. I get this error: Message ACO5060E A Tivoli Storage Manager API error has occurred. TDP SQL Agent is 2.2.1 on both machines, TSMServer OS390/5.1.5.0 Regards David
Re: Sun Solaris server backups not ending
I would get the solaris people to check and really make sure the adapater is really not on autonegotiate. -Original Message- From: Stapleton, Mark [mailto:[EMAIL PROTECTED]] Sent: Thursday 6 February 2003 00:05 To: [EMAIL PROTECTED] Subject: Re: Sun Solaris server backups not ending From: Joni Moyer [mailto:[EMAIL PROTECTED]] I have a SUN server Client Version 4.2.1, Client OS level 5.8 on TSM 4.1.3 os/390. My problem is that for a regularly scheduled client backup, the sessions start, but they just sit in idlew/recvw status. It is just backing up about 3 GB of data, but it is taking hours to complete when it usually ends in 15 minutes. I checked to make sure that the disk pool wasn't full and nothing else seemed out of the ordinary. It sounds like it might be a network communication issue. Have you checked the integrity of the connection between the TSM server and the TSM client? Do any other TSM clients of these same issues? Is the TSM client particularly busy with another process? This is all pretty basic troubleshooting that should be done every time there are apparent lags (as idlew and recw indicate). -- Mark Stapleton ([EMAIL PROTECTED])
3584 - SCSI-ID vs. Loop-ID - Sun Solaris
Hi everybody! One short question for those who are experienced with Sun Solaris-Systems and FibreChannel addressing. Can anybody tell me how can I access the FibreDrives in an 3584 Library? The following things we have done until now: - we enabled persistent bindung in 'lpfc.conf' (as you can see we are using Emulex) - we defined the tapes in 'st.conf' (because the application (Legato - I'm sorry) does not use the IBMtape-Driver there's no need for IBMtape.conf). == '/var/adm/messages' shows that Solaris finds the WWNs/drives/controlpaths. That far is ok. But did I configure the 'st.conf' right? Can I use any combination of Target ID and WWN in the st.conf? E.g.: target 0 for WWN 5005. and so on or must I link the WWN for the first tape in the first frame with target 0 and so on. Because the addressing seems only to happen via the Loop-ID I am really confused. So: how do I map the loop-ID of the drives to the appropriate SCSI-ID a Sun system can use? Thanx in advance. - Mit freundlichen Grüssen / with regards Karsten Hüttmann -- Karsten Hüttmann c.a.r.u.s. Information Technology AG Advanced System Center Bornbarch 9, 22848 Norderstedt, Germany E-Mail: [EMAIL PROTECTED] Firma: +49.40.51435.3231 Mobil: +49.171.7634388 Fax: +49.40.51435.
Re: Discrepancy between select * from summary and dsmaccnt.log
Maybe I'm wrong but accounting records are for server resources that are used during a session (Admin Giude - chapter19 - Monitoring TSM Accounting Records). So, if the client is using more than one backup session on the server (resourseutilization2), you will have more than one record in the accounting log for that client backup, e.g. for each session. While in the Summary table is written only one record for the same backup. Maria Ilieva ---Original Message--- From: Peter Duempert Date: 06 Ôåâðóàðè 2003 17:46:10 To: [EMAIL PROTECTED] Subject: Discrepancy between select * from summary and dsmaccnt.log Hi *SM'ers, 1. if I run e.g. dsmadmc -comma select * from SUMMARY where activity='BACKUP' and entity='GIVEN_NODE' and start_time'2003-02-05 20:30:00' and end_time'2003-02-06 20:30:00' I obtain the # of BACKUPs (num_bkup) for the GIVEN_NODE during the given time-interval ( i.e. 1 day ) 2. if I take the corresponding records written into dsmaccnt.log for the GIVEN_NODE in the same time-interval with a NON-ZERO-field-17 ( i.e. Amount of backup files, in kilobytes, ..., see Tivoli Storage Manager for AIX, Version 5, Rel 1, page 428) I obtain another #, say num_acnt. My assumption was these 2 numbers should be equal. BUT I've cases in which num_bkup=1017 and num_acnt=1644 for the same node in the same time-period, i.e. they differ significantly. Generally I found that num_bkup num_acnt Only in rare cases I found num_bkup = num_acnt Questions: 1. Is my assumption correct that these 2 #-s should be identical ? 2. has anyone else experienced such a behaviour ? -- MfG / Ciao - - - - - - - - - - - - - - - - - - - - - - - - - - - - Peter Dümpert Email: [EMAIL PROTECTED] Rechenzentrum der Technischen Universität Fax : ++49/531/391-5549 D 38092 Braunschweig Tel : ++49/531/391-5535 . IMSTP.gif
Re: TSM for Oracle
Agreed, but it's a bit silly to backup 200 gbyte of historical database every day. When a incremental backup in RMAN might send 10 Mbyte per day. Extreme example yes, But I think RMAN is really worth the effort. -Original Message- From: Stef Coene [mailto:[EMAIL PROTECTED]] Sent: Thursday 6 February 2003 20:48 To: [EMAIL PROTECTED] Subject: Re: TSM for Oracle On Thursday 06 February 2003 19:41, Hart, Charles wrote: Our management thinks we should switch to Veritas because It's easier to Implement, your management doesn't seem to understand that the RMAN piece is probably the most complicated piece of and DB backup. Why using the tdp? Put the database in archive mode. Put each tablespace in backup mode, backup the database files, disable backup mode. alter tablespace ... begin backup (in prebackup command) dsm incr ... alter tablespace ... end backup (in postbackup command) No rman troubles, no tdp to buy, ... And it works flawless. Stef -- [EMAIL PROTECTED] Using Linux as bandwidth manager http://www.docum.org/ #lartc @ irc.oftc.net
Performance problem
Hoi Can someone help me with this. TSM Server 4.2.2.12 Sun Solaris 8 (E450) BA Client 4.2.1.0 Connect thru Fast ethernet. Sometimes time the backup takes hours to complete. Yesterday Tivoli Storage Manager Version 4, Release 2, Level 1.0 -- Final Detailed Instrumentation statistics Elapsed time: 22013.450 sec Section Total Time(sec) Average Time(msec) Frequency used -- Client Setup0.459 459.3 1 Process Dirs 784.543 60.3 13020 Solve Tree 0.0000.0 0 Compute17.6050.02378504 Transaction 119.3150.07271635 BeginTxn Verb 0.0140.0963 File I/O 2150.9210.92499558 Compression 0.0000.0 0 Encryption 0.0000.0 0 Delta 0.0000.0 0 Data Verb6582.8962.82378504 Confirm Verb3.148 25.2125 EndTxn Verb 13139.73613644.6963 Client Cleanup 1.345 1345.4 1 -- Today Tivoli Storage Manager Version 4, Release 2, Level 1.0 -- Final Detailed Instrumentation statistics Elapsed time: 28370.683 sec Section Total Time(sec) Average Time(msec) Frequency used -- Client Setup0.310 310.0 1 Process Dirs 805.894 61.9 13021 Solve Tree 0.0000.0 0 Compute 8.7680.01263556 Transaction 103.7000.03926255 BeginTxn Verb 0.0110.0708 File I/O 2565.0361.91384594 Compression 0.0000.0 0 Encryption 0.0000.0 0 Delta 0.0000.0 0 Data Verb5483.5214.31263556 Confirm Verb2.878 24.6117 EndTxn Verb 20212.19328548.3708 Client Cleanup 1.080 1079.8 1 -- What is EndTxn Verb? It takes 50% of the clients time. tsm: ADSMq db f=d Available Space (MB): 18,000 Assigned Capacity (MB): 18,000 Maximum Extension (MB): 0 Maximum Reduction (MB): 9,944 Page Size (bytes): 4,096 Total Usable Pages: 4,608,000 Used Pages: 2,058,256 Pct Util: 44.7 Max. Pct Util: 44.7 Physical Volumes: 2 Buffer Pool Pages: 32,768 Total Buffer Requests: 130,231,713 Cache Hit Pct.: 98.25 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 0.09 Percentage Changed: 0.00 Last Complete Backup Date/Time: 02/07/2003 09:45:03 There is no waiting and the cache hit is ok. tsm: ADSMq log f=d Available Space (MB): 2,072 Assigned Capacity (MB): 2,072 Maximum Extension (MB): 0 Maximum Reduction (MB): 2,068 Page Size (bytes): 4,096 Total Usable Pages: 529,920 Used Pages: 54 Pct Util: 0.0 Max. Pct Util: 10.2 Physical Volumes: 2 Log Pool Pages: 512 Log Pool Pct. Util: 0.62 Log Pool Pct. Wait: 0.00 Cumulative Consumption (MB): 626,585.08 Consumption Reset Date/Time: 03/06/2002 10:40:02 Even log wait is 0. Can someone help me with this? Thanks / (o o) ==oOO==(_)==OOo== Miguel Demaerel System Engineer Schlumberger Raketstraat 98, B-1130 Brussels, Belgium Tel +32 (0)2 724 93 17 Fax +32 (0)2 724 92 92 Email [EMAIL PROTECTED] =
SQL problem ....
Hi list, Could any SQL genius explain me wat is wrong with this statement : select sum(physical_mb) from occupancy where stgpool_name='TAPELTO1_WIN' - (select sum(physical_mb) from occupancy where stgpool_name='COPYLTO1_WIN' ) When trying to use it II get following output : ANR2916E The SQL data types CHAR(12) and DECIMAL(31,2) are incompatible for operator '-'. I already tried to add dec() on both selects without achieving any valuable result ... is it a bug or do I need additional coffee to wake up my mind ? What I'm trying to achieve is to calculate the remaining amount of data to copy before a backup stgpool process finishes. Thanks in advance ! Cheers. 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 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
summary-table
Hi all, since installing the 4.2.3.2 level (after 4.1.4) on my AIX-server (AIX 4.3.3) I have the problem that in the summary-table the field BYTES for a backup-session of NT and W2K-clients is filled with 0 even though the client has transfered GigaBytes of data. Restore-sessions of the same client show a correct number of bytes in that field. Unix-Clients show (what I have seen) correct entries in that field. Thanks for help Chris
Re: TSM for Oracle
On Friday, Feb 7, 2003, at 20:37 Australia/Sydney, Rodney clark wrote: Agreed, but it's a bit silly to backup 200 gbyte of historical database every day. When a incremental backup in RMAN might send 10 Mbyte per day. Extreme example yes, But I think RMAN is really worth the effort. So why not just backup the archive logs every other day as an incremental? The way we do it is to use dsmc arch to archive the database once a week, and just do the archive logs every day. Then, restores are just point-in-time Oracle recoveries. Maybe not good for a database with a high change rate, but good for historical databases. Cheers, -- Paul Ripke Unix/OpenVMS/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
Re: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM system...is it possible ??
Dave You could also use backupsets. which can be defined in and are then available to the new system If you have a test system you could try restoring the database from the old system, so your test system knows about the backup tapes, then restore to your new client, and your new client can then be registered to your other system and can be backed up afresh. Hmm!! backupsets are probably simpler especially if you have cross system tape access. I have done both the above a while ago, so they do work John PAC Brion Arnaud [EMAIL PROTECTED] on 02/07/2003 08:41:56 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSE) Subject: Re: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM system...is it possible ?? ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. ** Hi Dave, If both servers are using the same kind of tapes, you could use export node - import node procedure ! Another possible way doing this would be using server to server communication, but that implies lots of work just for restoring a node ... My 2 cents ! Cheers. 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: Dave Myers [mailto:[EMAIL PROTECTED]] Sent: Thursday, 06 February, 2003 23:59 To: [EMAIL PROTECTED] Subject: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM system...is it possible ?? Customer asked me if I could recover (restore) the data from an OS/390 ADSM tape using another ADSM system that does not know anything about this tape Is this possible??? I have access to ADSM and TSM on both os/390 2.10 and z/os 1.4 Tia Dave
Re: END EVENTLOGGING.
Do you use netview event logging for good and useful purposes If you do then say to the auditors that you can do what they ask, if they can provide an alternative mechanism for doing your good and useful purposes. If you do not use it then your os390 sysprog can remove the anr messages from your SYS1.PARMLIB(MPFLST**) member. The line might be ANR*,AUTO(YES) This should be good enough as access to SYS1.PARMLIB should be strictly controlled and audit should be able to trace any updates to it. Brian L. Nick [EMAIL PROTECTED] on 02/06/2003 02:24:27 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSE) Subject: END EVENTLOGGING. Good Morning, In their ultimate wisdom our corporate audit department has decided that we need to stop our NETVIEW active receiver. I know that I can end the NETVIEW receiver using the end event logging command but is there a way to permanently remove this receiver? I know that this is a bit odd but audit knows best.. Any information that anyone can provide is appreciated. Thanks, Brian Brian L. Nick Systems Technician - Storage Solutions The Phoenix Companies Inc. 100 Bright Meadow Blvd Enfield CT. 06082-1900 E-MAIL: [EMAIL PROTECTED] PHONE: (860)403-2281 ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **
Re: Multiple Emails from this group
I've got a lot more than 6!! Martha-- are you still the list owner I hope you still are. Would you see if there is a problem somewhere? thanks lisa Jason Stoessler Jason.Stoessler@KINGSW To: [EMAIL PROTECTED] ELL.CO.UKcc: Sent by: ADSM: Dist Subject: Re: Multiple Emails from this group Stor Manager [EMAIL PROTECTED] 02/07/2003 02:46 AM Please respond to ADSM: Dist Stor Manager I have received about 6 blank emails so far all addressed the same. Anyone know why?? Thanks, Jason -Original Message- From: Jeff G Kloek [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 12:33 AM To: [EMAIL PROTECTED] Subject:Multiple Emails from this group I am receiving tons of empty emails addressed from [EMAIL PROTECTED]. Is anyone else? The subject is simply Re:, and there is no text. Thanks. ** 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 has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **
Re: Performance problem
What is EndTxn Verb? It takes 50% of the clients time. - it indicates the end-transaction verb time on the server.that is the time it takes to close the transaction.the fact that in the trace Data Verb is high as well points to a problem on the server. Cache Hit Pct.: 98.25 we'd like to see this figure 99%. the fact that you are running the server on solaris and the DB is only made up of 2 physical volumes would seem the place to start with. you should, if you haven't done so already, move the db volumes to Raw Logical Volumes and create more volumes as this will improve performance. Cordiali saluti Gianluca Mariani Tivoli TSM Global Response Team, Roma Via Sciangai 53, Roma phones : +39(0)659664598 +393351270554 (mobile) [EMAIL PROTECTED] The Hitch Hiker's Guide to the Galaxy says of the Sirius Cybernetics Corporation product that it is very easy to be blinded to the essential uselessness of them by the sense of achievement you get from getting them to work at all. In other words ? and this is the rock solid principle on which the whole of the Corporation's Galaxy-wide success is founded -their fundamental design flaws are completely hidden by their superficial design flaws... Miguel Demaerel Miguel.Demaere [EMAIL PROTECTED]To .SLB.COM [EMAIL PROTECTED] Sent by: ADSM:cc Dist Stor Manager bcc [EMAIL PROTECTED] ST.EDU Subject Performance problem 07/02/2003 10.40 Please respond to ADSM: Dist Stor Manager Hoi Can someone help me with this. TSM Server 4.2.2.12 Sun Solaris 8 (E450) BA Client 4.2.1.0 Connect thru Fast ethernet. Sometimes time the backup takes hours to complete. Yesterday Tivoli Storage Manager Version 4, Release 2, Level 1.0 -- Final Detailed Instrumentation statistics Elapsed time: 22013.450 sec Section Total Time(sec) Average Time(msec) Frequency used -- Client Setup0.459 459.3 1 Process Dirs 784.543 60.3 13020 Solve Tree 0.0000.0 0 Compute17.6050.02378504 Transaction 119.3150.07271635 BeginTxn Verb 0.0140.0963 File I/O 2150.9210.92499558 Compression 0.0000.0 0 Encryption 0.0000.0 0 Delta 0.0000.0 0 Data Verb6582.8962.82378504 Confirm Verb3.148 25.2125 EndTxn Verb 13139.73613644.6963 Client Cleanup 1.345 1345.4 1 -- Today Tivoli Storage Manager Version 4, Release 2, Level 1.0 -- Final Detailed Instrumentation statistics Elapsed time: 28370.683 sec Section Total Time(sec) Average Time(msec) Frequency used -- Client Setup0.310 310.0 1 Process Dirs 805.894 61.9 13021 Solve Tree 0.0000.0 0 Compute 8.7680.01263556 Transaction 103.7000.03926255 BeginTxn Verb 0.0110.0708 File I/O 2565.036
Re: Multiple Emails from this group
Yes, please do. I have literally hundreds. They come in continually. Thanks!! Lisa Cabanas [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: ADSM: Subject: Re: Multiple Emails from this group Dist Stor Manager [EMAIL PROTECTED] .EDU 02/07/2003 06:47 AM Please respond to ADSM: Dist Stor Manager I've got a lot more than 6!! Martha-- are you still the list owner I hope you still are. Would you see if there is a problem somewhere? thanks lisa Jason Stoessler Jason.Stoessler@KINGSW To: [EMAIL PROTECTED] ELL.CO.UKcc: Sent by: ADSM: Dist Subject: Re: Multiple Emails from this group Stor Manager [EMAIL PROTECTED] 02/07/2003 02:46 AM Please respond to ADSM: Dist Stor Manager I have received about 6 blank emails so far all addressed the same. Anyone know why?? Thanks, Jason -Original Message- From: Jeff G Kloek [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 12:33 AM To: [EMAIL PROTECTED] Subject:Multiple Emails from this group I am receiving tons of empty emails addressed from [EMAIL PROTECTED]. Is anyone else? The subject is simply Re:, and there is no text. Thanks. ** 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 has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **
Re: summary-table
From: Christoph Pilgram since installing the 4.2.3.2 level (after 4.1.4) on my AIX-server (AIX 4.3.3) I have the problem that in the summary-table the field BYTES for a backup-session of NT and W2K-clients is filled with 0 even though the client has transfered GigaBytes of data. Restore-sessions of the same client show a correct number of bytes in that field. Unix-Clients show (what I have seen) correct entries in that field. As has been commented recently (and repeatedly in past months), the summary table is a notoriously dubious source of information. *I* wouldn't use it for any meaningful analysis. -- Mark Stapleton ([EMAIL PROTECTED])
Re: Sun Solaris server backups not ending
There are several ways of changing the default settings and force full-duplex mode; you may need to alter your switch settings as well. Setting through /etc/system set hme:hme_adv_autoneg_cap=0 set hme:hme_adv_100hdx_cap=0 set hme:hme_adv_100fdx_cap=1 Setting with ndd ndd -set /dev/hme adv_autoneg_cap 0 ndd -set /dev/hme adv_100hdx_cap 0 ndd -set /dev/hme adv_100fdx_cap 1 In case you have multiple instances, you need to select the specific hme instance first, e.g., use the following to select hme1: ndd -set /dev/hme instance 1 Thank You Shekhar Dhotre. Seay, Paul [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 01:08 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: Sun Solaris server backups not ending Your ethernet adapter in the SUN machine probably took the default of AUTO and is trying to continually negotiate with the switch. Change it to Full or half as appropriate and the problem will go away. Seen this time and time again. Paul D. Seay, Jr. Technical Specialist Northrop Grumman Information Technology 757-688-8180 -Original Message- From: Joni Moyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 1:38 PM To: [EMAIL PROTECTED] Subject: Sun Solaris server backups not ending Hello again! I have a SUN server Client Version 4.2.1, Client OS level 5.8 on TSM 4.1.3 os/390. My problem is that for a regularly scheduled client backup, the sessions start, but they just sit in idlew/recvw status. It is just backing up about 3 GB of data, but it is taking hours to complete when it usually ends in 15 minutes. I checked to make sure that the disk pool wasn't full and nothing else seemed out of the ordinary. Has anyone had this problem? Any suggestions on what to look at? Thank you! Joni Moyer Systems Programmer [EMAIL PROTECTED] (717)975-8338
Re: Multiple Emails from this group
I also got nine completely empty (except complains added by my mail server). No headers, empty body, empty subject (actually missing as all other headers). People with Re:-only at least got something :-) Zlatko Krastev IT Consultant Jason Stoessler [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 07.02.2003 10:46 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: Multiple Emails from this group I have received about 6 blank emails so far all addressed the same. Anyone know why?? Thanks, Jason -Original Message- From: Jeff G Kloek [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 12:33 AM To: [EMAIL PROTECTED] Subject:Multiple Emails from this group I am receiving tons of empty emails addressed from [EMAIL PROTECTED]. Is anyone else? The subject is simply Re:, and there is no text. Thanks. ** 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 has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **
Re: Multiple Emails from this group
i've gotten about 10 or so emails with the same complaintsonly the senders names where different ;-) -Original Message- From: Zlatko Krastev/ACIT [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 2:59 PM To: [EMAIL PROTECTED] Subject: Re: Multiple Emails from this group I also got nine completely empty (except complains added by my mail server). No headers, empty body, empty subject (actually missing as all other headers). People with Re:-only at least got something :-) Zlatko Krastev IT Consultant Jason Stoessler [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 07.02.2003 10:46 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: Multiple Emails from this group I have received about 6 blank emails so far all addressed the same. Anyone know why?? Thanks, Jason -Original Message- From: Jeff G Kloek [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 12:33 AM To: [EMAIL PROTECTED] Subject:Multiple Emails from this group I am receiving tons of empty emails addressed from [EMAIL PROTECTED]. Is anyone else? The subject is simply Re:, and there is no text. Thanks. ** 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 has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **
Re: Need advice on dealing with unreadable tape
At 4:20 PM -0600 2/6/03, Julian Armendariz wrote: You will have to specify which copypool to get the files from. restore v 000345 copy=name_of_copypool p=y According to the manual, copypool is optional, and if not specified, files are restored from any copy pool in which copies can be located. But, since the manual is occasionally wrong, I tried specifiying copypool. It didn't help. Someone else suggested maybe the access on the original tape needed to be changed to destroyed. I tried that. It didn't help. At 5:35 PM -0500 2/6/03, Prather, Wanda wrote: could be there was a problem reading the 2 bad files at the time it was trying to create the copy pool copy. That's what I was thinking. if you purge the DB entries for the bad files, TSM will back them up on the next go around, assuming they still exist on the client. And if they don't still exist on the client, I'll just hope that the user doesn't change his mind and decide he needs them back. I'll do the audit and let it delete the entries. Thanks for the advice. -- Matt Simpson -- OS/390 Support 219 McVey Hall -- (859) 257-2900 x300 University Of Kentucky, Lexington, KY 40506 mailto:[EMAIL PROTECTED] mainframe -- An obsolete device still used by thousands of obsolete companies serving billions of obsolete customers and making huge obsolete profits for their obsolete shareholders. And this year's run twice as fast as last year's.
PMR 02528, 082
Does any TSM gurus have any suggestions for our AIX admin Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD - Forwarded by Bill Rosette/IS/Corporate/Papa Johns on 02/07/2003 09:20 AM - Steven Schraer To: [EMAIL PROTECTED] 02/06/2003 05:09 cc: Bill Rosette/IS/Corporate/Papa Johns PM Subject: PMR 02528, 082 We are having some problems with the first link below. The second is working. I have been looking at the Redbook. Gettting started with Tivoli Storaage Manger: Implementation Guide. It looks like for storage pools are recommend for raid 0 (mirroring), raid 0+1 (mirroring stripping) or raid 5 (distributed parity). These are safe methods to protect the storage pool. Do you know of any companies that use just raid 1 (stripping) on their storage pools? Is there an issue of tsm loosing a storage pool and the database having issues due to the lost storage pool data? Also there is no suggested raid for the tsm database. Since we mirror the tsm database with the tsm software, can we use raid 1 (stripping) so that we can get a performance increase on accessing the database? Or should we just create the volume group with no raiding but lay the database over multiple smaller disk (i.e. use eight 18.2 Gig disk instead of 4 36.4 Gig disk). What will give us the best performance. Can I get an answer on this tomorrow morning. I have a meeting to discuss the performance issues tomorrow (Feb 7, 2002). Thanks for your assistance! Steven M. Schraer 502-261-4148 - Forwarded by Steven Schraer/IS/Corporate/Papa Johns on 02/06/2003 04:57 PM - Bill Rosette To: Steven Schraer/IS/Corporate/Papa Johns@Papa Johns 02/06/2003 03:51 cc: PM Subject: PMR 02528, 082 Could not get into the link below. Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD - Forwarded by Bill Rosette/IS/Corporate/Papa Johns on 02/06/2003 03:53 PM - Stephen Hull [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Subject: PMR 02/06/2003 03:36 PM Hi Bill, Here is a link to the Performance Tuning Guide on the web: ftp://w3.ibm.com/support/ats/documents/TSM42PDG.pdf Regards, Stephen Hull IBM Tivoli Storage Manager Support More questions? Search our new TSM KnowledgeBase at: http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html
SV: MSG. ACO5060E
Hi Mark, The problem occurs when I try to connect to the server, even before it knows which version of database to restore from. Thanks, David -Oprindelig meddelelse- Fra: Stapleton, Mark [mailto:[EMAIL PROTECTED]] Sendt: 7. februar 2003 14:51 Til: [EMAIL PROTECTED] Emne: Re: MSG. ACO5060E From: David Fainburg [mailto:[EMAIL PROTECTED]] I have a problem restoring from one SQLServer 7.0 to another SQLServer 2000. I get this error: Message ACO5060E A Tivoli Storage Manager API error has occurred. TDP SQL Agent is 2.2.1 on both machines, TSMServer OS390/5.1.5.0 I would rather suspect that MS-SQL2K doesn't appreciate having a version 7 database dumped into it. You'd probably be much better off restoring the file to a verison 7 installation, and then moving it to SQL2K. -- Mark Stapleton ([EMAIL PROTECTED])
Re: PMR 02528, 082
We use to use journaled mirrored file systems, but found that Raw Mirrored local provides us better I/O, now we are using Raw volumes on EMC Disk for stgpools which works even better because the disk is mirrored on the back end of the EMC Symetrix. -Original Message- From: William Rosette [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 8:19 AM To: [EMAIL PROTECTED] Subject: PMR 02528, 082 Does any TSM gurus have any suggestions for our AIX admin Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD - Forwarded by Bill Rosette/IS/Corporate/Papa Johns on 02/07/2003 09:20 AM - Steven Schraer To: [EMAIL PROTECTED] 02/06/2003 05:09 cc: Bill Rosette/IS/Corporate/Papa Johns PM Subject: PMR 02528, 082 We are having some problems with the first link below. The second is working. I have been looking at the Redbook. Gettting started with Tivoli Storaage Manger: Implementation Guide. It looks like for storage pools are recommend for raid 0 (mirroring), raid 0+1 (mirroring stripping) or raid 5 (distributed parity). These are safe methods to protect the storage pool. Do you know of any companies that use just raid 1 (stripping) on their storage pools? Is there an issue of tsm loosing a storage pool and the database having issues due to the lost storage pool data? Also there is no suggested raid for the tsm database. Since we mirror the tsm database with the tsm software, can we use raid 1 (stripping) so that we can get a performance increase on accessing the database? Or should we just create the volume group with no raiding but lay the database over multiple smaller disk (i.e. use eight 18.2 Gig disk instead of 4 36.4 Gig disk). What will give us the best performance. Can I get an answer on this tomorrow morning. I have a meeting to discuss the performance issues tomorrow (Feb 7, 2002). Thanks for your assistance! Steven M. Schraer 502-261-4148 - Forwarded by Steven Schraer/IS/Corporate/Papa Johns on 02/06/2003 04:57 PM - Bill Rosette To: Steven Schraer/IS/Corporate/Papa Johns@Papa Johns 02/06/2003 03:51 cc: PM Subject: PMR 02528, 082 Could not get into the link below. Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD - Forwarded by Bill Rosette/IS/Corporate/Papa Johns on 02/06/2003 03:53 PM - Stephen Hull [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Subject: PMR 02/06/2003 03:36 PM Hi Bill, Here is a link to the Performance Tuning Guide on the web: ftp://w3.ibm.com/support/ats/documents/TSM42PDG.pdf Regards, Stephen Hull IBM Tivoli Storage Manager Support More questions? Search our new TSM KnowledgeBase at: http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html
Re: how to stop mail??
Haven't you got this one: Your subscription to the ADSM-L list (ADSM: Dist Stor Manager) has been accepted. ... many lines of description of list features and functions ... More information on LISTSERV commands can be found in the LISTSERV reference card, which you can retrieve by sending an INFO REFCARD command to [EMAIL PROTECTED] (or [EMAIL PROTECTED]). In a nutshell - send to [EMAIL PROTECTED] a message with SET ADSM-L MSGack in the *body* (not subject) Zlatko Krastev IT Consultant Rob Berendt [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 06.02.2003 21:32 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: how to stop mail?? When I had problems subscribing to this list I sent a message off to [EMAIL PROTECTED] and quickly got subscribed. I've submitted one new question and a couple of responses already, however I haven't seen them bounced back to me. Does this list not bounce the message back to the sender? Rob Berendt -- They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. Benjamin Franklin Marc Levitan [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/06/2003 02:18 PM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Fax to: Subject:how to stop mail?? All, I sent the following to [EMAIL PROTECTED] SET ADSM-L NOMAIL And I received: Your subscription options have been successfully updated. Here are the exact settings now in use for your subscription. Please take a few moments to check that this is indeed what you wanted. Subscription options for Marc X, list ADSM-L: NOMAIL You have temporarily turned off your subscription and will not receive any mail from the list FULLHDRFull (normal) mail headers NOREPROYou do not receive a copy of your own postings ACKShort e-mail acknowledgement of successfully processed Postings The problem is that I STILL AM RECEIVING EMAIL FROM THE LIST!!! Does anyone know why?
Re: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM system...is it possible ??
Clarificationthe ADSM system on which these backup tapes were created no longer exists. Databases are gone. Server is gone. All's that's left are the tapes. So..now...is this still possible using your suggestions??? Dave Myers Denver Solutions Group Senior Systems Engineer Office Phone: (303) 996-7112 Cellular Phone: (303) 619-0782 Home Office: (303) 948-0027 Fax: (303) 706.1713 e-mail: [EMAIL PROTECTED] |+- || John Naylor| || john.naylor@SCOTTISH-SOUTH| || ERN.CO.UK | || Sent by: ADSM: Dist Stor | || Manager | || [EMAIL PROTECTED] | || | || | || 02/07/2003 04:48 AM| || Please respond to ADSM: | || Dist Stor Manager | || | |+- --| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: Re: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM | | system...is it possible ?? | --| Dave You could also use backupsets. which can be defined in and are then available to the new system If you have a test system you could try restoring the database from the old system, so your test system knows about the backup tapes, then restore to your new client, and your new client can then be registered to your other system and can be backed up afresh. Hmm!! backupsets are probably simpler especially if you have cross system tape access. I have done both the above a while ago, so they do work John PAC Brion Arnaud [EMAIL PROTECTED] on 02/07/2003 08:41:56 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSE) Subject: Re: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM system...is it possible ?? ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. ** Hi Dave, If both servers are using the same kind of tapes, you could use export node - import node procedure ! Another possible way doing this would be using server to server communication, but that implies lots of work just for restoring a node ... My 2 cents ! Cheers. 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: Dave Myers [mailto:[EMAIL PROTECTED]] Sent: Thursday, 06 February, 2003 23:59 To: [EMAIL PROTECTED] Subject: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM system...is it possible ?? Customer asked me if I could recover (restore) the data from an OS/390 ADSM tape using another ADSM system that does not know anything about this tape Is this possible??? I have access to ADSM and TSM on both os/390 2.10 and z/os 1.4 Tia Dave
Re: PMR 02528, 082
Hi bill, What people tend to forget is that y=the data in your diskpool is actual data comming from your clients, your data is therefore not really lost.It is possible to make an administrative schedule which starts after all backups have finished, which backes up your diskpool before it starts migrating. But I feel it costs to amny tapes to do so. Its a choice you have to make and also depends on how your schedules are organised. striping is a good one for performance, We dont use that because we have our diskpool spread out over approx 40 disks (more due to the lack of large disks though but the performance is great) concerning your database, u should have tsm mirrors for those , keep an eye on the way its mirrored though, tsm does not require seperate disks for the mirrors, so make sure you do appoint the database mirror to a place which already resides on a seperate disk. I hope this helps you a little bit, Mi©helle -Original Message- From: William Rosette [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 3:19 PM To: [EMAIL PROTECTED] Subject: PMR 02528, 082 Does any TSM gurus have any suggestions for our AIX admin Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD - Forwarded by Bill Rosette/IS/Corporate/Papa Johns on 02/07/2003 09:20 AM - Steven Schraer To: [EMAIL PROTECTED] 02/06/2003 05:09 cc: Bill Rosette/IS/Corporate/Papa Johns PM Subject: PMR 02528, 082 We are having some problems with the first link below. The second is working. I have been looking at the Redbook. Gettting started with Tivoli Storaage Manger: Implementation Guide. It looks like for storage pools are recommend for raid 0 (mirroring), raid 0+1 (mirroring stripping) or raid 5 (distributed parity). These are safe methods to protect the storage pool. Do you know of any companies that use just raid 1 (stripping) on their storage pools? Is there an issue of tsm loosing a storage pool and the database having issues due to the lost storage pool data? Also there is no suggested raid for the tsm database. Since we mirror the tsm database with the tsm software, can we use raid 1 (stripping) so that we can get a performance increase on accessing the database? Or should we just create the volume group with no raiding but lay the database over multiple smaller disk (i.e. use eight 18.2 Gig disk instead of 4 36.4 Gig disk). What will give us the best performance. Can I get an answer on this tomorrow morning. I have a meeting to discuss the performance issues tomorrow (Feb 7, 2002). Thanks for your assistance! Steven M. Schraer 502-261-4148 - Forwarded by Steven Schraer/IS/Corporate/Papa Johns on 02/06/2003 04:57 PM - Bill Rosette To: Steven Schraer/IS/Corporate/Papa Johns@Papa Johns 02/06/2003 03:51 cc: PM Subject: PMR 02528, 082 Could not get into the link below. Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD - Forwarded by Bill Rosette/IS/Corporate/Papa Johns on 02/06/2003 03:53 PM - Stephen Hull [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Subject: PMR 02/06/2003 03:36 PM Hi Bill, Here is a link to the Performance Tuning Guide on the web: ftp://w3.ibm.com/support/ats/documents/TSM42PDG.pdf Regards, Stephen Hull IBM Tivoli Storage Manager Support More questions? Search our new TSM KnowledgeBase at: http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManag er.html
Re: PMR 02528, 082
From Steven Schraer: It looks like for storage pools are recommend for raid 0 (mirroring), raid 0+1 (mirroring stripping) or raid 5 (distributed parity). These are 0+safe methods to protect the storage pool. Do you know of any companies that use just raid 1 (stripping) on their storage pools? Is there an issue of tsm loosing a storage pool and the database having issues due to the lost storage pool data? From: William Rosette [mailto:[EMAIL PROTECTED]] Does any TSM gurus have any suggestions for our AIX admin [donning my advocacy armor] I still don't see any reason to create redundancy for the disk storage pool. Unless you're not using a tape library, there's no reason for it. The disk pool should get flushed to a more stable medium, and that flush should take place fairly soon after the client backups to disk finish. Why waste gobs of disk on something that's going to flushed clear every day? As far the db and log are concerned, just create volume copies with TSM and make sure the copies are on disks that are on separate disks. That's really all there is to it. -- Mark Stapleton ([EMAIL PROTECTED])
Re: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM system...is it possible ??
From: Dave Myers [mailto:[EMAIL PROTECTED]] Clarificationthe ADSM system on which these backup tapes were created no longer exists. Databases are gone. Server is gone. All's that's left are the tapes. So..now...is this still possible using your suggestions??? Without the database or the original system, what you've got is a tape full of random strings of 0s and 1s. Sorry. -- Mark Stapleton ([EMAIL PROTECTED])
TDP Sql Failures
Recently I upgraded to TDP SQL 5.1 on a SQL server. Once I figured out the command line differences to get the command file to work they seemed to run fine. Two days ago I started receiving a failure notification on the backups, which looks like one of the databases is corrupt. This particular client is running 5.1.5.2 TSM, on NT4 SP6 TDP SQL 5.1..5.0. The only thing that has happened is the SQL PS4 was applied the day before the failures started to occur and the software that uses this database was applied after the SQL Update. Now neither gave any indication of problems during their respective upgrades but it almost looks like something must have gone wrong. The error reports backup of insite failed. Could anyone tell me if it's possible to just restore that database to a known good point, even if it was before the SQL upgrade and upgrade of the software that uses the database? Or will I have to restore all databases to a known good point on the same day. We have never had to mess with a restore, thankfully, and not since I don't know much about how it works. Unfortunately I have no test SQL server to run this on. This is from last night. The previous sucessful backups reported 16 02/07/2003 03:08:41 == Log file pruned using log retention period of 60 day(s) 02/07/2003 03:08:41 == 122 out of 3191 entries pruned from the top of this log 02/07/2003 03:08:43 = 02/07/2003 03:08:46 = 02/07/2003 03:08:46 Request : FULL BACKUP 02/07/2003 03:08:46 Database Input List : * 02/07/2003 03:08:46 Group Input List : - 02/07/2003 03:08:46 File Input List : - 02/07/2003 03:08:46 Number of Buffers : 3 02/07/2003 03:08:46 Buffer Size : 1024 02/07/2003 03:08:46 Number of SQL Buffers : 0 02/07/2003 03:08:46 SQL Buffer Size : 1024 02/07/2003 03:08:46 Number of Stripes specified : 1 02/07/2003 03:08:46 Estimate : - 02/07/2003 03:08:46 Truncate Log? : - 02/07/2003 03:08:46 Wait for Tape Mounts? : Yes 02/07/2003 03:08:46 TSM Options File : dsm.opt 02/07/2003 03:08:46 TSM Nodename Override : - 02/07/2003 03:08:46 Sqlserver : CP-ITS-TAX01 02/07/2003 03:08:46 02/07/2003 03:09:21 ACO5436E A failure occurred on stripe number (0), rc = 115 02/07/2003 03:09:21 (RC155) 02/07/2003 03:09:21 Backup of insite failed. 02/07/2003 03:09:21 (RC155) 02/07/2003 03:10:31 Total SQL backups selected: 16 02/07/2003 03:10:31 Total SQL backups attempted: 16 02/07/2003 03:10:31 Total SQL backups completed: 15 02/07/2003 03:10:31 Total SQL backups excluded: 0 02/07/2003 03:10:31 Total SQL backups inactivated: 0 02/07/2003 03:10:31 Throughput rate: 5,678.68 Kb/Sec 02/07/2003 03:10:31 Total bytes transferred: 566,017,520 02/07/2003 03:10:31 Elapsed processing time: 97.34 Secs 02/07/2003 03:10:31 ACO0151E Errors occurred while processing the request. 02/07/2003 03:10:31 ACO0151E Errors occurred while processing the request. Thanks for the help. Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
Re: StorageTek with LTO2?
Have in mind you will need IBM driver for IBM drives (when they become available for STK) and TSM driver update for HP/Seagate. Thus you have to wait either support with IBM drives or new ITSM maintenance supporting HP/Seagate LTO-2 drives. The answer whichever is earlier is not good because you cannot predict at the library ordering. Zlatko Krastev IT Consultant Ochs, Duane [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 06.02.2003 23:21 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: StorageTek with LTO2? Storagetek LTO-2 drive information. I received this last week. I have not had an update yet. Not sure if LTO-2 has passed testing yet. STK is looking at GA the week of Feb 7th for LTO2 with HP drives- SCSI only. The FC LTO2 is targeted for April/May release with IBM Drives. -Original Message- From: Alex Paschal [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:52 PM To: [EMAIL PROTECTED] Subject: Re: StorageTek with LTO2? I find SAN based library/drive sharing and scratch/drive pooling _very_ easy with STK libraries/Gresham EDT/ACSLS. I can't tell you whether it'd be easier with IBM libraries or not as I've never run one in a shared environment. Alex Paschal Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Jin Bae Chi [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 10:05 AM To: [EMAIL PROTECTED] Subject: StorageTek with LTO2? Does anyone has info about StorageTek with LTO2? We are just about to purchase an enterprise tape library. I will need to make a good comparison between IBM and StorageTek LTO1 and LTO2 with 8 drives. I would start with about 10 - 15 TB data on tapes. Any comment will be appreciated. Jin Bae Chi (Gus) System Admin/Tivoli Data Center, CSCC 614-287-5270 614-287-5488 Fax [EMAIL PROTECTED]
TDP for Oracle 9.2
Hi gurus! I found a lot of queries in the archive regarding if Oracle 9.2 is supported on TDPO 2.2.1 but no replies. Does any know if this is supported? I need Data Protection for Oracle 9.2 running on HP-UX. Refering to the configuration instructions for TDP 2.2.1 the RMAN relinking porcedure does not match for Oracle 9.2 (HP-UX). There is only Oracle Data Protection 5.1.5 awailable for AIX, am I correct? Does any know if the DP 5.1.5 for HP-UX (and Solaris etc.) is coming up? Best regards, Kolbeinn Josepsson 7 Systems Engineer Tivoli Certified Consultant - IBM TSM V5.1 www.nyherji.is
Re: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM system...is it possible ??
Clarificationthe ADSM system on which these backup tapes were created no longer exists. Databases are gone. Server is gone. All's that's left are the tapes. So..now...is this still possible using your suggestions??? Without the database or the original system, what you've got is a tape full of random strings of 0s and 1s. Sorry. -- Mark Stapleton ([EMAIL PROTECTED]) Mark, It looks from reading the manal, that if this backup was created using the BACKUPSET procedure then I could restore on a completely different server, without the original databases. Is that true Tia Dave
Re: TDP for Oracle 9.2
There is an upgrade from 2.2.1 tdp which is tdp 5.1.5. Here are the software requirements for tdp for oracle 5.1.5. Looks like aix 5.1 is needed but 9.2 oracle is supported. == Software Requirements - Data Protection for Oracle Version 5 Release 1 requires the following MINIMUM software levels: - AIX 5.1 64bit or higher - Oracle9i (9.2.x) - Tivoli Storage Manager (TSM) 4.2. TSM does not have to be on the same machine as Data Protection for Oracle and may be on any platform supported by TSM. - TSM Backup-Archive Client 5.1.1 is required only if the central scheduler service of the TSM Client is used. If so, the TSM Client must reside on the same machine as Data Protection for Oracle. - Tivoli Storage Manager API 5.1.1 included with this package === Also, here is the licensing information for 5.1.5: Data Protection for Oracle version 5.1.5 licensing -- Data Protection for Oracle no longer supports version 2.1 licensing. If you are upgrading Data Protection for Oracle to version 5.1.5 you must use the license supplied with the Data Protection for Oracle 2.2.1 32bit AIX client. To acquire this license you must install the Data Protection for Oracle version 2.2.1 prior to installing the Data Protection for Oracle 5.1.5 ptf. == == Oracle 9.0.1 is supported with tdp for oracle 2.2.1. This is from the 2.2.1 readme: Tivoli Data Protection for Oracle is an Application Programming Interface(API) between the Tivoli Storage Manager API and Oracle8i(8.1.7) or Oracle9i (9.0.1) Recovery Manager(RMAN). Cheers . Shekhar Dhotre. Sr.Midrange Engineer. Lend Lase , GSDC. www.lendlease.com Kolbeinn Josepsson [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 10:08 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:TDP for Oracle 9.2 Hi gurus! I found a lot of queries in the archive regarding if Oracle 9.2 is supported on TDPO 2.2.1 but no replies. Does any know if this is supported? I need Data Protection for Oracle 9.2 running on HP-UX. Refering to the configuration instructions for TDP 2.2.1 the RMAN relinking porcedure does not match for Oracle 9.2 (HP-UX). There is only Oracle Data Protection 5.1.5 awailable for AIX, am I correct? Does any know if the DP 5.1.5 for HP-UX (and Solaris etc.) is coming up? Best regards, Kolbeinn Josepsson 7 Systems Engineer Tivoli Certified Consultant - IBM TSM V5.1 www.nyherji.is
Three copies of backup data
Hi list, I have a TSM Server running on a W2K Server machine. The tape library is a IBM 3590, non automated, with two drives. The drives are connected to the TSM Server through SCSI interfaces (one interface for each drive). What I need is this: I want to do each incremental backup on three different tapes, so I can store these tapes in different places. The tapes contents should be identical. How is the best way to accomplish this ? I was thinking about creating a diskstorage pool (today all backup/archive operations are direct to tape), execute the backup operations to disk and afterwards copy it to the tapes . Anyway, my goal is to have three copies for each incremental backup made. I must consider the two drives library and my backup window. Any help is appreciated. Thanks. Mario Behring - Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now
Re: TSM for Oracle
Orin, I see that there are many subscribers willing to help you with whatever you situation is with Data Protection for Oracle. Can you please be more specific (I'm asking for it, huh?) about the complexities being faced? I must assume, because you mention TSM for Oracle, that your troubles stem from the TSM side. Is there anything specific that makes the setup complex? Is it installation, or configuring, or using Data Protection for Oracle or the TSM Server? I look forward to hearing from you. As a side note to one of the subsribers questions: TDP Oracle 2.2.1 supports Oracle 9i. The only exception is for Oracle 9.2 on AIX 5 64bit, you will need to download the Data Protection for Oracle 5.1.5 ptf from IBM ftp site for support on this platform. -- Date:Thu, 6 Feb 2003 11:04:47 -0600 From:Orin Rehorst [EMAIL PROTECTED] Subject: TSM for Oracle Due to the complexity of using TSM for Oracle, management here is about ready to replace TSM altogether. Anyone know of a class available for this topic? BTW, IBM has a web page for such a course listed at http://www-3.ibm.com/software/tivoli/education/J104126F96394E48.html, but an IBM employee told me the course doesn't actually exist! Regards, Orin Orin Rehorst Port of Houston Authority (Largest U.S. port in foreign tonnage) e-mail: [EMAIL PROTECTED] Phone: (713)670-2443 Fax: (713)670-2457 TOPAS web site: www.homestead.com/topas/topas.html -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Inclexcl not picking up Management Class
Hi All, I have an annoying problem Hopefully the Doc will be able to fix me up Seriously, I need to make a particular drive in a WINNT client use large capacity tapes for its backups I have a management class LARGE which does this and works for other clients in this domain For this particular client, however we code the option file and we have tried a lot of variations it insists on seeing this line per query inclexcl :- include d:*large as include d:/.../* I know the line is being read because the query incl/excl shows it in a different position if I move it around in the options file. The full options file follows:- PASSWORDACCESSGENERATE TCPSERVERADDRESSIBMBK NODENAME BOXWA009 schedmode prompted DOMAIN c: D: E: L: include d:*large Exclude.File e:\pagefile.sys EXCLUDE.DIR c:\temp EXCLUDE.DIR c:\Program Files\Sophos SWEEP for NT EXCLUDE.DIR c:\Documents And Settings EXCLUDE.FILE c:\WINNT\system32\config\default EXCLUDE.FILE c:\WINNT\system32\config\default.log EXCLUDE.FILE c:\WINNT\system32\config\sam EXCLUDE.FILE c:\WINNT\system32\config\sam.log EXCLUDE.FILE c:\WINNT\system32\config\security EXCLUDE.FILE c:\WINNT\system32\config\security.log EXCLUDE.FILE c:\WINNT\system32\config\software EXCLUDE.FILE c:\WINNT\system32\config\software.log EXCLUDE.FILE c:\WINNT\system32\config\system EXCLUDE.FILE c:\WINNT\system32\config\system.alt EXCLUDE.FILE c:\Program Files\Tivoli\TSM\baclient\dsmsched.log EXCLUDE.FILE c:\WINNT\system32\dns\dns.log EXCLUDE.FILE c:\WINNT\system32\PERFLIB_*.* Thanks for any input, John ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **
Re: how to stop mail??
I've been putting stuff in the body and not the subject. This list server always responds back that I am not doing it that way. I wonder if this list has a problem with my Lotus Notes R6 client. Other lists I belong to don't seem to have this issue. My work around is to send my problems to [EMAIL PROTECTED] Perhaps the webmasters attempt to fix my issue is what started all the nice blank email's we've been getting :-) Rob Berendt -- They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. Benjamin Franklin Zlatko Krastev/ACIT [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 09:19 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Fax to: Subject:Re: how to stop mail?? Haven't you got this one: Your subscription to the ADSM-L list (ADSM: Dist Stor Manager) has been accepted. ... many lines of description of list features and functions ... More information on LISTSERV commands can be found in the LISTSERV reference card, which you can retrieve by sending an INFO REFCARD command to [EMAIL PROTECTED] (or [EMAIL PROTECTED]). In a nutshell - send to [EMAIL PROTECTED] a message with SET ADSM-L MSGack in the *body* (not subject) Zlatko Krastev IT Consultant Rob Berendt [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 06.02.2003 21:32 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: how to stop mail?? When I had problems subscribing to this list I sent a message off to [EMAIL PROTECTED] and quickly got subscribed. I've submitted one new question and a couple of responses already, however I haven't seen them bounced back to me. Does this list not bounce the message back to the sender? Rob Berendt -- They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. Benjamin Franklin Marc Levitan [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/06/2003 02:18 PM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Fax to: Subject:how to stop mail?? All, I sent the following to [EMAIL PROTECTED] SET ADSM-L NOMAIL And I received: Your subscription options have been successfully updated. Here are the exact settings now in use for your subscription. Please take a few moments to check that this is indeed what you wanted. Subscription options for Marc X, list ADSM-L: NOMAIL You have temporarily turned off your subscription and will not receive any mail from the list FULLHDRFull (normal) mail headers NOREPROYou do not receive a copy of your own postings ACKShort e-mail acknowledgement of successfully processed Postings The problem is that I STILL AM RECEIVING EMAIL FROM THE LIST!!! Does anyone know why?
From TIVsm 4.2.1.8 to TIVsm 5.1.6.1 on IBM H70, AIX 4.3.3
Hi *SM-ers, we want to do the above mentioned migration. Mig-1: 4.2.1.8 -- 5.1.0.0 -- 5.1.6.0 -- 5.1.6.1 Mig-2 4.2.1.8 -- 5.1.5.0 -- 5.1.6.0 -- 5.1.6.1 Q: Which one would You prefer ? -- MfG / Ciao - - - - - - - - - - - - - - - - - - - - - - - - - - - - Peter Dümpert Email: [EMAIL PROTECTED] Rechenzentrum der Technischen Universität Fax : ++49/531/391-5549 D 38092 BraunschweigTel : ++49/531/391-5535
Re: Three copies of backup data
From: Mario Behring [mailto:[EMAIL PROTECTED]] I have a TSM Server running on a W2K Server machine. The tape library is a IBM 3590, non automated, with two drives. The drives are connected to the TSM Server through SCSI interfaces (one interface for each drive). What I need is this: I want to do each incremental backup on three different tapes, so I can store these tapes in different places. The tapes contents should be identical. Create a primary tape storage pool (call it primtape1) and two copy storage pools (call them copytape1 and copytape2). After backups complete, run backup stg primtape1 copytape1 backup stg primtape1 copytape2 upd stg diskpool hi=0 lo=0 and when diskpool--primtape1 migration is complete: upd stg diskpool hi=90 lo=70 (or whatever your diskpool migration levels are) (This assumes, of course, that you're using a disk cache to catch client backups.) Contents of all three tapes may not be absolutely identical, but they'll be pretty damn close. (If you're looking to clone the contents of one tape to another tape via an OS utility like tcopy or dd, you may or may not get a usable tape.) -- Mark Stapleton ([EMAIL PROTECTED])
Re: Inclexcl not picking up Management Class
I'll assume you did have backslashes when you used them in the include/exclude statement and not the slashes you have in your note... I've found that when in doubt, ask TSM what it expects... Try doing a q file boxwa009 and take its specification for D: and use it... probably \\boxwa009\d$ so try \\boxwa009\d$\...\* just a thought. Dwight -Original Message- From: John Naylor [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 9:55 AM To: [EMAIL PROTECTED] Subject: Inclexcl not picking up Management Class Hi All, I have an annoying problem Hopefully the Doc will be able to fix me up Seriously, I need to make a particular drive in a WINNT client use large capacity tapes for its backups I have a management class LARGE which does this and works for other clients in this domain For this particular client, however we code the option file and we have tried a lot of variations it insists on seeing this line per query inclexcl :- include d:*large as include d:/.../* I know the line is being read because the query incl/excl shows it in a different position if I move it around in the options file. The full options file follows:- PASSWORDACCESSGENERATE TCPSERVERADDRESSIBMBK NODENAME BOXWA009 schedmode prompted DOMAIN c: D: E: L: include d:*large Exclude.File e:\pagefile.sys EXCLUDE.DIR c:\temp EXCLUDE.DIR c:\Program Files\Sophos SWEEP for NT EXCLUDE.DIR c:\Documents And Settings EXCLUDE.FILE c:\WINNT\system32\config\default EXCLUDE.FILE c:\WINNT\system32\config\default.log EXCLUDE.FILE c:\WINNT\system32\config\sam EXCLUDE.FILE c:\WINNT\system32\config\sam.log EXCLUDE.FILE c:\WINNT\system32\config\security EXCLUDE.FILE c:\WINNT\system32\config\security.log EXCLUDE.FILE c:\WINNT\system32\config\software EXCLUDE.FILE c:\WINNT\system32\config\software.log EXCLUDE.FILE c:\WINNT\system32\config\system EXCLUDE.FILE c:\WINNT\system32\config\system.alt EXCLUDE.FILE c:\Program Files\Tivoli\TSM\baclient\dsmsched.log EXCLUDE.FILE c:\WINNT\system32\dns\dns.log EXCLUDE.FILE c:\WINNT\system32\PERFLIB_*.* Thanks for any input, John ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **
Re: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM system...is it possible ??
Yes you can do this, but if you have a number of tapes that make up the backupset you need to know the order that they were written in, so you can define them in the same sequence in the volume names parameter. If you have the web gui its quite straightforward to define the backupset to your new system Dave Myers [EMAIL PROTECTED] on 02/07/2003 03:18:45 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSE) Subject: Re: Restoring datasets from an OS/390 ADSM tape...using a foreign ADSM system...is it possible ?? Clarificationthe ADSM system on which these backup tapes were created no longer exists. Databases are gone. Server is gone. All's that's left are the tapes. So..now...is this still possible using your suggestions??? Without the database or the original system, what you've got is a tape full of random strings of 0s and 1s. Sorry. -- Mark Stapleton ([EMAIL PROTECTED]) Mark, It looks from reading the manal, that if this backup was created using the BACKUPSET procedure then I could restore on a completely different server, without the original databases. Is that true Tia Dave ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **
backup every hour in TSM ..
Hi All, we want to backup oracle transaction logs every hour /everyday of the week .Currently the model of backing up everything once a day permits losing an entire days worth of data which isn't necessary. Any ideas on how I can schedule this job in TSM ? Thank You Shekhar Dhotre. Sr.Midrange Engineer. Lend Lase , GSDC. www.lendlease.com
Re: Multiple Emails from this group
Thanks Martha-- good luck on the servers! We can put up with it-- it's nice to know you are already on top of it! lisa Martha McConaghyTo: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: RIST.EDUSubject: Re: Multiple Emails from this group 02/07/2003 09:53 AM I've had reports of this from other lists as well. We have been having trouble with our SMTP servers and are working with IBM to fix them. I think that is the source of the trouble. You guys are just going to have to put up with it for awhile until we can get things resolved. Martha
Re: From TIVsm 4.2.1.8 to TIVsm 5.1.6.1 on IBM H70, AIX 4.3.3
Is ot possible to skip the 5.1.6.0 and go 4.2.1.8 -- 5.1.5.0 -- then 5.1.6.1 being that 5.6.0 is suppose to be buggy. -Original Message- From: Peter Duempert [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 9:55 AM To: [EMAIL PROTECTED] Subject: From TIVsm 4.2.1.8 to TIVsm 5.1.6.1 on IBM H70, AIX 4.3.3 Hi *SM-ers, we want to do the above mentioned migration. Mig-1: 4.2.1.8 -- 5.1.0.0 -- 5.1.6.0 -- 5.1.6.1 Mig-2 4.2.1.8 -- 5.1.5.0 -- 5.1.6.0 -- 5.1.6.1 Q: Which one would You prefer ? -- MfG / Ciao - - - - - - - - - - - - - - - - - - - - - - - - - - - - Peter Dümpert Email: [EMAIL PROTECTED] Rechenzentrum der Technischen Universität Fax : ++49/531/391-5549 D 38092 BraunschweigTel : ++49/531/391-5535
Re: PMR 02528, 082
Bill, The real question is, what is your client data profile? While I don't think I'd mirror a stgpool used solely for filesystem backups, I myself would be inclined to mirror a stgpool that contains live data such as archived txn logs from DB2 which then get reused or fileserver cleanup archive-delete processes. If, after either of the aformentioned data gets sent to disk, the disk fails before your daily (bi- or tri-daily? Somewhere in 8-24 hours, anyway) migration/backup, you could have a heck of an exposure. For example, say, your DB2 backed up last night, and does more or less hourly txn log archives so that you can roll forward to the last instant (important for financial databases like SAP, so a failure would be very high profile). You backup stg and migrate disk to tape once in the morning, once in the evening. Your log archives at 5:30AM, gets moved to tape. DB2 archives again at 6:30, 8:00, 9:30, 10:30. However, after the 8:00 archive, the disk crashed and the volume went offline to TSM. Your next archives still succeed because they go to another disk volume or to nextstgpool. HOWEVER, they'll be useless. You can't meet your SLA and recover to point in time after 6:30AM because all your txn logs build off of the 8:00 one that is lost. Too bad you didn't mirror. 2nd example, say Accounting runs monthly financial reports. Your SLA says there's a 6 month retention on those reports, then they get archived (7 years, in case of audit) and deleted to save disk space on the fileserver. 6 months later, an automated script (because this is a well-defined process) goes to archive them and delete them from disk with an archive -deletefiles=yes. An hour later, before migration or backup stg happens, the disk crashes. Are you going to remember to restore from backup so that you can re-archive them, or is that data lost? Hope this helps you decide whether you want to mirror or not. Alex Paschal Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: William Rosette [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 6:19 AM To: [EMAIL PROTECTED] Subject: PMR 02528, 082 Does any TSM gurus have any suggestions for our AIX admin Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD - Forwarded by Bill Rosette/IS/Corporate/Papa Johns on 02/07/2003 09:20 AM - Steven Schraer To: [EMAIL PROTECTED] 02/06/2003 05:09 cc: Bill Rosette/IS/Corporate/Papa Johns PM Subject: PMR 02528, 082 We are having some problems with the first link below. The second is working. I have been looking at the Redbook. Gettting started with Tivoli Storaage Manger: Implementation Guide. It looks like for storage pools are recommend for raid 0 (mirroring), raid 0+1 (mirroring stripping) or raid 5 (distributed parity). These are safe methods to protect the storage pool. Do you know of any companies that use just raid 1 (stripping) on their storage pools? Is there an issue of tsm loosing a storage pool and the database having issues due to the lost storage pool data? Also there is no suggested raid for the tsm database. Since we mirror the tsm database with the tsm software, can we use raid 1 (stripping) so that we can get a performance increase on accessing the database? Or should we just create the volume group with no raiding but lay the database over multiple smaller disk (i.e. use eight 18.2 Gig disk instead of 4 36.4 Gig disk). What will give us the best performance. Can I get an answer on this tomorrow morning. I have a meeting to discuss the performance issues tomorrow (Feb 7, 2002). Thanks for your assistance! Steven M. Schraer 502-261-4148 - Forwarded by Steven Schraer/IS/Corporate/Papa Johns on 02/06/2003 04:57 PM - Bill Rosette To: Steven Schraer/IS/Corporate/Papa Johns@Papa Johns 02/06/2003 03:51 cc: PM Subject: PMR 02528, 082 Could not get into the link below. Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD - Forwarded by Bill Rosette/IS/Corporate/Papa Johns on 02/06/2003 03:53 PM - Stephen Hull [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Subject: PMR 02/06/2003 03:36 PM Hi Bill, Here is a link to the Performance Tuning Guide on the web: ftp://w3.ibm.com/support/ats/documents/TSM42PDG.pdf Regards, Stephen Hull IBM Tivoli Storage Manager Support More questions? Search our new TSM KnowledgeBase at: http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManag er.html
groupid change creates a modified file copy
ADSM server v 3.1, on AIX 4.3.3 system. IBM 3575 L18 tape library. Yes, we plan to upgrade soon. But right now I'm in a jam: 1) Our backup server is set to hold 1 copy of a modified file for 7 days. 2) Our backup server is backing up home directories on unix disks. We want to change the group id's of all our users on unix. 3) If we change a group id of a file, then the server backs up this modified file as a modifed copy, thus having 2 copies of the file on tape, one copy owned by each group. 4) Is there any way to turn off this function so that a change in the group id does NOT create a mocified backup copy? 5) We are running low on tapes and is the server tries to backup a modified copy of all user data the backup server will not be able to handle it and it will explode. Thanks in advance! Alex --- --- Alex Lazarevich | Systems Administrator | Imaging Technology Group Beckman Institute - University of Illinois [EMAIL PROTECTED] | (217)244-1565 | www.itg.uiuc.edu --- ---
Re: TSM for Oracle
As a side note to one of the subsribers questions: TDP Oracle 2.2.1 supports Oracle 9i. The only exception is for Oracle 9.2 on AIX 5 64bit, you will need to download the Data Protection for Oracle 5.1.5 ptf from IBM ftp site for support on this platform. IS following configuration supported ? AIX 4.3.3.10 Oracle 9.2.0.1.0 TDP 5.1.5 TSM client/server 5.x . I talked to TSM support and they told me that- It will require AIX5.1 instead AIX4.3.3.10 in order to make above configuration work. Thank You Shekhar Dhotre. Sr.Midrange Engineer. Lend Lase , GSDC. Neil Rasmussen [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 10:50 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM for Oracle Orin, I see that there are many subscribers willing to help you with whatever you situation is with Data Protection for Oracle. Can you please be more specific (I'm asking for it, huh?) about the complexities being faced? I must assume, because you mention TSM for Oracle, that your troubles stem from the TSM side. Is there anything specific that makes the setup complex? Is it installation, or configuring, or using Data Protection for Oracle or the TSM Server? I look forward to hearing from you. As a side note to one of the subsribers questions: TDP Oracle 2.2.1 supports Oracle 9i. The only exception is for Oracle 9.2 on AIX 5 64bit, you will need to download the Data Protection for Oracle 5.1.5 ptf from IBM ftp site for support on this platform. -- Date:Thu, 6 Feb 2003 11:04:47 -0600 From:Orin Rehorst [EMAIL PROTECTED] Subject: TSM for Oracle Due to the complexity of using TSM for Oracle, management here is about ready to replace TSM altogether. Anyone know of a class available for this topic? BTW, IBM has a web page for such a course listed at http://www-3.ibm.com/software/tivoli/education/J104126F96394E48.html, but an IBM employee told me the course doesn't actually exist! Regards, Orin Orin Rehorst Port of Houston Authority (Largest U.S. port in foreign tonnage) e-mail: [EMAIL PROTECTED] Phone: (713)670-2443 Fax: (713)670-2457 TOPAS web site: www.homestead.com/topas/topas.html -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: TSM for Oracle
FWIW-- the complexity isn't due to the TSM side-- its the RMAN scripts as far as I am concerned. If you are already administering a TSM server-- THAT'S the difficult part! And, when trying to diagnose a problem, Tivoli is WAY more helpful than Oracle or SQL-BackTrak has been in the past too. YMMV lisa Neil Rasmussen [EMAIL PROTECTED] To: [EMAIL PROTECTED] BM.COM cc: Sent by: Subject: Re: TSM for Oracle ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 02/07/2003 09:50 AM Please respond to ADSM: Dist Stor Manager Orin, I see that there are many subscribers willing to help you with whatever you situation is with Data Protection for Oracle. Can you please be more specific (I'm asking for it, huh?) about the complexities being faced? I must assume, because you mention TSM for Oracle, that your troubles stem from the TSM side. Is there anything specific that makes the setup complex? Is it installation, or configuring, or using Data Protection for Oracle or the TSM Server? I look forward to hearing from you. As a side note to one of the subsribers questions: TDP Oracle 2.2.1 supports Oracle 9i. The only exception is for Oracle 9.2 on AIX 5 64bit, you will need to download the Data Protection for Oracle 5.1.5 ptf from IBM ftp site for support on this platform. -- Date:Thu, 6 Feb 2003 11:04:47 -0600 From:Orin Rehorst [EMAIL PROTECTED] Subject: TSM for Oracle Due to the complexity of using TSM for Oracle, management here is about ready to replace TSM altogether. Anyone know of a class available for this topic? BTW, IBM has a web page for such a course listed at http://www-3.ibm.com/software/tivoli/education/J104126F96394E48.html, but an IBM employee told me the course doesn't actually exist! Regards, Orin Orin Rehorst Port of Houston Authority (Largest U.S. port in foreign tonnage) e-mail: [EMAIL PROTECTED] Phone: (713)670-2443 Fax: (713)670-2457 TOPAS web site: www.homestead.com/topas/topas.html -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
TSM 5.1.5 B/A Client and Netware 6
Hi TSMers Has anyone had any challenges with TSM 5.1.5 on a client running Netware 6? thanks, Tommy Templeton Senior System Administrator DFA-MMRS 601-359-3106 e-mail - [EMAIL PROTECTED]
Re: Inclexcl not picking up Management Class
How about: What does QUERY INCLEXCL show? Also, you don't indicate why you think this is a problem; are you finding that the d: files are not being bound to the LARGE management class? Or are you just basing this on what you see in QUERY INCLEXCL? 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. John Naylor [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 08:54 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Inclexcl not picking up Management Class Hi All, I have an annoying problem Hopefully the Doc will be able to fix me up Seriously, I need to make a particular drive in a WINNT client use large capacity tapes for its backups I have a management class LARGE which does this and works for other clients in this domain For this particular client, however we code the option file and we have tried a lot of variations it insists on seeing this line per query inclexcl :- include d:*large as include d:/.../* I know the line is being read because the query incl/excl shows it in a different position if I move it around in the options file. The full options file follows:- PASSWORDACCESSGENERATE TCPSERVERADDRESSIBMBK NODENAME BOXWA009 schedmode prompted DOMAIN c: D: E: L: include d:*large Exclude.File e:\pagefile.sys EXCLUDE.DIR c:\temp EXCLUDE.DIR c:\Program Files\Sophos SWEEP for NT EXCLUDE.DIR c:\Documents And Settings EXCLUDE.FILE c:\WINNT\system32\config\default EXCLUDE.FILE c:\WINNT\system32\config\default.log EXCLUDE.FILE c:\WINNT\system32\config\sam EXCLUDE.FILE c:\WINNT\system32\config\sam.log EXCLUDE.FILE c:\WINNT\system32\config\security EXCLUDE.FILE c:\WINNT\system32\config\security.log EXCLUDE.FILE c:\WINNT\system32\config\software EXCLUDE.FILE c:\WINNT\system32\config\software.log EXCLUDE.FILE c:\WINNT\system32\config\system EXCLUDE.FILE c:\WINNT\system32\config\system.alt EXCLUDE.FILE c:\Program Files\Tivoli\TSM\baclient\dsmsched.log EXCLUDE.FILE c:\WINNT\system32\dns\dns.log EXCLUDE.FILE c:\WINNT\system32\PERFLIB_*.* Thanks for any input, John ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **
Re: backup every hour in TSM ..
Shekhar, My hourly log schedule looks like this: Policy Domain Name: BWCSQL Schedule Name: LOGHOUR Description: Action: Command Options: Objects: c:\SQLLOG.CMD Priority: 5 Start Date/Time: 11/18/2002 07:30:00 Duration: 20 Minute(s) Period: 1 Hour(s) Day of Week: Any Expiration: Last Update by (administrator): ADMIN Last Update Date/Time: 12/16/2002 12:56:17 Managing profile: and the SQLLOG.CMD file just says: %sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt sqlserver=msbwc8 /sqlauth=int /sqlbuff=4 /sqlbuffersize=2048 /logfile=%sql_dir%\sqllog.log %sql_dir%\sqlsched.log Glen Churchfield -Original Message- From: shekhar Dhotre To: [EMAIL PROTECTED] Sent: 2/7/2003 10:56 AM Subject: backup every hour in TSM .. Hi All, we want to backup oracle transaction logs every hour /everyday of the week .Currently the model of backing up everything once a day permits losing an entire days worth of data which isn't necessary. Any ideas on how I can schedule this job in TSM ? Thank You Shekhar Dhotre. Sr.Midrange Engineer. Lend Lase , GSDC. www.lendlease.com
Re: Inclexcl not picking up Management Class
Yes Andy this is a real problem, the files backup but they go to the default pool which is collocated by node not filespace. The query inclexcl reproduces the option file including the line I have highlighted Unfortunately I cannot send a screen print at the moment because the client admin is not around and I do not have permissions to the box. Thanks, John Andrew Raibeck [EMAIL PROTECTED] on 02/07/2003 04:08:49 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSE) Subject: Re: Inclexcl not picking up Management Class How about: What does QUERY INCLEXCL show? Also, you don't indicate why you think this is a problem; are you finding that the d: files are not being bound to the LARGE management class? Or are you just basing this on what you see in QUERY INCLEXCL? 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. John Naylor [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 08:54 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Inclexcl not picking up Management Class Hi All, I have an annoying problem Hopefully the Doc will be able to fix me up Seriously, I need to make a particular drive in a WINNT client use large capacity tapes for its backups I have a management class LARGE which does this and works for other clients in this domain For this particular client, however we code the option file and we have tried a lot of variations it insists on seeing this line per query inclexcl :- include d:*large as include d:/.../* I know the line is being read because the query incl/excl shows it in a different position if I move it around in the options file. The full options file follows:- PASSWORDACCESSGENERATE TCPSERVERADDRESSIBMBK NODENAME BOXWA009 schedmode prompted DOMAIN c: D: E: L: include d:*large Exclude.File e:\pagefile.sys EXCLUDE.DIR c:\temp EXCLUDE.DIR c:\Program Files\Sophos SWEEP for NT EXCLUDE.DIR c:\Documents And Settings EXCLUDE.FILE c:\WINNT\system32\config\default EXCLUDE.FILE c:\WINNT\system32\config\default.log EXCLUDE.FILE c:\WINNT\system32\config\sam EXCLUDE.FILE c:\WINNT\system32\config\sam.log EXCLUDE.FILE c:\WINNT\system32\config\security EXCLUDE.FILE c:\WINNT\system32\config\security.log EXCLUDE.FILE c:\WINNT\system32\config\software EXCLUDE.FILE c:\WINNT\system32\config\software.log EXCLUDE.FILE c:\WINNT\system32\config\system EXCLUDE.FILE c:\WINNT\system32\config\system.alt EXCLUDE.FILE c:\Program Files\Tivoli\TSM\baclient\dsmsched.log EXCLUDE.FILE c:\WINNT\system32\dns\dns.log EXCLUDE.FILE c:\WINNT\system32\PERFLIB_*.* Thanks for any input, John ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **
Re: Inclexcl not picking up Management Class
Hi John, dsmc q inclexcl will only show the incude exclude parameters, not mgmt class parameter. You can see if file is bound to the mgmt class using the GUI, in the backup view, right-click the mouse on the file. To see if it is backed up bound to this mgmt class, use the restore view. Remember to stop/start the scheduler after you change the inclexcl or dsm.opt file. Best regards, Kolbeinn Josepsson - Systems Engineer Tivoli Certified Consultant - IBM TSM V5.1 www.nyherji.is John Naylor john.naylor@SCOTTISH-SOUT To: [EMAIL PROTECTED] HERN.CO.UKcc: Sent by: ADSM: Dist Stor Subject: Inclexcl not picking up Management Class Manager [EMAIL PROTECTED] 07.02.2003 15:54 Please respond to ADSM: Dist Stor Manager Hi All, I have an annoying problem Hopefully the Doc will be able to fix me up Seriously, I need to make a particular drive in a WINNT client use large capacity tapes for its backups I have a management class LARGE which does this and works for other clients in this domain For this particular client, however we code the option file and we have tried a lot of variations it insists on seeing this line per query inclexcl :- include d:*large as include d:/.../* I know the line is being read because the query incl/excl shows it in a different position if I move it around in the options file. The full options file follows:- PASSWORDACCESSGENERATE TCPSERVERADDRESSIBMBK NODENAME BOXWA009 schedmode prompted DOMAIN c: D: E: L: include d:*large Exclude.File e:\pagefile.sys EXCLUDE.DIR c:\temp EXCLUDE.DIR c:\Program Files\Sophos SWEEP for NT EXCLUDE.DIR c:\Documents And Settings EXCLUDE.FILE c:\WINNT\system32\config\default EXCLUDE.FILE c:\WINNT\system32\config\default.log EXCLUDE.FILE c:\WINNT\system32\config\sam EXCLUDE.FILE c:\WINNT\system32\config\sam.log EXCLUDE.FILE c:\WINNT\system32\config\security EXCLUDE.FILE c:\WINNT\system32\config\security.log EXCLUDE.FILE c:\WINNT\system32\config\software EXCLUDE.FILE c:\WINNT\system32\config\software.log EXCLUDE.FILE c:\WINNT\system32\config\system EXCLUDE.FILE c:\WINNT\system32\config\system.alt EXCLUDE.FILE c:\Program Files\Tivoli\TSM\baclient\dsmsched.log EXCLUDE.FILE c:\WINNT\system32\dns\dns.log EXCLUDE.FILE c:\WINNT\system32\PERFLIB_*.* Thanks for any input, John ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **
Re: Inclexcl not picking up Management Class
Dwight, They read as backslahes when i send them probably \\boxwa009\d$ so try \\boxwa009\d$\...\* is a good thought, but I looked at the filespace for this box which shows \\boxwa009\d$ and a similar box that works and that shows \\boxwz001\g$ so no real difference. thanks, John Cook, Dwight E [EMAIL PROTECTED] on 02/07/2003 04:04:24 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSE) Subject: Re: Inclexcl not picking up Management Class I'll assume you did have backslashes when you used them in the include/exclude statement and not the slashes you have in your note... I've found that when in doubt, ask TSM what it expects... Try doing a q file boxwa009 and take its specification for D: and use it... probably \\boxwa009\d$ so try \\boxwa009\d$\...\* just a thought. Dwight -Original Message- From: John Naylor [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 9:55 AM To: [EMAIL PROTECTED] Subject: Inclexcl not picking up Management Class Hi All, I have an annoying problem Hopefully the Doc will be able to fix me up Seriously, I need to make a particular drive in a WINNT client use large capacity tapes for its backups I have a management class LARGE which does this and works for other clients in this domain For this particular client, however we code the option file and we have tried a lot of variations it insists on seeing this line per query inclexcl :- include d:*large as include d:/.../* I know the line is being read because the query incl/excl shows it in a different position if I move it around in the options file. The full options file follows:- PASSWORDACCESSGENERATE TCPSERVERADDRESSIBMBK NODENAME BOXWA009 schedmode prompted DOMAIN c: D: E: L: include d:*large Exclude.File e:\pagefile.sys EXCLUDE.DIR c:\temp EXCLUDE.DIR c:\Program Files\Sophos SWEEP for NT EXCLUDE.DIR c:\Documents And Settings EXCLUDE.FILE c:\WINNT\system32\config\default EXCLUDE.FILE c:\WINNT\system32\config\default.log EXCLUDE.FILE c:\WINNT\system32\config\sam EXCLUDE.FILE c:\WINNT\system32\config\sam.log EXCLUDE.FILE c:\WINNT\system32\config\security EXCLUDE.FILE c:\WINNT\system32\config\security.log EXCLUDE.FILE c:\WINNT\system32\config\software EXCLUDE.FILE c:\WINNT\system32\config\software.log EXCLUDE.FILE c:\WINNT\system32\config\system EXCLUDE.FILE c:\WINNT\system32\config\system.alt EXCLUDE.FILE c:\Program Files\Tivoli\TSM\baclient\dsmsched.log EXCLUDE.FILE c:\WINNT\system32\dns\dns.log EXCLUDE.FILE c:\WINNT\system32\PERFLIB_*.* Thanks for any input, John ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **
Re: TSM for Oracle
As I understand the reply from Neil Rasmussen, Oracle 9.2.x is supported at TDPO 2.2.1 with exeption for AIX 5 64bit where you need the (TDP) 5.1.5. I beleve Neil is answering my question earlier today where I was asking if TDPO 2.2.1 where supported for Oracle 9.2 on HP-UX (11i). So I will try it after the weekend but it seems like the RMAN relinking instructions need to be modified for Oracle 9.2 on HP-UX (not absolutely sure, as the HP box is at customers site). If I understand Neil right, your configuration should be: AIX 4.3.3.10 Oracle 9.2.0.1.0 TDP 2.2.1 TSM client/server 4.2.1 or higher best regards, Kolbeinn shekhar Dhotre Shekhar.Dhotre@LENDLE To: [EMAIL PROTECTED] ASEREI.COMcc: Sent by: ADSM: Dist Subject: Re: TSM for Oracle Stor Manager [EMAIL PROTECTED] 07.02.2003 16:04 Please respond to ADSM: Dist Stor Manager As a side note to one of the subsribers questions: TDP Oracle 2.2.1 supports Oracle 9i. The only exception is for Oracle 9.2 on AIX 5 64bit, you will need to download the Data Protection for Oracle 5.1.5 ptf from IBM ftp site for support on this platform. IS following configuration supported ? AIX 4.3.3.10 Oracle 9.2.0.1.0 TDP 5.1.5 TSM client/server 5.x . I talked to TSM support and they told me that- It will require AIX5.1 instead AIX4.3.3.10 in order to make above configuration work. Thank You Shekhar Dhotre. Sr.Midrange Engineer. Lend Lase , GSDC. Neil Rasmussen [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 10:50 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM for Oracle Orin, I see that there are many subscribers willing to help you with whatever you situation is with Data Protection for Oracle. Can you please be more specific (I'm asking for it, huh?) about the complexities being faced? I must assume, because you mention TSM for Oracle, that your troubles stem from the TSM side. Is there anything specific that makes the setup complex? Is it installation, or configuring, or using Data Protection for Oracle or the TSM Server? I look forward to hearing from you. As a side note to one of the subsribers questions: TDP Oracle 2.2.1 supports Oracle 9i. The only exception is for Oracle 9.2 on AIX 5 64bit, you will need to download the Data Protection for Oracle 5.1.5 ptf from IBM ftp site for support on this platform. -- Date:Thu, 6 Feb 2003 11:04:47 -0600 From:Orin Rehorst [EMAIL PROTECTED] Subject: TSM for Oracle Due to the complexity of using TSM for Oracle, management here is about ready to replace TSM altogether. Anyone know of a class available for this topic? BTW, IBM has a web page for such a course listed at http://www-3.ibm.com/software/tivoli/education/J104126F96394E48.html, but an IBM employee told me the course doesn't actually exist! Regards, Orin Orin Rehorst Port of Houston Authority (Largest U.S. port in foreign tonnage) e-mail: [EMAIL PROTECTED] Phone: (713)670-2443 Fax: (713)670-2457 TOPAS web site: www.homestead.com/topas/topas.html -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: Move nodedata
You need to isolate the data for that server/filespace in the copypool in order to delete ONLY that data. I've used this brute force method before: Turn colocation on for the copypool at client/filespace level as needed. find copypool volumes containing data for the client using: select volume_name from volumeusage where node_name='...client name...' and stgpool_name='...blah...' and filespace_name='..fs name as needed' MOVE DATA for each of these volumes (this should create a new set of tapes containing only the data for the specific node UPD vol ...blah... ACC=reado for output volumes from step 3 Turn off colocation on copypool Optionally, Q CON for each volume from step 3 to verify what's on each volume from step 3 DEL VOL DISCARDD=YES for each volume from step 3 If someone's got a better way, please let me know! Over a year ago I submitted these enhancement requests Add the NODENAME= parameter to the MOVE DATA command (we got a partial solution with the MOVE NODEDATA, but it only works for primary pools) Add the STGPOOL= parameter to the DELETE FILESPACE command (this would eliminate the steps above) By allowing MOVE NODEDATA to work with copypools and by providing the enhanced DELETE FILESPACE, we gain much needed ability to manage our backend storage. -- Al John Naylor [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/05/03 04:51 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: Move nodedata Can't you just delete the volumes in the old copy storage pool ? That seems too easy, so I could be wrong Zlatko Krastev/ACIT [EMAIL PROTECTED] on 02/05/2003 06:15:11 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSE) Subject: Re: Move nodedata Bruce, your mistake is *by design*. You can move data (with both move data and move nodedata) between *primary* pools. Copypools *do not* contain node's data, they contain primary pools' data copies. To achieve the goal I would suggest you the following: 1. create new primary pool (if not done already) 2. create new policy domain, set its copygroups to point new primary pool and move the node into it 3. export the node's data, delete filespaces ... 4. ... and import it back (sorry I know it is time consuming and might look silly) 5. backup the primary pool to second copypool (C1_FS_DRMP) Now what am I proposing: - in step 3 the data will be deleted from both originating primary pool and the source copypool. This is the only way I know to clean up the copypool. - in step 4 the data will be imported back into the server but in new primary pool. - steps 3-4 result similar to move nodedata but with deletion from copypool - step 5 is explanatory by itself If you can afford the data to stay in old copypool until it expires on its own you can use move nodedata and backup stgpool to finish faster. If you insist to clean the old copypool and have copies only in primary pools and new copypool then you have to go down the export-import road. Zlatko Krastev IT Consultant Kamp, Bruce [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03.02.2003 14:03 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Move nodedata I need to move a couple of nodes from one offsite copy pool to another offsite copy pool. I tried using the move nodedata command but It gives me the following error: ANR1719E Storage pool C1_FS_DRMP specified on the MOVE NODEDATA command is not a valid pool name or pool type. ANS8001I Return code 3. This is the command I was using: move nodedata tsmserv from=drmpool to=C1_FS_DRMP TYPE=any From reading the help is it my understanding that I can not do this with the move nodedata? If not. Will this work? 1. Bind nodes to new management class. 2. Use move nodedata command to move onsite data to new storage pool. 3. Use backup stgpool from new onsite storage pool to new offsite copy storage pool. 4. This is the step I'm not sure about! How do I remove the data from the old offsite storage pool? Thanks, -- Bruce Kamp Midrange Systems Analyst II Memorial Healthcare System E: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] P: (954) 987-2020 x4597 F: (954) 985-1404 --- ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error
Re: Inclexcl not picking up Management Class
Kolbeinn, Thats very interesting about the management class not showing in the query inclexcl. That threw me off the scent, and here I hang my head in shame. I did not do the standard thing which I always normally do, and thats check to see whether the management class is being used in the backups. It is, so I have a different problem from what I thought, which I am currently looking at. The problem is now that I have a management class that is being used and points to a disk storage pool that has a next pool of large capacity tapes. I will have to do a query occ before the next disk migration. Again apologies to the list for a misleading query. thanks, John Kolbeinn Josepsson [EMAIL PROTECTED] on 02/07/2003 04:42:40 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSE) Subject: Re: Inclexcl not picking up Management Class Hi John, dsmc q inclexcl will only show the incude exclude parameters, not mgmt class parameter. You can see if file is bound to the mgmt class using the GUI, in the backup view, right-click the mouse on the file. To see if it is backed up bound to this mgmt class, use the restore view. Remember to stop/start the scheduler after you change the inclexcl or dsm.opt file. Best regards, Kolbeinn Josepsson - Systems Engineer Tivoli Certified Consultant - IBM TSM V5.1 www.nyherji.is John Naylor john.naylor@SCOTTISH-SOUT To: [EMAIL PROTECTED] HERN.CO.UKcc: Sent by: ADSM: Dist Stor Subject: Inclexcl not picking up Management Class Manager [EMAIL PROTECTED] 07.02.2003 15:54 Please respond to ADSM: Dist Stor Manager Hi All, I have an annoying problem Hopefully the Doc will be able to fix me up Seriously, I need to make a particular drive in a WINNT client use large capacity tapes for its backups I have a management class LARGE which does this and works for other clients in this domain For this particular client, however we code the option file and we have tried a lot of variations it insists on seeing this line per query inclexcl :- include d:*large as include d:/.../* I know the line is being read because the query incl/excl shows it in a different position if I move it around in the options file. The full options file follows:- PASSWORDACCESSGENERATE TCPSERVERADDRESSIBMBK NODENAME BOXWA009 schedmode prompted DOMAIN c: D: E: L: include d:*large Exclude.File e:\pagefile.sys EXCLUDE.DIR c:\temp EXCLUDE.DIR c:\Program Files\Sophos SWEEP for NT EXCLUDE.DIR c:\Documents And Settings EXCLUDE.FILE c:\WINNT\system32\config\default EXCLUDE.FILE c:\WINNT\system32\config\default.log EXCLUDE.FILE c:\WINNT\system32\config\sam EXCLUDE.FILE c:\WINNT\system32\config\sam.log EXCLUDE.FILE c:\WINNT\system32\config\security EXCLUDE.FILE c:\WINNT\system32\config\security.log EXCLUDE.FILE c:\WINNT\system32\config\software EXCLUDE.FILE c:\WINNT\system32\config\software.log EXCLUDE.FILE c:\WINNT\system32\config\system EXCLUDE.FILE c:\WINNT\system32\config\system.alt EXCLUDE.FILE c:\Program Files\Tivoli\TSM\baclient\dsmsched.log EXCLUDE.FILE c:\WINNT\system32\dns\dns.log EXCLUDE.FILE c:\WINNT\system32\PERFLIB_*.* Thanks for any input, John ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **
Re: SQL problem ....
try this: select sum(physical_mb)-(select sum(physical_mb) from occupancy where stgpool_name='COPYLTO1_WIN') from occupancy where stgpool_name ='TAPELTO1_WIN' PAC Brion Arnaud Arnaud.Brion@PAN To: [EMAIL PROTECTED] ALPINA.COM cc: Sent by: ADSM: Subject: SQL problem Dist Stor Manager [EMAIL PROTECTED] .EDU 07.02.2003 10:42 Please respond to ADSM: Dist Stor Manager Hi list, Could any SQL genius explain me wat is wrong with this statement : select sum(physical_mb) from occupancy where stgpool_name='TAPELTO1_WIN' - (select sum(physical_mb) from occupancy where stgpool_name='COPYLTO1_WIN' ) When trying to use it II get following output : ANR2916E The SQL data types CHAR(12) and DECIMAL(31,2) are incompatible for operator '-'. I already tried to add dec() on both selects without achieving any valuable result ... is it a bug or do I need additional coffee to wake up my mind ? What I'm trying to achieve is to calculate the remaining amount of data to copy before a backup stgpool process finishes. Thanks in advance ! Cheers. 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 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Re: TSM for Oracle
As I understand the reply from Neil Rasmussen, Oracle 9.2.x is supported at TDPO 2.2.1 with exeption for AIX 5 64bit where you need the (TDP) 5.1.5. Not true : Tivoli Data Protection for Oracle for UNIX Installation and User's Guide Version 2 Release 2.1 Preface Tivoli Data Protection for Oracle performs online or offline backups of Oracle8i (Version 8.1.7) and Oracle9i (Version 9.0.1) databases to Tivoli Storage Manager storage. This integration with the RMAN Media Management API maximizes the protection of data, thus providing a comprehensive storage management solution. Thank You Shekhar Dhotre. Sr.Midrange Engineer. Lend Lase , GSDC. PH: 1+404-846-7483 Kolbeinn Josepsson [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 11:59 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM for Oracle As I understand the reply from Neil Rasmussen, Oracle 9.2.x is supported at TDPO 2.2.1 with exeption for AIX 5 64bit where you need the (TDP) 5.1.5. I beleve Neil is answering my question earlier today where I was asking if TDPO 2.2.1 where supported for Oracle 9.2 on HP-UX (11i). So I will try it after the weekend but it seems like the RMAN relinking instructions need to be modified for Oracle 9.2 on HP-UX (not absolutely sure, as the HP box is at customers site). If I understand Neil right, your configuration should be: AIX 4.3.3.10 Oracle 9.2.0.1.0 TDP 2.2.1 TSM client/server 4.2.1 or higher best regards, Kolbeinn shekhar Dhotre Shekhar.Dhotre@LENDLE To: [EMAIL PROTECTED] ASEREI.COMcc: Sent by: ADSM: Dist Subject: Re: TSM for Oracle Stor Manager [EMAIL PROTECTED] 07.02.2003 16:04 Please respond to ADSM: Dist Stor Manager As a side note to one of the subsribers questions: TDP Oracle 2.2.1 supports Oracle 9i. The only exception is for Oracle 9.2 on AIX 5 64bit, you will need to download the Data Protection for Oracle 5.1.5 ptf from IBM ftp site for support on this platform. IS following configuration supported ? AIX 4.3.3.10 Oracle 9.2.0.1.0 TDP 5.1.5 TSM client/server 5.x . I talked to TSM support and they told me that- It will require AIX5.1 instead AIX4.3.3.10 in order to make above configuration work. Thank You Shekhar Dhotre. Sr.Midrange Engineer. Lend Lase , GSDC. Neil Rasmussen [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 10:50 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM for Oracle Orin, I see that there are many subscribers willing to help you with whatever you situation is with Data Protection for Oracle. Can you please be more specific (I'm asking for it, huh?) about the complexities being faced? I must assume, because you mention TSM for Oracle, that your troubles stem from the TSM side. Is there anything specific that makes the setup complex? Is it installation, or configuring, or using Data Protection for Oracle or the TSM Server? I look forward to hearing from you. As a side note to one of the subsribers questions: TDP Oracle 2.2.1 supports Oracle 9i. The only exception is for Oracle 9.2 on AIX 5 64bit, you will need to download the Data Protection for Oracle 5.1.5 ptf from IBM ftp site for support on this platform. -- Date:Thu, 6 Feb 2003 11:04:47 -0600 From:Orin Rehorst [EMAIL PROTECTED] Subject: TSM for Oracle Due to the complexity of using TSM for Oracle, management here is about ready to replace TSM altogether. Anyone know of a class available for this topic? BTW, IBM has a web page for such a course listed at http://www-3.ibm.com/software/tivoli/education/J104126F96394E48.html, but an IBM employee told me the course doesn't actually exist! Regards, Orin Orin Rehorst Port of Houston Authority (Largest U.S. port in foreign tonnage) e-mail: [EMAIL PROTECTED] Phone: (713)670-2443 Fax: (713)670-2457 TOPAS web site: www.homestead.com/topas/topas.html -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: groupid change creates a modified file copy
From: Alexander Lazarevich [mailto:[EMAIL PROTECTED]] 3) If we change a group id of a file, then the server backs up this modified file as a modifed copy, thus having 2 copies of the file on tape, one copy owned by each group. 4) Is there any way to turn off this function so that a change in the group id does NOT create a mocified backup copy? TSM does not include a feature to cripple its primary function--backing up modified files. Rather than change the group ID, why not modify the aspects of the existing ID? This would be easier than going through directory after directory and modifying files, and it would alleviate the need for a large backup. -- Mark Stapleton ([EMAIL PROTECTED])
Re: TSM for Oracle
I think it is because Oracle 9.0.1 was probably the highest level at the time when the installation and user guide was published. Following is taken from the IBM website http://www-1.ibm.com/support/docview.wss?rs=666context=SSTFZRq=oracleuid=swg21066380: Data Protection for Oracle Ver 2.2.1 on HP-UX Hardware requirements: HP 9000 series 700 or 800 workstation with 96 MB RAM and 6 MB Disk space. Software requirements: * HP-UX 11.0 (32-bit or 64-bit) or 11i (32-bit or 64-bit) * Oracle8i Release 8.1.7, or Oracle8i 8.1.7 Parallel Server, or Oracle9i 9.0.1 or later, or Oracle9i 9.0.1 Real Application Clusters or later * Tivoli Storage Manager server * Tivoli Storage Manager API Version 4.2.1, or later It states Oracle9i 9.0.1 or later Best regards, Kolbeinn shekhar Dhotre Shekhar.Dhotre@LENDLE To: [EMAIL PROTECTED] ASEREI.COMcc: Sent by: ADSM: Dist Subject: Re: TSM for Oracle Stor Manager [EMAIL PROTECTED] 07.02.2003 17:14 Please respond to ADSM: Dist Stor Manager As I understand the reply from Neil Rasmussen, Oracle 9.2.x is supported at TDPO 2.2.1 with exeption for AIX 5 64bit where you need the (TDP) 5.1.5. Not true : Tivoli Data Protection for Oracle for UNIX Installation and User's Guide Version 2 Release 2.1 Preface Tivoli Data Protection for Oracle performs online or offline backups of Oracle8i (Version 8.1.7) and Oracle9i (Version 9.0.1) databases to Tivoli Storage Manager storage. This integration with the RMAN Media Management API maximizes the protection of data, thus providing a comprehensive storage management solution. Thank You Shekhar Dhotre. Sr.Midrange Engineer. Lend Lase , GSDC. PH: 1+404-846-7483 Kolbeinn Josepsson [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 11:59 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM for Oracle As I understand the reply from Neil Rasmussen, Oracle 9.2.x is supported at TDPO 2.2.1 with exeption for AIX 5 64bit where you need the (TDP) 5.1.5. I beleve Neil is answering my question earlier today where I was asking if TDPO 2.2.1 where supported for Oracle 9.2 on HP-UX (11i). So I will try it after the weekend but it seems like the RMAN relinking instructions need to be modified for Oracle 9.2 on HP-UX (not absolutely sure, as the HP box is at customers site). If I understand Neil right, your configuration should be: AIX 4.3.3.10 Oracle 9.2.0.1.0 TDP 2.2.1 TSM client/server 4.2.1 or higher best regards, Kolbeinn shekhar Dhotre Shekhar.Dhotre@LENDLE To: [EMAIL PROTECTED] ASEREI.COMcc: Sent by: ADSM: Dist Subject: Re: TSM for Oracle Stor Manager [EMAIL PROTECTED] 07.02.2003 16:04 Please respond to ADSM: Dist Stor Manager As a side note to one of the subsribers questions: TDP Oracle 2.2.1 supports Oracle 9i. The only exception is for Oracle 9.2 on AIX 5 64bit, you will need to download the Data Protection for Oracle 5.1.5 ptf from IBM ftp site for support on this platform. IS following configuration supported ? AIX 4.3.3.10 Oracle 9.2.0.1.0 TDP 5.1.5 TSM client/server 5.x . I talked to TSM support and they told me that- It will require AIX5.1 instead AIX4.3.3.10 in order to make above configuration work. Thank You Shekhar Dhotre. Sr.Midrange Engineer. Lend Lase , GSDC. Neil Rasmussen [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 10:50 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM for Oracle Orin, I see that there are many subscribers willing to help you with whatever you situation is with Data Protection for Oracle. Can you please be more specific (I'm asking for it, huh?) about the complexities being faced? I must assume, because you mention TSM for Oracle, that your troubles stem from the TSM side. Is there anything specific that makes the setup complex? Is it installation, or configuring, or using Data Protection for Oracle or the TSM Server? I look forward to hearing from you. As a side note to one of the subsribers questions: TDP Oracle 2.2.1 supports Oracle 9i. The only exception is for Oracle 9.2 on AIX 5 64bit, you will need to download the Data Protection for Oracle 5.1.5 ptf from IBM ftp site for support on this platform. -- Date:Thu, 6 Feb 2003 11:04:47 -0600 From:Orin Rehorst [EMAIL PROTECTED] Subject: TSM for Oracle Due to the complexity of using TSM for Oracle, management here is about ready to replace TSM altogether. Anyone know of a class available for this topic? BTW, IBM has a web page for such a course listed at
Re: PMR 02528, 082
[lobbing armor piercing verbage] Oh ye of narrow vision and holder of golden horseshoe of hardware luck: 1. Have you ever lost a stg pool disk? And before you answer well ya just backup again 2. SOME DATA IS IMPOSSIBLE TO BACKUP AGAIN! 3. I REPEAT! Along with regular clients, I backup data from Sybase and Oracle via SQLBACKTRACK. Some of this data is an incremental. In this case incremental FROM WITHIN the db server. IE point-in-time data of pages that have changed. Should that data be lost, there is no way to restore beyond what was lost unless another FULL or complete backup has been created, but it then could be the case that the full is too late a point-in-time. Yup, I already been down that road, and there isn't any good sights to see. Since then, I use raid-5 storage pools with floating hot spares whereever I can. I know I'm still open to hardware failure issues, but the likelyhood of taking a hit is greatly reduced. Performance hit? Our performance measurement guy saw almost not difference in throughput with raid-5 versus non raid-5 in the TSM environment. Basically says to me that the ever famed bottleneck isn't visiting dasd land right now. Also keep in mind that NO storage layout/method/etc can protect against corrupted data being written. -- Al Stapleton, Mark [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/03 08:51 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: PMR 02528, 082 From Steven Schraer: It looks like for storage pools are recommend for raid 0 (mirroring), raid 0+1 (mirroring stripping) or raid 5 (distributed parity). These are 0+safe methods to protect the storage pool. Do you know of any companies that use just raid 1 (stripping) on their storage pools? Is there an issue of tsm loosing a storage pool and the database having issues due to the lost storage pool data? From: William Rosette [mailto:[EMAIL PROTECTED]] Does any TSM gurus have any suggestions for our AIX admin [donning my advocacy armor] I still don't see any reason to create redundancy for the disk storage pool. Unless you're not using a tape library, there's no reason for it. The disk pool should get flushed to a more stable medium, and that flush should take place fairly soon after the client backups to disk finish. Why waste gobs of disk on something that's going to flushed clear every day? As far the db and log are concerned, just create volume copies with TSM and make sure the copies are on disks that are on separate disks. That's really all there is to it. -- Mark Stapleton ([EMAIL PROTECTED])
AW: backup every hour in TSM ..
Hi, I'm no DB admin but I think you can configure ORACLE in a way that for every new archive log a backup of this log is started. If you send this logs to a disk storagepool your backup will be as close to 'real live' as possible. Kind regards Thomas Rupp -Ursprüngliche Nachricht- Von: shekhar Dhotre [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 07. Februar 2003 16:56 An: [EMAIL PROTECTED] Betreff: backup every hour in TSM .. Hi All, we want to backup oracle transaction logs every hour /everyday of the week .Currently the model of backing up everything once a day permits losing an entire days worth of data which isn't necessary. Any ideas on how I can schedule this job in TSM ? Thank You Shekhar Dhotre. Sr.Midrange Engineer. Lend Lase , GSDC. www.lendlease.com
Re: TSM for Oracle
I forgot your case, AIX 4.3.3: From the IBM web, TDPO 2.2.1 supports Oracle 9i 9.0.1 or later (64-bit) for AIX 4.3.3 - if I understand right: Data Protection for Oracle Ver 2.2.1 on AIX Hardware requirements: RS/6000 or pSeries with 96 MB RAM and 6 MB Disk space. Software requirements: * AIX 4.3.3 (32-bit) or AIX 5.1 (32-bit) for Oracle 8i Release 8.1.7 (32-bit), or Oracle 8i 8.1.7 Parallel Server (32-bit) * AIX 4.3.3 for Oracle 8i Release 8.1.7 (64-bit), or Oracle 8i Release 8.1.7 Parallel Server (64-bit), or Oracle 9i 9.0.1 or later (64-bit), or Oracle 9i 9.0.1 or later Real Application Clusters (64-bit) * AIX 5.1 (32-bit or 64-bit) or AIX 5.2 (32-bit or 64-bit) for Oracle 9i Release 9.2.0 or later (64-bit) and Oracle 9i Release 9.2.0 or later Real Application Clusters (64-bit) is available on the web. See the ITSM for Databases page Self Help Downloads window for the package. * A Tivoli Storage Manager server * Tivoli Storage Manager API V4.2.1, or later best rgds kolbeinn __ I think it is because Oracle 9.0.1 was probably the highest level at the time when the installation and user guide was published. Following is taken from the IBM website http://www-1.ibm.com/support/docview.wss?rs=666context=SSTFZRq=oracleuid=swg21066380: Data Protection for Oracle Ver 2.2.1 on HP-UX Hardware requirements: HP 9000 series 700 or 800 workstation with 96 MB RAM and 6 MB Disk space. Software requirements: * HP-UX 11.0 (32-bit or 64-bit) or 11i (32-bit or 64-bit) * Oracle8i Release 8.1.7, or Oracle8i 8.1.7 Parallel Server, or Oracle9i 9.0.1 or later, or Oracle9i 9.0.1 Real Application Clusters or later * Tivoli Storage Manager server * Tivoli Storage Manager API Version 4.2.1, or later It states Oracle9i 9.0.1 or later Best regards, Kolbeinn shekhar Dhotre Shekhar.Dhotre@LENDLE To: [EMAIL PROTECTED] ASEREI.COMcc: Sent by: ADSM: Dist Subject: Re: TSM for Oracle Stor Manager [EMAIL PROTECTED] 07.02.2003 17:14 Please respond to ADSM: Dist Stor Manager As I understand the reply from Neil Rasmussen, Oracle 9.2.x is supported at TDPO 2.2.1 with exeption for AIX 5 64bit where you need the (TDP) 5.1.5. Not true : Tivoli Data Protection for Oracle for UNIX Installation and User's Guide Version 2 Release 2.1 Preface Tivoli Data Protection for Oracle performs online or offline backups of Oracle8i (Version 8.1.7) and Oracle9i (Version 9.0.1) databases to Tivoli Storage Manager storage. This integration with the RMAN Media Management API maximizes the protection of data, thus providing a comprehensive storage management solution. Thank You Shekhar Dhotre. Sr.Midrange Engineer. Lend Lase , GSDC. PH: 1+404-846-7483 Kolbeinn Josepsson [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 11:59 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM for Oracle As I understand the reply from Neil Rasmussen, Oracle 9.2.x is supported at TDPO 2.2.1 with exeption for AIX 5 64bit where you need the (TDP) 5.1.5. I beleve Neil is answering my question earlier today where I was asking if TDPO 2.2.1 where supported for Oracle 9.2 on HP-UX (11i). So I will try it after the weekend but it seems like the RMAN relinking instructions need to be modified for Oracle 9.2 on HP-UX (not absolutely sure, as the HP box is at customers site). If I understand Neil right, your configuration should be: AIX 4.3.3.10 Oracle 9.2.0.1.0 TDP 2.2.1 TSM client/server 4.2.1 or higher best regards, Kolbeinn shekhar Dhotre Shekhar.Dhotre@LENDLE To: [EMAIL PROTECTED] ASEREI.COMcc: Sent by: ADSM: Dist Subject: Re: TSM for Oracle Stor Manager [EMAIL PROTECTED] 07.02.2003 16:04 Please respond to ADSM: Dist Stor Manager As a side note to one of the subsribers questions: TDP Oracle 2.2.1 supports Oracle 9i. The only exception is for Oracle 9.2 on AIX 5 64bit, you will need to download the Data Protection for Oracle 5.1.5 ptf from IBM ftp site for support on this platform. IS following configuration supported ? AIX 4.3.3.10 Oracle 9.2.0.1.0 TDP 5.1.5 TSM client/server 5.x . I talked to TSM support and they told me that- It will require AIX5.1 instead AIX4.3.3.10 in order to make above configuration work. Thank You Shekhar Dhotre. Sr.Midrange Engineer. Lend Lase , GSDC. Neil Rasmussen [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/2003 10:50 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: TSM for Oracle Orin, I see that there are many subscribers willing to help you with whatever you situation is with Data
Re: PMR 02528, 082
And ya know... this is why I just LOVE TSM ! you can do anything you want... take one drawer of SSA and set it up as JBOD and put it all as a storage pool for non-critical backups/archives take another drawer of SSA and set it up in a raid of your choice for more critical backups/archives bleed either or both of those into tape pools that have copy pools or ones that don't do things like, with hsm, force a backup to exist prior to migration, make the backups go to different storage pools than the migrated data, yadayadayada... Any level of protection I've ever been asked/required to provide, I've been able to achieve with ADSM / TSM. Dwight -Original Message- From: Allen Barth [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 11:41 AM To: [EMAIL PROTECTED] Subject: Re: PMR 02528, 082 [lobbing armor piercing verbage] Oh ye of narrow vision and holder of golden horseshoe of hardware luck: 1. Have you ever lost a stg pool disk? And before you answer well ya just backup again 2. SOME DATA IS IMPOSSIBLE TO BACKUP AGAIN! 3. I REPEAT! Along with regular clients, I backup data from Sybase and Oracle via SQLBACKTRACK. Some of this data is an incremental. In this case incremental FROM WITHIN the db server. IE point-in-time data of pages that have changed. Should that data be lost, there is no way to restore beyond what was lost unless another FULL or complete backup has been created, but it then could be the case that the full is too late a point-in-time. Yup, I already been down that road, and there isn't any good sights to see. Since then, I use raid-5 storage pools with floating hot spares whereever I can. I know I'm still open to hardware failure issues, but the likelyhood of taking a hit is greatly reduced. Performance hit? Our performance measurement guy saw almost not difference in throughput with raid-5 versus non raid-5 in the TSM environment. Basically says to me that the ever famed bottleneck isn't visiting dasd land right now. Also keep in mind that NO storage layout/method/etc can protect against corrupted data being written. -- Al Stapleton, Mark [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/03 08:51 AM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: PMR 02528, 082 From Steven Schraer: It looks like for storage pools are recommend for raid 0 (mirroring), raid 0+1 (mirroring stripping) or raid 5 (distributed parity). These are 0+safe methods to protect the storage pool. Do you know of any companies that use just raid 1 (stripping) on their storage pools? Is there an issue of tsm loosing a storage pool and the database having issues due to the lost storage pool data? From: William Rosette [mailto:[EMAIL PROTECTED]] Does any TSM gurus have any suggestions for our AIX admin [donning my advocacy armor] I still don't see any reason to create redundancy for the disk storage pool. Unless you're not using a tape library, there's no reason for it. The disk pool should get flushed to a more stable medium, and that flush should take place fairly soon after the client backups to disk finish. Why waste gobs of disk on something that's going to flushed clear every day? As far the db and log are concerned, just create volume copies with TSM and make sure the copies are on disks that are on separate disks. That's really all there is to it. -- Mark Stapleton ([EMAIL PROTECTED])
Re: Over extended log
As far as Log sizing, I think the only log size that makes any sense is exactly 12gb. Why make it smaller, when disks are so cheap? And you cannot make it larger, because as you say, you've got to leave yourself someplace to go when it fills up. However, what you are doing with archive-delete sounds dangerous, even with the log in rollforward mode. I would never complete the delete part of an archive-delete without some kind of safety mechanism, such as delaying the delete by one day. I know TSM is good, but you are well aware of the risk because you refuse to run in Normal mode. I would go farther, and not delete the file from the original system until I knew it has been migrated from the disk storage pool to the tape storage pool, and also copied to the backup copy storage pool. Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED] On Thu, 6 Feb 2003, Lisa Cabanas wrote: I've successfully used roll-forward, and I never *yes, never* extend the log to its fullest, so I will be able to do an emergency extend. I guess that's the most important consideration-- leaving yourself someplace to go. Not using roll-forward is a gothca in an environment where archive-deletes are done. If you do an archive-delete and the server goes down and you need to get it back-- you'll only be able to go as far as the last dbbackup-- and your archived files are gone (database has no record of them) and they are deleted on the client box (it didn't go back in time).
Re: Multiple Emails from this group
Now that you guys mentioned this yesterday I also received eight or nine completely empty emails (???!!). Mario Behring Zlatko Krastev/ACIT [EMAIL PROTECTED] wrote:I also got nine completely empty (except complains added by my mail server). No headers, empty body, empty subject (actually missing as all other headers). People with Re:-only at least got something :-) Zlatko Krastev IT Consultant Jason Stoessler Sent by: ADSM: Dist Stor Manager 07.02.2003 10:46 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject: Re: Multiple Emails from this group I have received about 6 blank emails so far all addressed the same. Anyone know why?? Thanks, Jason -Original Message- From: Jeff G Kloek [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 12:33 AM To: [EMAIL PROTECTED] Subject: Multiple Emails from this group I am receiving tons of empty emails addressed from [EMAIL PROTECTED]. Is anyone else? The subject is simply Re:, and there is no text. Thanks. ** 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 has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** - Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now
Re: summary-table
I believe this is more than a server issue. I have been assured it is fixed in 5.1.1.2 and higher, but I have not installed it yet. Apparently, the client needs to be updated as well to get a complete fix. I do not know if there is a client level for 4.2.3.2 and higher that completely eliminates the problem. Paul D. Seay, Jr. Technical Specialist Northrop Grumman Information Technology 757-688-8180 -Original Message- From: Christoph Pilgram [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 5:55 AM To: [EMAIL PROTECTED] Subject: summary-table Hi all, since installing the 4.2.3.2 level (after 4.1.4) on my AIX-server (AIX 4.3.3) I have the problem that in the summary-table the field BYTES for a backup-session of NT and W2K-clients is filled with 0 even though the client has transfered GigaBytes of data. Restore-sessions of the same client show a correct number of bytes in that field. Unix-Clients show (what I have seen) correct entries in that field. Thanks for help Chris
Vaulting recovery plan from AIX server
We currently run a 4.2.3.2 TSM server under an OS/390 system that also supports several other applications. The system is running out of resources, and we are looking at a number of options for upgrading it or moving part of its workload elsewhere. One of these options is moving the TSM server to an AIX system. There are a number of uncertainties about the operational changes this would entail, one of which is how we would vault the recovery plan files produced by the Disaster Recovery Manager component of TSM. We currently copy the recovery plan to a second file on the tape containing the corresponding database backup. Is it possible to do the same thing with an AIX TSM server? If not, what alternatives are other sites using? There is one major constraint on our choice. When we run disaster recovery tests our network operations staff and our hot site provider's staff usually spend a couple of hours troubleshooting network connections. This is annoying but tolerable if work on rebuilding the TSM server can procede concurrently with the debugging. It would be a disaster if access to the recovery plan file had to wait for successful completion of network troubleshooting.
Re: summary-table
At 3:19 PM -0500 2/7/03, Seay, Paul wrote: Apparently, the client needs to be updated as well to get a complete fix. I do not know if there is a client level for 4.2.3.2 and higher that completely eliminates the problem. According to the info I got from TSM support, for what I think is the same problem: The APARs that describe this are IC33840 for the client and IC34693 for the TSM server. Both a client fix and a server fix need to be applied. ` The client fixtests are in Client fixtests 5.1.5.2 and 4.2.3.1. go to... ftp://service.boulder.ibm.com/storage/tivoli-storage-management/ patches/client/v4r2/ ` and then platform and the v423 directory or folder. For the V4.2 Win98/Me platform only, the fixtest is 4.2.3.2. These fixtests must be used in conjunction with the server fix. I haven't tried to apply any of the indicated fixes. -- Matt Simpson -- OS/390 Support 219 McVey Hall -- (859) 257-2900 x300 University Of Kentucky, Lexington, KY 40506 mailto:[EMAIL PROTECTED] mainframe -- An obsolete device still used by thousands of obsolete companies serving billions of obsolete customers and making huge obsolete profits for their obsolete shareholders. And this year's run twice as fast as last year's.
Future of mainframe TSM
We run a 4.2.3.2 TSM server under OS/390. We have about 110 active client systems, sending about 300,000 files and about 70 gigabytes to the server each night. Our best estimate is that this workload will double in the next two years. Is it reasonable to stay with an OS/390 or zOS server in the face of the projected growth? If so, how do we prove that the mainframe is up to the task? Most IT managers around here want to believe that the mainframe is the wrong choice for TSM or anything else.
export/import via virtual vols help
Hi list- Due to some restructuring, I need to export node 'x' from TSM server 'k' and then import it to TSM server 'c'. I want to use virtual vols. I set up the server-server comm stuff, devc, and client nodes as needed. I ran the export node 'x' on server 'k' specifying a devc that points to server 'c'. While it took a while, the export completed successfully, and I saved the volusage list to nodex.vols Now on server 'c', I want to IMPORT NODE x I set up devc 'servc' on server 'c' as type=server which points to server 'c' I reg'd server 'c' as a server type client on server 'c' in the same domain as the server 'k' client definition I ftp usedvol list from server 'k' to server 'c' I issue: import node x filed=all preview=yes dev=servc vol=file:nodex.vols preview=yes What happens is server 'c' starts an internal session with itself due to the devc, but I get a message that it cannot mount the volume as read from the nodex.vols. What am I missing? Is this possible? Server 'k' is 5.1.5, server 'c' is 4.1.5, both are AIX. TIA -- Al
Re: Multiple Emails from this group
And now a boatload of e-mail about blank e-mails. ;-) -Original Message- From: Mario Behring [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 12:12 PM To: [EMAIL PROTECTED] Subject: Re: Multiple Emails from this group Now that you guys mentioned this yesterday I also received eight or nine completely empty emails (???!!). Mario Behring Zlatko Krastev/ACIT [EMAIL PROTECTED] wrote:I also got nine completely empty (except complains added by my mail server). No headers, empty body, empty subject (actually missing as all other headers). People with Re:-only at least got something :-) Zlatko Krastev IT Consultant Jason Stoessler Sent by: ADSM: Dist Stor Manager 07.02.2003 10:46 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject: Re: Multiple Emails from this group I have received about 6 blank emails so far all addressed the same. Anyone know why?? Thanks, Jason -Original Message- From: Jeff G Kloek [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 12:33 AM To: [EMAIL PROTECTED] Subject: Multiple Emails from this group I am receiving tons of empty emails addressed from [EMAIL PROTECTED]. Is anyone else? The subject is simply Re:, and there is no text. Thanks. ** 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 has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** - Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now
Re: summary-table
It's stuff like this that makes my shake my head in disbelief... The summary table was working fine will ALL my clients, regardless of version, when the server was 4.1.5. After upgrading ONLY the server to 5.1.5. the byte counts in the summary table are Zeroes. Hmmm, compatability tested? I think not! If so, where are the notices and gotcha's in the readme's? -- Al Matt Simpson [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/03 03:05 PM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: summary-table At 3:19 PM -0500 2/7/03, Seay, Paul wrote: Apparently, the client needs to be updated as well to get a complete fix. I do not know if there is a client level for 4.2.3.2 and higher that completely eliminates the problem. According to the info I got from TSM support, for what I think is the same problem: The APARs that describe this are IC33840 for the client and IC34693 for the TSM server. Both a client fix and a server fix need to be applied. ` The client fixtests are in Client fixtests 5.1.5.2 and 4.2.3.1. go to... ftp://service.boulder.ibm.com/storage/tivoli-storage-management/ patches/client/v4r2/ ` and then platform and the v423 directory or folder. For the V4.2 Win98/Me platform only, the fixtest is 4.2.3.2. These fixtests must be used in conjunction with the server fix. I haven't tried to apply any of the indicated fixes. -- Matt Simpson -- OS/390 Support 219 McVey Hall -- (859) 257-2900 x300 University Of Kentucky, Lexington, KY 40506 mailto:[EMAIL PROTECTED] mainframe -- An obsolete device still used by thousands of obsolete companies serving billions of obsolete customers and making huge obsolete profits for their obsolete shareholders. And this year's run twice as fast as last year's.
Re: Future of mainframe TSM
This will depend on the size of your mainframe, we run on OS/390, we have 6 systems running 9 LPARS, plus some extra LPARS for other workload. We have 15 instances of TSM running on various systems and run up to 8 of these on one LPAR at any time. If you want the exact size of our systems and LPARS, I would have to track those numbers down. I do know that TSM as a whole utilizes very little of our mainframe and has never had a problem keeping up and we backup 2 TB from over 800 clients nightly. The short of it is, if your mainframe has enough CPU power you will be OK. Ryan Miller Principal Financial Group Tivoli Certified Consultant Tivoli Storage Manager v4.1 -Original Message- From: Thomas Denier [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 2:45 PM To: [EMAIL PROTECTED] Subject: Future of mainframe TSM We run a 4.2.3.2 TSM server under OS/390. We have about 110 active client systems, sending about 300,000 files and about 70 gigabytes to the server each night. Our best estimate is that this workload will double in the next two years. Is it reasonable to stay with an OS/390 or zOS server in the face of the projected growth? If so, how do we prove that the mainframe is up to the task? Most IT managers around here want to believe that the mainframe is the wrong choice for TSM or anything else.
Re: export/import via virtual vols help
Been there, just done this. First all, if you are at 5.1.5, I was told by someone that you could export DIRECTLY to another server, without having to do the bogus export- then-import thing. I would look into that, as it should be easier to implement than what you are doing. Second, I have had little success in the past using export/import where the target server was at a lower version than the source server (kinda makes sense, since the data base can change from one version to the next), so I don't think this is guaranteed to work. That being said, if you did the setup using the admin guide, there is a step missing. The ONLY place I have found this documented is in the OLD ADSM server-to-server implementation redbook (and it's kinda easy to miss there, too), and I never would have figured it out except by searching the ADSM-L archives (THANK YOU DWIGHT!). On the sourceserver you must do: DEFINE SERVER targetserver But on the target server you must ALSO do: DEFINE SERVER targetserver -- so you define the target server back to itself. If you don't do this the export will work, but the import will not. Here is a copy of the pertinent pieces from my devconfig, if that will help: I was going from an AIX server to a Windows server. Server to Server DEVCONFIG parms for SOURCE SERVER : /* Device Configuration on AIX: */ SET SERVERNAME AIXADSM DEFINE SERVER TSM_WIN COMMMETHOD=TCPIP HLADDRESS=nnn.nnn.nnn.nn LLADDRESS=1500 NODENAME=H801SRVR PASSWORD=zz DELGRACEPERIOD=0 DEFINE DEVCLASS OVERTHERE DEVTYPE=SERVER MAXCAPACITY=41943040K MOUNTLIMIT=3 MOUNTRETENTION=4 PREFIX=ADSM SERVERNAME=TSM_WIN RETRYPERIOD=6 RETRYINTERVAL=3 Server-to-Server DEVCONFIG parms for TARGET SERVER: /* Device Configuration on Windows: */ SET SERVERNAME TSM_WIN DEFINE DEVCLASS OVERHERE DEVTYPE=SERVER MAXCAPACITY=41943040K MOUNTLIMIT=8 MOUNTRETENTION=0 PREFIX=ADSM SERVERNAME=TSM_WIN RETRYPERIOD=10 RETRYINTERVAL=30 DEFINE SERVER TSM_WIN COMMMETHOD=TCPIP HLADDRESS=newhost LLADDRESS=1500 NODENAME=H801SRVR PASSWORD=zz Also needed on target server: DEFINE NODE H801srvr pwd TYPE=SERVER MAXNUMMP=3 DOMAIN=PDOM_OTHERSRVR Using the above definitions: EXPORT: export node x filedata=all devclass=overthere IMPORT: import node * filedata=all devclass=overhere vol=TSM_WIN.EXP.n Wanda Prather The Johns Hopkins Applied Physics Lab 443-778-8769 [EMAIL PROTECTED] Intelligence has much less practical application than you'd think - Scott Adams/Dilbert -Original Message- From: Allen Barth [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 2:23 PM To: [EMAIL PROTECTED] Subject: export/import via virtual vols help Hi list- Due to some restructuring, I need to export node 'x' from TSM server 'k' and then import it to TSM server 'c'. I want to use virtual vols. I set up the server-server comm stuff, devc, and client nodes as needed. I ran the export node 'x' on server 'k' specifying a devc that points to server 'c'. While it took a while, the export completed successfully, and I saved the volusage list to nodex.vols Now on server 'c', I want to IMPORT NODE x I set up devc 'servc' on server 'c' as type=server which points to server 'c' I reg'd server 'c' as a server type client on server 'c' in the same domain as the server 'k' client definition I ftp usedvol list from server 'k' to server 'c' I issue: import node x filed=all preview=yes dev=servc vol=file:nodex.vols preview=yes What happens is server 'c' starts an internal session with itself due to the devc, but I get a message that it cannot mount the volume as read from the nodex.vols. What am I missing? Is this possible? Server 'k' is 5.1.5, server 'c' is 4.1.5, both are AIX. TIA -- Al
Re: Future of mainframe TSM
TSM as you know works well on the mainframe. VM was the original WDSF platform. But with the I/O and processing power of UNIX systems surpassing mainframes, moving off the mainframe TSM off the mainframe isn't a bad idea especially since you are expanding your service. -- Joshua S. Bassi IBM Certified - AIX 4/5L, SAN, Shark Tivoli Certified Consultant -ADSM/TSM eServer Systems Expert -pSeries HACMP AIX, HACMP, Storage, TSM Consultant Cell (831) 595-3962 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Thomas Denier Sent: Friday, February 07, 2003 12:45 PM To: [EMAIL PROTECTED] Subject: Future of mainframe TSM We run a 4.2.3.2 TSM server under OS/390. We have about 110 active client systems, sending about 300,000 files and about 70 gigabytes to the server each night. Our best estimate is that this workload will double in the next two years. Is it reasonable to stay with an OS/390 or zOS server in the face of the projected growth? If so, how do we prove that the mainframe is up to the task? Most IT managers around here want to believe that the mainframe is the wrong choice for TSM or anything else.
Re: TSM 5.1.5 B/A Client and Netware 6
We recently migrated to Netware 6 our only server running netware. We've not been able to backup that server for about a week now. I tried to reinstall the 5.1.5 .0 B/A client again and I am still getting these errors: 02/07/03 16:04:30 ANRD smnode.c(6243): ThreadId27 Error receiving EventLog Verb - invalid data type, 29793, received for event number 4959 from node (NetWare)MMRSSERV. 02/07/03 16:04:30 ANRD smnode.c(6243): ThreadId27 Error receiving EventLog Verb - invalid data type, 29793, received for event number 4961 from node (NetWare)MMRSSERV. (BTW - we are running TSM server version 4.2.1.9 on an RS 6000) . We are trying to get the cd for version 5 (base level) but we are having a few challanges with vendors etc. Here is a correspondence with TSM support that I recently had. Tommy, I did some research and think I found the problem. The resolution will require an upgrade of the TSM server to 5.1.5. This problem should be resolved in APAR IC34288. Here is excerpt from the APAR. TSM server 5.1.0.2 has shown to core dump (abend) when passed an invalid data type 21300 as and EventLog Verb from the client. . Traceback: . 0x000100A4DA44 pkFreeTracked 0x000100765F94 SmDoEventLog 0x000100761F9C SmNodeSession 0x0001007ACA90 SmSchedSession 0x00010073FE20 HandleNodeSession 0x0001007401CC DoNodeSched 0x00010073D1B4 smExecuteSession 0x00010007C194 SessionThread 0x00010006C2FC StartThread 0x7EB1F8A0 *UNKNOWN* 0x00010006C1DC StartThread . Actlog: . ANRD smnode.c(6566): ThreadId66 Error receiving EventLog Verb - invalid data type, 21300, received for event number 4987 from node (WinNT) nodename . Keywords: Crash abort abnormal termination terminate dump LOCAL FIX: None. However the invalid EventLog Verb being sent has been shown in some cases to be the result of an improperly installed windows client. If the windows client has been upgraded from a prior major release (such as 4.1 or 4.2) to a current release but the system has not been rebooted following the upgrade the invalid data type may be the result. A reboot of the client system will sometimes clear this problem. What level of TSM server do you have installed? I would upgrade to 5.1.5.0 if your version of TSM is not at this level or higher. Steve Runyon , Tivoli Privacy Manager Tivoli Certified Firewall L2 Software Engineer (919) 254-8751 - Bld660/EE105 [EMAIL PROTECTED] - - Original Message - From: Kamp, Bruce [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 07, 2003 12:51 PM Subject: Re: TSM 5.1.5 B/A Client and Netware 6 I have 3 Netware 6 servers. 1 running 5.1.0.0 1 running 5.1.5.1 1 running 5.1.5.6 I haven't noticed any problems... The 5.1.5.6 server is backing up slow but I think that is because it is out first Netware server on gigabit haven't completely tuned the NIC network -- Bruce Kamp Midrange Systems Analyst II Memorial Healthcare System E: [EMAIL PROTECTED] P: (954) 987-2020 x4597 F: (954) 985-1404 --- -Original Message- From: Tommy Templeton [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 11:20 AM To: [EMAIL PROTECTED] Subject: TSM 5.1.5 B/A Client and Netware 6 Hi TSMers Has anyone had any challenges with TSM 5.1.5 on a client running Netware 6? thanks, Tommy Templeton Senior System Administrator DFA-MMRS 601-359-3106 e-mail - [EMAIL PROTECTED]
Error on tape drive?
I don't have the messages manual this error referrs to. Could someone help me out? Do I have a problem with the drive or with the tape? It came from my activity log, and I am getting a lot of them. Thanks in advance ... Jack 02/07/2003 16:23:11 ANR8302E I/O error on drive TAPE3 (MT3.0.0.3) (OP=LOCATE, Error Number=23, CC=0, KEY=03, ASC=14, ASCQ=00, SENSE=70.00.03.00.00.00.00.1C.00.00.00.00.14.00.06.00.20- .80.FF.FF.00.03.20.20.20.20.20.20.20.1B.00.00.11.37.03.0- 0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.- 00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00- .00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0.00.00.00.00, Description=An undetermined error has occurred). Refer to Appendix D in the 'Messages' manual for recommended action. -- Jack Coats Sterling Bank, Technology Department
TSM 5.1.5.1 MacOS X 10.2.3
On a MacOS X 10.2.3 system I'm getting crash logs from something called 'fix_prebinding' when running the TSM 5.1 client. TSM continues to run, and does successful backups, as far as I can tell; the crashes appear to occur on input actions (keypresses, mouse clicks). I didn't get such crashes when running MacOS X 10.1. Does anyone know what this is and whether it can be eliminated? -- --- Stan Kerr [EMAIL PROTECTED] University of Illinois Campus Information Technologies and Educational Services 2212 Fox Drive, Champaign IL 61820 Phone: 217-333-5217 Fax: 217-265-5635 http://www.uiuc.edu/ph/www/stankerr
Re: Error on tape drive?
Jack, Sense data 03-14-00 means recorded entity not found. Since 03 is media error, this could be a cartridge problem. Regards, HK.. Coats, Jack Jack.Coats@BANKSTTo: [EMAIL PROTECTED] ERLING.COM cc: Sent by: ADSM: Subject: Error on tape drive? Dist Stor Manager [EMAIL PROTECTED] EDU 02/07/2003 02:27 PM Please respond to ADSM: Dist Stor Manager I don't have the messages manual this error referrs to. Could someone help me out? Do I have a problem with the drive or with the tape? It came from my activity log, and I am getting a lot of them. Thanks in advance ... Jack 02/07/2003 16:23:11 ANR8302E I/O error on drive TAPE3 (MT3.0.0.3) (OP=LOCATE, Error Number=23, CC=0, KEY=03, ASC=14, ASCQ=00, SENSE=70.00.03.00.00.00.00.1C.00.00.00.00.14.00.06.00.20- .80.FF.FF.00.03.20.20.20.20.20.20.20.1B.00.00.11.37.03.0- 0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.- 00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00- .00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0.00.00.00.00, Description=An undetermined error has occurred). Refer to Appendix D in the 'Messages' manual for recommended action. -- Jack Coats Sterling Bank, Technology Department
Future of mainframe TSM
Top of message -- 02-07-03 15:11 S.SHEPPARD (SHS)Future of mainframe TSM We run 2 older 9672s (R52 and R14), with a TSM 4.2.3.2 system on each backing up 140-160GB a night from 200+ clients. This is with an RVA T82 and 3590B drives in a 3494. We are somewhat constrained by the engine speed of the R52 (18mips) and the RVA disk, but still manage this load without too much grief, all while running a full-time traditional mainframe load. Due to end of support considerations for OS/390 2.10 and the high maintenance cost of the RVA, we will upgrade to a z/800 and ESS in the next 6 months, with a tape upgrade sometime after that. I expect that this will take care of our load for the foreseeable future with some (probably significant) performance improvements. I think the newer CPUs, ESS and FICON have allowed the mainframe to pretty much keep up with the UNIX boxes in performance. One big plus as far as I'm concerned is that S/390 tape management is light years ahead of the other platforms. With a properly configured RMM system, you don't need to worry about the ins and outs of moving your copy pool tapes back and forth to offsite storage and can easily do without DRM. Plus, the migration to another platform is not exactly free. The downside is the lack of LAN-free, server-free, and NAS backup capability and the potential that having to upgrade an underpowered mainframe just because of TSM could get you into some expensive third- party software charges that you might not have expected. Bottom-line, we're sticking with ours until we are absolutely forced off. We're hoping by that time to see a z-series Linux server. Sam Sheppard San Diego Data Processing Corp. (858)-581-9668 ---` Top of message -- 02-07-03 13:38 ..NETMAIL () Future of mainframe TSM Date: Fri, 7 Feb 2003 15:45:12 -0500 From: Thomas Denier [EMAIL PROTECTED] Subject: Future of mainframe TSM To: [EMAIL PROTECTED] _Top_of_Message_ We run a 4.2.3.2 TSM server under OS/390. We have about 110 active client systems, sending about 300,000 files and about 70 gigabytes to the server each night. Our best estimate is that this workload will double in the next two years. Is it reasonable to stay with an OS/390 or zOS server in the face of the projected growth? If so, how do we prove that the mainframe is up to the task? Most IT managers around here want to believe that the mainframe is the wrong choice for TSM or anything else. ---`
Re: TDP Sql Failures
Hello, this sounds like you are having problem with TDP, not SQL Sever. If this is true why would you want to restore the SQL Server Db? Yi [EMAIL PROTECTED] 02/07/03 10:00AM Recently I upgraded to TDP SQL 5.1 on a SQL server. Once I figured out the command line differences to get the command file to work they seemed to run fine. Two days ago I started receiving a failure notification on the backups, which looks like one of the databases is corrupt. This particular client is running 5.1.5.2 TSM, on NT4 SP6 TDP SQL 5.1..5.0. The only thing that has happened is the SQL PS4 was applied the day before the failures started to occur and the software that uses this database was applied after the SQL Update. Now neither gave any indication of problems during their respective upgrades but it almost looks like something must have gone wrong. The error reports backup of insite failed. Could anyone tell me if it's possible to just restore that database to a known good point, even if it was before the SQL upgrade and upgrade of the software that uses the database? Or will I have to restore all databases to a known good point on the same day. We have never had to mess with a restore, thankfully, and not since I don't know much about how it works. Unfortunately I have no test SQL server to run this on. This is from last night. The previous sucessful backups reported 16 02/07/2003 03:08:41 == Log file pruned using log retention period of 60 day(s) 02/07/2003 03:08:41 == 122 out of 3191 entries pruned from the top of this log 02/07/2003 03:08:43 = 02/07/2003 03:08:46 = 02/07/2003 03:08:46 Request : FULL BACKUP 02/07/2003 03:08:46 Database Input List : * 02/07/2003 03:08:46 Group Input List : - 02/07/2003 03:08:46 File Input List : - 02/07/2003 03:08:46 Number of Buffers : 3 02/07/2003 03:08:46 Buffer Size : 1024 02/07/2003 03:08:46 Number of SQL Buffers : 0 02/07/2003 03:08:46 SQL Buffer Size : 1024 02/07/2003 03:08:46 Number of Stripes specified : 1 02/07/2003 03:08:46 Estimate : - 02/07/2003 03:08:46 Truncate Log? : - 02/07/2003 03:08:46 Wait for Tape Mounts? : Yes 02/07/2003 03:08:46 TSM Options File : dsm.opt 02/07/2003 03:08:46 TSM Nodename Override : - 02/07/2003 03:08:46 Sqlserver : CP-ITS-TAX01 02/07/2003 03:08:46 02/07/2003 03:09:21 ACO5436E A failure occurred on stripe number (0), rc = 115 02/07/2003 03:09:21 (RC155) 02/07/2003 03:09:21 Backup of insite failed. 02/07/2003 03:09:21 (RC155) 02/07/2003 03:10:31 Total SQL backups selected: 16 02/07/2003 03:10:31 Total SQL backups attempted: 16 02/07/2003 03:10:31 Total SQL backups completed: 15 02/07/2003 03:10:31 Total SQL backups excluded: 0 02/07/2003 03:10:31 Total SQL backups inactivated: 0 02/07/2003 03:10:31 Throughput rate: 5,678.68 Kb/Sec 02/07/2003 03:10:31 Total bytes transferred: 566,017,520 02/07/2003 03:10:31 Elapsed processing time: 97.34 Secs 02/07/2003 03:10:31 ACO0151E Errors occurred while processing the request. 02/07/2003 03:10:31 ACO0151E Errors occurred while processing the request. Thanks for the help. Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
Re: Future of mainframe TSM
Hello, Thomas. We run a 4.2.3.2 TSM under OS/390 2.10, also. We run it on a tiny little 7060-H50 (Multiprise 3000) and have an approximately 110mb/sec network connection (that's a bandwidth measurement - not a theoretical number). Furthermore, we run our OS/390 in a V=R virtual machine under z/VM, with 768MB of central storage dedicated to it and 192MB of expanded. We also run several Oracle address spaces and not much else. We have 12 3590's (E1A) in a 3994 ATL, a 42 GB database, about 300 GB of disk storage pools, and manage a total (primary and offsite copy stgpools) of about 20 terabytes of data, consisting of 79+ million files/copies. We are at our limit on the traffic during the evening hours, at this point. We are able to backup about 150 nodes and I'm not sure about the evening data volume by itself, but on daily basis, for all 24 hours, we backup anywhere from 250 to 350 GB. Most of it must be during the evening, because the only nodes we backup during the day are workstations, and our servers contain more data volume than our workstations. If you can get away from MVS (OS/390, z/OS) you'll probably save GOBs on the software licensing - IBM really does make you pay big time for MVS licensing (for the OS - not necessarily TSM). It seems like they're trying to eliminate the platform, doesn't it? However, I believe in the platform, because of its absolutely rock-solid qualities. I guess we pay for what we get - it's still too steep to justify, in my mind, and certainly not justifiable to most upper-level management. Anyway, please feel free to call off-line to get any details you may wish... By the way, I'll bet your workload quadruples, or more, over the next year! Regards, Mark Darby U. S. DOE Germantown, MD (301) 903-5229 -Original Message- From: Thomas Denier To: [EMAIL PROTECTED] Sent: 2/7/03 3:45 PM Subject: Future of mainframe TSM We run a 4.2.3.2 TSM server under OS/390. We have about 110 active client systems, sending about 300,000 files and about 70 gigabytes to the server each night. Our best estimate is that this workload will double in the next two years. Is it reasonable to stay with an OS/390 or zOS server in the face of the projected growth? If so, how do we prove that the mainframe is up to the task? Most IT managers around here want to believe that the mainframe is the wrong choice for TSM or anything else.
Re: summary-table
The definition of compatibility may not mean that no features get broken that are not directly related to the integrity of the system from a Tivoli point of view. Unfortunately, this stuff has been broken since about 4.2.1.11. And for the most part, the summary table contents are not necessary for any TSM externals to work properly. Customers use it for reporting via SQL. After about 6 months of trying to figure out what the cause of the lost data was, Tivoli Development was about to go crazy. Luckily, I some reports that I was running that triggered a thought that the cause of the problem was because the client session would time out during a backup over the session timeout length. At the end of the backup the client was reforming the session to record the statistics, but the information delivery was to the wrong session and everything was getting zeroed out. To fix the problem required them to make a fix to both the client and the server. The database even had to be updated to provide some additional capability based on what I heard. Yes, it is a really nasty problem. How did it get introduced. I am guessing they had to rearchitect some things to fix some serious SAN client issues. During the process apparently the designs of the client and the server became incompatible. Tivoli was very thankful that I was able to point them in the right direction. But, as you say, I doubt sessions longer than the session timeout were tested significantly in their regression testing and I doubt they did any summary table data verification because it is not critical to TSM operation nor most of the commands. It is a customer thing. There were a lot bigger fish to fry than fixing summary table issues. The only reason Tiovli put their heads together and made it a priority was when I explained that this had broken many customer billing systems for TSM usage. That was a real financial integrity issue for customers. That got their attention. Now that Tivoli knows that this is a critical compatibility item, I hope they will actually test to see if it is working correctly from release to release and compatibility of client to server. There are no guarantees. Paul D. Seay, Jr. Technical Specialist Northrop Grumman Information Technology 757-688-8180 -Original Message- From: Allen Barth [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 4:48 PM To: [EMAIL PROTECTED] Subject: Re: summary-table It's stuff like this that makes my shake my head in disbelief... The summary table was working fine will ALL my clients, regardless of version, when the server was 4.1.5. After upgrading ONLY the server to 5.1.5. the byte counts in the summary table are Zeroes. Hmmm, compatability tested? I think not! If so, where are the notices and gotcha's in the readme's? -- Al Matt Simpson [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02/07/03 03:05 PM Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: summary-table At 3:19 PM -0500 2/7/03, Seay, Paul wrote: Apparently, the client needs to be updated as well to get a complete fix. I do not know if there is a client level for 4.2.3.2 and higher that completely eliminates the problem. According to the info I got from TSM support, for what I think is the same problem: The APARs that describe this are IC33840 for the client and IC34693 for the TSM server. Both a client fix and a server fix need to be applied. ` The client fixtests are in Client fixtests 5.1.5.2 and 4.2.3.1. go to... ftp://service.boulder.ibm.com/storage/tivoli-storage-management/ patches/client/v4r2/ ` and then platform and the v423 directory or folder. For the V4.2 Win98/Me platform only, the fixtest is 4.2.3.2. These fixtests must be used in conjunction with the server fix. I haven't tried to apply any of the indicated fixes. -- Matt Simpson -- OS/390 Support 219 McVey Hall -- (859) 257-2900 x300 University Of Kentucky, Lexington, KY 40506 mailto:[EMAIL PROTECTED] mainframe -- An obsolete device still used by thousands of obsolete companies serving billions of obsolete customers and making huge obsolete profits for their obsolete shareholders. And this year's run twice as fast as last year's.
I/O Error with LTO 3581 question!
TSM Advance: I have a I/O Error with LTO 3581 on AIX 4.3.3 (TSM 4.2.2.13). The error message as follow: ANR8300E I/O error on library LTO3581 (OP=6C03, CC=-1, KEY=09, ASC=FF, ASCQ=3B, SENSE=70.00.09.00.00.00.00.0A.- 00.00.00.00.FF.3B.00.00.00.00., Description=An undetermined error has occurred). Refer to Appendix D in the 'Messages' manual for recommended action. what happened? thank you for your help Tony W
Re: TSM 5.1.5.1 MacOS X 10.2.3
On Saturday, Feb 8, 2003, at 09:24 Australia/Sydney, Stan Kerr wrote: On a MacOS X 10.2.3 system I'm getting crash logs from something called 'fix_prebinding' when running the TSM 5.1 client. TSM continues to run, and does successful backups, as far as I can tell; the crashes appear to occur on input actions (keypresses, mouse clicks). I didn't get such crashes when running MacOS X 10.1. Does anyone know what this is and whether it can be eliminated? fix_prebinding is a Mac OS X daemon that is launched whenever a binary is executed that has out-of-date dynamic linking prebinding hints. It is supposed to scan the binary and dependent libraries, and update the hints in the binary. The benefit is faster launch times the next time it is run. If the environment variable DYLD_NO_FIX_PREBINDING is exported in the environment when the TSM client is launched, the prebinding update won't be attempted. BTW, If you leave it exported all the time, you may find Mac OS X starts to slow down noticeably. I'm a little surprised the daemon is crashing. I might download the client and try it on my 10.2.3 box... Cheers, -- Paul Ripke Unix/OpenVMS/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
Re: Three copies of backup data
In V5.1 and up you can specify linked copy pools and actually create the primary and the copy pools at the same time, but you have to have 3 tape drives. Paul D. Seay, Jr. Technical Specialist Northrop Grumman Information Technology 757-688-8180 -Original Message- From: Stapleton, Mark [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 11:00 AM To: [EMAIL PROTECTED] Subject: Re: Three copies of backup data From: Mario Behring [mailto:[EMAIL PROTECTED]] I have a TSM Server running on a W2K Server machine. The tape library is a IBM 3590, non automated, with two drives. The drives are connected to the TSM Server through SCSI interfaces (one interface for each drive). What I need is this: I want to do each incremental backup on three different tapes, so I can store these tapes in different places. The tapes contents should be identical. Create a primary tape storage pool (call it primtape1) and two copy storage pools (call them copytape1 and copytape2). After backups complete, run backup stg primtape1 copytape1 backup stg primtape1 copytape2 upd stg diskpool hi=0 lo=0 and when diskpool--primtape1 migration is complete: upd stg diskpool hi=90 lo=70 (or whatever your diskpool migration levels are) (This assumes, of course, that you're using a disk cache to catch client backups.) Contents of all three tapes may not be absolutely identical, but they'll be pretty damn close. (If you're looking to clone the contents of one tape to another tape via an OS utility like tcopy or dd, you may or may not get a usable tape.) -- Mark Stapleton ([EMAIL PROTECTED])
tape cartridges with same bar code
Hello, To simplify my question, assume that there are two tape cartridges with same bar codes. The tapes are extended high performance tapes. We have two IBM 3494 tape libraries( I call them as 3494A, 3494B). If I put one tape into 3494A and if I put the other tape into 3494B, will that cause a problem to ADSM server? I have ADSM installed on an RS/6000 unix server which manages the two libraries. I am a newbie in ADSM and someone says this will cause a problem but I don't understand why. Since they are in physically different library, there should be a way to distinguish the two tapes with same bar codes in ADSM. Any comments will be much appreciated. thanks.