Re: Another Failed 12

2007-02-14 Thread Prather, Wanda
That should NOT cause a 12, because its WAD. What is in the dsmerror.log on the client? There should be something else causing that 12... From: ADSM: Dist Stor Manager on behalf of Gill, Geoffrey L. Sent: Wed 2/14/2007 5:09 PM To: ADSM-L@VM.MARIST.EDU Subject: Ano

Another Failed 12

2007-02-14 Thread Gill, Geoffrey L.
I was wondering if anyone knows if this would cause a failed 12 report. Makes sense to me that it would NOT, but my common sense gets the best of me most of the time. This file is larger than the disk pool allows and needs to go to tape, which reports happened, but I just don't see how that would c

Re: SQL date convert

2007-02-14 Thread Allan Mills
I get this imformation from domdsm.log the installation of tdp for domino will tell you where this is. whilst it is not 100% and subject to normal 'hit and miss', it is better than nothing. I have found that I get info about backups starting and no info about totals etc if it is a long running pr

Re: How to query the volume name when I need restore

2007-02-14 Thread Gill, Geoffrey L.
Another one of the problems I have with TSM is this issue. At the time I had the same issue as you Wira. I went through a lengthy test trace with IBM a few years ago and found that was the only way to get a list of tapes the system needed for the restore. As I recall the list seemed to be in order

Re: How to query the volume name when I need restore

2007-02-14 Thread Drew, Shawn
You have to decide on the implication on production of this, but something I vaguely remember doing once... - perform the volume usage command - Set all the applicable tapes to "unavailable" (temporarily) - Perform the restore, expecting failures - Search the actlog for the mount errors and com

Re: How to query the volume name when I need restore

2007-02-14 Thread Wira Chinwong
Hi Rebert, Thanks you very much for your recommendation. But it still not convenient to me. Because I have more 50 volumes which related to the restoration node. Some time more than 30 volumes are put out of library. It's not comfortable to checkin all volumes of that node for restore which actua

Re: SQL date convert

2007-02-14 Thread Andrew Raibeck
Try searching the ADSM-L archives for terms like "current_timestamp". Here is one entry that might be helpful: http://adsm.org/lists/html/ADSM-L/2005-01/msg00511.html Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tu

Re: Message ANR1163W during Copy Storage Pool Recamation

2007-02-14 Thread Tim Brown
It was that that the storage pool exceeed the number of available volumes. I didnt see that message till now Tim - Original Message - From: "Mark Stapleton" <[EMAIL PROTECTED]> To: Sent: Wednesday, February 14, 2007 10:59 AM Subject: Re: Message ANR1163W during Copy Storage Pool Recamat

Re: SQL date convert

2007-02-14 Thread Mark Stapleton
There is a much easier way to do this. Assuming you've got TSM accounting turned on at the server, look for the dsmaccnt.log (c:\program files\tivoli\tsm\server1 on a Windows box, /usr/tivoli/tsm/server/bin on an AIX box). This is a comma-delimited file broken down by date, time, and node nam

Re: Cloning clients / retaining existing backups

2007-02-14 Thread Thomas Denier
-Zoltan Forray wrote: - >What are the factors that determine if a file/filesystem is "new" vs >"already there - this is just a new backup". > >Given the following scenario: > >1. Box "A" has existing backups. >2. Create a clone of box "A" - call it "B" . "B" is identical in >*EVERY* way a

Re: Error restoring SQL database

2007-02-14 Thread Loon, E.J. van - SPLXM
Hi Andy! No, the log isn't showing more detail. Together with support, I have identified the tapes on which the backup resides. I'm currently running an audit on these tapes. Let's wait for the results... Thanks for now! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message

Re: SQL date convert

2007-02-14 Thread PAC Brion Arnaud
Abulifia, Something like : "where cast((current_timestamp- end_time )hours as decimal) <= 24" should do the trick ... However, if I remember properly, TDP's activity is not reported properly in summary table ... Double check before trusting your query ! Cheers. Arnaud ***

Re: Message ANR1163W during Copy Storage Pool Recamation

2007-02-14 Thread Mark Stapleton
...or when you have tapes in the primary pool that are in an "unavailable" access state. (This is what I usually find.) -- Mark Stapleton ([EMAIL PROTECTED]) Senior consultant From: ADSM: Dist Stor Manager on behalf of Zoltan Forray/AC/VCU Sent: Wed 2/14/2007 9

Re: Message ANR1163W during Copy Storage Pool Recamation

2007-02-14 Thread Zoltan Forray/AC/VCU
I usually get those when reclamation is canceled or there is a problem getting to the primary backup tape (operators asleep at the wheel - tape not in library). Tim Brown <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 02/14/2007 10:53 AM Please respond to "ADSM: Dist Stor Manager" T

Message ANR1163W during Copy Storage Pool Recamation

2007-02-14 Thread Tim Brown
Receive this messsage during copy storage pool reclamation. ANR1163W Offsite volume A02096 still contains files which could not be moved. It displays for 19 different tapes. How can this be resolved so I can reclaim these tapes. Tim Brown Systems Specialist Central Hudson Gas & Electric 284 So

Cloning clients / retaining existing backups

2007-02-14 Thread Zoltan Forray/AC/VCU
What are the factors that determine if a file/filesystem is "new" vs "already there - this is just a new backup". Given the following scenario: 1. Box "A" has existing backups. 2. Create a clone of box "A" - call it "B" . "B" is identical in *EVERY* way as far as the filesystem/OS is concerned

Re: Can't restore when tape in overflow area

2007-02-14 Thread Orin Rehorst
Thanks. That worked. Regards, Orin Orin Rehorst * e-mail: [EMAIL PROTECTED] ( Phone: (713)670-2443 7Fax: (713)670-2457 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Tuesday, February 13, 2007 12:43 PM To: AD

Re: Pricing model for 5.4

2007-02-14 Thread Kauffman, Tom
I don't even bother with manual spreadsheet; I do scribble on small yellow pad once a year. We've gone from 'node-level' licensing that made no sense -- an SP-frame is a node, with up to 32 CPUs in 16 boxes under ADSM 2.x (needs 16 node registrations at the server); to node-level where a box is a n

Re: Pricing model for 5.4

2007-02-14 Thread Allen S. Rout
I was a little surprised at Steve's cautious response to my post. Looking over it I think I understand it now, and it makes me want to emphasize that I'm not advocating just ignoring the issue ("Don't worry about it too much"). Focus on the "too much", not the "don't worry". :) If you develop a m

SQL date convert

2007-02-14 Thread Ronald Le Large
Hi everybody, The last time when I posted a question I received a few very useful and quick replies. Thx for that. Hopefully this question is also easy for a few of you to answer. Case: A client want's to know how big the daily backup is for a Lotus client backedp up via TDP. I c

Re: What is the licensing model for TSM?

2007-02-14 Thread Richard Sims
On Feb 14, 2007, at 4:40 AM, Douglas Currell wrote: BTW. What is a "managed processor"? Douglas - Search on that term at www.ibm.com, which turns up various announcements (206-037 is one), wherein there is a small glossary of the IBM sales terminology. Such definitions should give you a sen

Re: Pricing model for 5.4

2007-02-14 Thread Allen S. Rout
>> On Wed, 14 Feb 2007 08:22:28 +1000, Steven Harris <[EMAIL PROTECTED]> said: > I'm not so sure about this. One of our customers took a rather cavalier > attitude to TSM licencing, and were using about 3 times as many licences > as they'd paid for. IBM via PriceWaterhouseCoopers came in one da

Re: How to query the volume name when I need restore

2007-02-14 Thread Richard Sims
Wira - There is no way to determine what volumes will be needed for a restoral before starting the restoral. (See "Restoral preview" in ADSM QuickFacts".) TSM is an "enterprise" software product, where commensurate hardware resources are expected to be in place, which includes a library with al

Re: 5.4 TDP for MSSql Heads up.

2007-02-14 Thread Del Hoobler
Steve, I agree with you. I will take this comment back to the packaging team and try to get this resolved in the future. I am sorry for the problems this caused you. Thanks, Del "ADSM: Dist Stor Manager" wrote on 02/13/2007 10:03:36 PM: >

What is the licensing model for TSM?

2007-02-14 Thread Douglas Currell
Need some help understanding aboyt TSM 5.3 licensing. Thanks... We run TSM 5.2.2 on Linux (Suse) with one dual drive tape library and our licensing looks like this: (lines containing "0" edited out) Last License Audit: 02/14/2007 04:08:08 AM Is Tivoli Disaster Recovery

SV: [ADSM-L] Failed Exckange Restore ACN5798E..

2007-02-14 Thread Nielsen, Bo
Thanks for all the reply. I didn't have added the DB to the Recovery Group. When I did, it work. Regards Bo -Oprindelig meddelelse- Fra: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] På vegne af Del Hoobler Sendt: 13. februar 2007 15:03 Til: ADSM-L@VM.MARIST.EDU Emne: Re: [ADSM-L]

Re: How to query the volume name when I need restore

2007-02-14 Thread Robert Ouzen Ouzen
Hi Wira Maybe this script will help you: select node_name , volume_name, stgpool_name, filespace_name from volumeusage where node_name=upper('$1') Say you name it: Restore_vol Run restore_vol nodename Regards Robert Ouzen Haifa University Israel -Original Message- From: ADSM: Dist S

How to query the volume name when I need restore

2007-02-14 Thread Wira Chinwong
Hi, I used TSM for long time. Until now I'm still feel bad every time when I have to restore data especially when restore data from API (TDP for oracle and backup image). The restore data size is very huge so they need more than one volume to restore. Unfortunable I cannot maintain all backup vo