How to get the best use from TSM with a large disk?

2005-05-06 Thread Krzysztof WOZNIAK
Dear All, My TSM backup server holds approx 15Tb of data collected from some 80 servers. The twin 4560 library holds 56 tapes. Approx. 150 tapes are offline. The primary disk storage is 120Gb. As you can imagine reclamation takes quite a lot of time as the system become overloaded since it was

Tivoli/RMAN Issue

2005-05-06 Thread Baker Brendan
Hi, Yesterday all our RMAN scripts failed with the follow error message: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: ===

hi tsm'ers ! UPGRADE question

2005-05-06 Thread goc
hi all, i'll first explain the situation and then tell you what we want do , i appreciate every reply and help you offer TSM 5.2.4.0 on pSeries 640 2x8 port switch LTO library L32 with 12 LTO1 drives (and the same configuration on DR site) as we approached the capacity of this one LTO library we

Re: Tivoli/RMAN Issue

2005-05-06 Thread Loon, E.J. van - SPLXM
Hi Brendan! Look for the sbtio.log file, it probably contains more useful information about the error. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Baker Brendan [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 10:44 To: ADSM-L@VM.MARIST.EDU

Re: Tivoli/RMAN Issue

2005-05-06 Thread Baker Brendan
Hi Eric, Thank you for the reply. I'm a DBA with not much experience of Tivoli. Where should this log file be located? Regards, Brendan -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Loon, E.J. van - SPLXM Sent: 06 May 2005 10:10 To:

Re: Tivoli/RMAN Issue

2005-05-06 Thread Loon, E.J. van - SPLXM
Hi Brendan! The location of sbtio.log is controlled by the user_dump_dest option in your Oracle initialization file. The default is directory is $ORACLE_HOME/admin/hostname/udump You could also use the find command... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original

Re: Tivoli/RMAN Issue

2005-05-06 Thread Baker Brendan
Hi Eric, I have checked the sbtio.log file in the udump directories for both RMAN and PROD database. RMAN stbio.log is empty and PROD stbio.log has a last modified date of 18/04/05. Our issue started on 04/05/05. Regards, Brendan -Original Message- From: ADSM: Dist Stor Manager

Re: TSM/Veritas

2005-05-06 Thread Othonas Xixis
Yes, is possible, we have a couple installations running where the same library supports both backup products, with IBM3584, and with L700. I am pretty sure you can do it with all the large scale libraries provided that the library supports true sharing and zoning. Brgds, Othonas Xixis IBM

Empty volume cannot be deleted or reclaimed

2005-05-06 Thread Doyle, Patrick
Hi, I have a volume that appears to empty, but I can't delete it, or reclaim it. Any ideas? TIA Pat Doyle TSM Server Version 5.1.6.2 tsm: EAGLESTAR_TSMq drm 75l1 Volume Name State Last Update Automated

Re: Incremental skipping filesystems?

2005-05-06 Thread Warren, Matthew (Retail)
Hallo, And thanks for the suggestions, they prompted us to investigate a few avenues. We tracked it down to an issue with the 5.2.0.0 client on Solaris. Upgrading to 5.2.2.0 has fixed the problem - although I am still trying to find a page on ibm.com describing the fault. Thanks, Matt.

Re: Tivoli/RMAN Issue

2005-05-06 Thread Richard Sims
On May 6, 2005, at 4:44 AM, Baker Brendan wrote: OSD-02041: unable to duplicate a string Cause: There is not enough contiguous memory available to perform the task. Action: Wait a few minutes and try the operation again-memory may have been freed by other processes. If this happens often, reduce

Re: Migration - Primary and Copy Pool

2005-05-06 Thread Paul van Dongen
Bruno, From the TSM Help for the Define stgpool command: The server can perform simultaneous write to copy storage pools for the following operations: o Backup and archive operations by Tivoli Storage Manager backup-archive clients or application clients using the

Re: Empty volume cannot be deleted or reclaimed

2005-05-06 Thread David E Ehresman
I have a volume that appears to empty, but I can't delete it, or reclaim it. Any ideas? Do a audit vol XX fix=yes

Re: Empty volume cannot be deleted or reclaimed

2005-05-06 Thread Loon, E.J. van - SPLXM
Hi Patrick! Try an audit volume for this tape. If you see that it has repaired files, you will have to do a move data for the tape. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Doyle, Patrick [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 14:25

Re: [Possible Spam] Re: Empty volume cannot be deleted or reclaim ed

2005-05-06 Thread Doyle, Patrick
Unfortunately, any time I Audit a volume my server crashes abruptly! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: 06 May 2005 13:46 To: ADSM-L@VM.MARIST.EDU Subject: [Possible Spam] Re: Empty volume cannot be deleted

3494 at DR Recovery Site

2005-05-06 Thread David E Ehresman
I got to thinking about 3494 category codes in the middle of the night when I should have been sleeping (can you tell my DR test is soon?). If I load the DR 3494 with my copypool tapes and let the 3494 do an audit operation while I am restoring my tsm machine from a sysback tape, will all the

Re: Empty volume cannot be deleted or reclaimed

2005-05-06 Thread Richard Sims
On May 6, 2005, at 8:25 AM, Doyle, Patrick wrote: Hi, I have a volume that appears to empty, but I can't delete it, or reclaim it. Any ideas? A frequent question. Do an Audit Volume. Richard Sims

Re: TSM app in initab

2005-05-06 Thread Frank Lozano
Thanks Richard. Hope these question are not too basic--but guess I gotta start somewhere (who do I see about getting you a raise...) |-+ | | Richard Sims | | | [EMAIL PROTECTED] | | | Sent by: ADSM:

Re: [Possible Spam] Re: Empty volume cannot be deleted or reclaim ed

2005-05-06 Thread Loon, E.J. van - SPLXM
Hi Patrick! This is probably related to APAR IC36609 which has been fixed in 5.1.8.0. Why don't you upgrade to the latest 5.1 level, which is 5.1.10.0? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Doyle, Patrick [mailto:[EMAIL PROTECTED] Sent: Friday,

Re: [Possible Spam] Re: Empty volume cannot be deleted or reclaim ed

2005-05-06 Thread Richard Sims
On May 6, 2005, at 8:46 AM, Doyle, Patrick wrote: Unfortunately, any time I Audit a volume my server crashes abruptly! That's what maintenance is for... You can go to a higher level than your 5.1.6.2, where there are fixes for Audit Volume problems, per the server Readme file. Richard Sims

Re: Operational Hourly Monitors

2005-05-06 Thread William Boyer
If you go in and look at some of the queries already defined by Tivoli in the default hourly monitor it shows that the SQL WHERE clause compares the date/times BETWEEN '%s and '%s' . I've used this syntax in my own queries and it works fine. I've never found any documentation on it, just a

Out of scratch tapes?

2005-05-06 Thread Dave Zarnoch
Folks, UNfortunately as a result of miscommunication with our supplier, we will be running out of scratch tapes in the next few days. We should have a new shipment returning on Monday but, in the meantime, it appears that we will run out Sunday evening. Aside from missing backups, what other

Re: Out of scratch tapes?

2005-05-06 Thread John Naylor
Well, unhappy management springs to mind. But for the short period you are talking about, can't you do one or more of 1) Add extra disk storage 2) Step up reclamation 3) Look at tape reuse delay 4) Check whether you have any filespaces not accessed for a long time. Are their backups still

Re: 3494 at DR Recovery Site

2005-05-06 Thread Thomas Denier
I got to thinking about 3494 category codes in the middle of the night when I should have been sleeping (can you tell my DR test is soon?). If I load the DR 3494 with my copypool tapes and let the 3494 do an audit operation while I am restoring my tsm machine from a sysback tape, will all

Time limit on TSM DB?

2005-05-06 Thread Dave Zarnoch
Folks, Sorry if this is a FAQ.. I'm trying to generate reports from our TSM database that are older than 1 month old and I am not finding any info. Is this the time retention on the DB? How do I find out? Thanks! DaveZ

Re: Time limit on TSM DB?

2005-05-06 Thread Thorneycroft, Doug
Please be more specific, what is it that you are looking for in the database? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 8:59 AM To: ADSM-L@VM.MARIST.EDU Subject: Time limit on TSM DB? Folks, Sorry if

Re: Time limit on TSM DB?

2005-05-06 Thread Dave Zarnoch
I'm doing some lookups for amount of data being backed up. Here's the statement: select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes, summary where (end_time between '2005-03-28' and '2005-03-31') and (activity='BACKUP' or

Re: Time limit on TSM DB?

2005-05-06 Thread fred johanson
Do a q status. That will show the retention period for ACTLOG and SUMMARY. At 12:21 PM 5/6/2005 -0400, you wrote: I'm doing some lookups for amount of data being backed up. Here's the statement: select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as

Re: Time limit on TSM DB?

2005-05-06 Thread Thorneycroft, Doug
You are searching the activity log, which has a user defined retention period. You can set the retention using the command: set actlogretention ## Where ## is the number of days to retaining records. You can see your current settings by issuing a query status command. Doug Thorneycroft Systems

Re: Time limit on TSM DB? SOLVED

2005-05-06 Thread Dave Zarnoch
Folks, Thanks! That clears up some things.. Activity Log Retention Period: 2 Day(s) Activity Summary Retention Period: 30 Day(s) Thanks again! DaveZ Thorneycroft, DougTo: ADSM-L@VM.MARIST.EDU

Re: Time limit on TSM DB?

2005-05-06 Thread Neil Schofield
Dave The number of days that information is kept in the SQL activity summary table is configurable. Try HELP SET SUMMARYRETENTION for info. Regards Neil Schofield Yorkshire Water Services Ltd. Did you know - in Africa and Asia 1 billion people still don't have access to safe water - 9th -

Re: Out of scratch tapes?

2005-05-06 Thread Neil Schofield
Dave I disagree with John's recommendation to step up tape reclamation to get over a short term lack of scratch tapes unless your pending re-use delay will expire before the tapes arrive. My inclination would be to stop all reclamations until the new tapes arrive. Reclamation gives you a benefit

Result 402

2005-05-06 Thread Mario Behring
Hi list, After issuing a q event * * begindata=-7 f=d command I have the following (part of the output): Policy Domain Name: Policy_name Schedule Name: BKP_SRV_EXCHANGE_FULL Node Name: EM1-EXCHANGE Scheduled Start: 04/29/2005 01:00:00 Actual Start: 04/29/2005 01:00:08

Re: Result 402

2005-05-06 Thread Del Hoobler
402 is a general error code, with no associated meaning. You will need to look at the Data Protection for Exchange log to find out what the problem is. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 05/06/2005 01:28:23 PM:

Re: Result 402

2005-05-06 Thread Terry McColgan
should the parameter not be begindate -Original Message- From: Del Hoobler [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 1:55 PM To: ADSM-L@VM.MARIST.EDU Subject:Re: Result 402 402 is a general error code, with no associated meaning. You will need to look at the

Setting up Virtual Volumes

2005-05-06 Thread fred johanson
I'm trying to set up virtual volumes for DB Backups. I have, in this order, upd server targetserver serverpa=pw nodename=sourceserver def dev dbbackup devt=server servername=targetserver reg no sourceserver pw t=server When I run ba db t=full dev=dbback it fails with ANR0424W - invalid password.

Re: Out of scratch tapes?

2005-05-06 Thread Jones, Eric J
I have to agree for off-site reclamation. With reclamation running you can take up additional tapes that are off-site giving you even less to work with at the present time. Reclamation for your local tapes(on-site tapepool) should help gain back tapes. Eric -Original Message- From:

Re: Out of scratch tapes?

2005-05-06 Thread Sung Y Lee
Couple of things comes to my mind. Without knowing what your TSM environment is like it's hard to say.. however, these similar situation might happen. Out of scratch tapes. Disk pools fill up to 100%. Migration from disk to tape pools fail.. tape copies from onsite to offsite fail. TSM database

TSM/Veritas on the same library

2005-05-06 Thread Gill, Geoffrey L.
Since there was only one response I think I need to give a bit of info to help with why I'm asking the question. We have TSM and Veritas here. Not something I wanted but its here. Currently each reside on their own libraries mainly because one is LTO2(Veritas) and the other a 3494(TSM). I'd

Re: TSM/Veritas on the same library

2005-05-06 Thread Steven Harris
I've gotta ask Geoff, Why, with a 3494 and LTO library would you move TSM to LTO? My first option would be to move veritas to the 3494. 3494 is industrial strength and plays well in multi host and multi application environments. Use 3592 drives and you'll have capacity to burn. Also, second-hand