LTO2 is unconfident

2005-07-05 Thread nghiatd
Hi, I use 4560SLX with two LTO gen2 drives, I have 30 tape LTO2. And now my system wrote data on 22 tapes. When I use q vol f=d' to check status of tape, I see : a.. 9 tapes have 'Access=Read-Only', 'Number of Write Errors: 1' b.. 1 tape has 'Access=Unavailable', 'Number of Write Errors: 1

Re: LTO2 is unconfident

2005-07-05 Thread Jurjen Oskam
On Tue, Jul 05, 2005 at 02:02:02PM +0700, nghiatd wrote: a.. 9 tapes have 'Access=Read-Only', 'Number of Write Errors: 1' b.. 1 tape has 'Access=Unavailable', 'Number of Write Errors: 1 Perhaps that batch of LTO2 tapes was bad, but it's more likely that one of your drives has problems.

SV: LTO2 is unconfident

2005-07-05 Thread Granhagen Anders
Read/Write errors happens to all tape technologies, in my experience less frequently on LTO than many others. If you experience a lot of errors on your tapes, fist make sure that you clean your tape drives frequently, then see if you can relate the errors to any specific tape drive. If you can,

Restoring a lost copypool volume ?

2005-07-05 Thread Farren Minns
Hi all I have just had a call from our off-site copypool storage location to say that they have mistakenly popped one of my tape into their library and somehow initialised it (don't ask, I'm pretty cross at the moment). Anyway, I understand that the data on this missing volume can be transferred

Re: LTO2 is unconfident

2005-07-05 Thread nghiatd
I also have used SDLT tapes for 2 year and they are still well, LTO tapes just were bought four month ago. I will check again to see whether drive is error. The capacity of your tapes are related to your compression-rate. Since all data is not the same, you'll see different rates for different

Re: compare between LTOPOOL and VAULTPOOL

2005-07-05 Thread Warren, Matthew (Retail)
Hi LUC, There is a select statememnt posted on the TsmWiki, http://tsmwiki.com/tsmwiki/SelectStatements/AreCopypoolsUpToDate This will show you numfiles and logical occupancy per node per storage pool. This lets you see which primary/copy storage pools are out of sync, and which nodes are

Re: Restoring a lost copypool volume ?

2005-07-05 Thread Warren, Matthew (Retail)
I think you will be able to do a delete volume discarddata=yes, then the data will be recreated next time the primary pool is backed up to the copypool. Matthew Warren. [EMAIL PROTECTED] [EMAIL PROTECTED] http://tsmwiki.com/tsmwiki/MatthewWarren -Original Message- From: ADSM: Dist Stor

Server 5312 on W2K crashes

2005-07-05 Thread Matthias Feyerabend
Hello, We just updated to TSM Server 5312 on W2K and the server crashes every moment. He starts only with NOMIGRRECL, but even then keeps on crashing. ( ADSM exception file=pkthread.c line=2256, and buffer overrun detected while freeing memory called from afcreate.c(3907). IBM analyzed dump

Re: Server 5312 on W2K crashes

2005-07-05 Thread Richard Sims
On Jul 5, 2005, at 7:20 AM, Matthias Feyerabend wrote: Hello, We just updated to TSM Server 5312 on W2K and the server crashes every moment. He starts only with NOMIGRRECL, but even then keeps on crashing. ( ADSM exception file=pkthread.c line=2256, and buffer overrun detected while freeing

Re: RES: Very slow DB backups

2005-07-05 Thread Troy Frank
I would be interested in that, if you'd care to keep posting updates. Troy Frank Network Services University of Wisconsin Medical Foundation 608.829.5384 [EMAIL PROTECTED] 7/4/2005 4:03:41 PM Hello All, Just to keep you updated on my quest :) I began to modify some settings, and

cancelled process waiting around

2005-07-05 Thread Warren, Matthew (Retail)
Hi TSM'ers, I have a process that looks like this; 1,949 Backup Storage Pool Primary Pool RMM_STD_DATA_PRIM_LTO2, Copy Pool RMM_STD_DATA_COPY_LTO2, Files Backed Up: 2881, Bytes Backed Up: 327,851,654,004,

Re: Label reading problems 3584 library

2005-07-05 Thread James Skinner
Include both lto1 and lto2 in the same tape pool showing the same capacity. The lto1's will still write at their capacity. In transitioning to lto2 just manually mark the lto1's read only and later destroyed. This will allow you to eventually be all lto2's if that is what you wish to transition

Tape return script question?

2005-07-05 Thread Joni Moyer
Hello, I have created this script to create a request listing of tapes to be returned from our vault when they are empty. As you can see from the select statement that I run daily it will have duplicates within it since I have a delay of 5 days. Is there a certain way I can manipulate this

Re: cancelled process waiting around

2005-07-05 Thread Richard Sims
On Jul 5, 2005, at 9:14 AM, Warren, Matthew (Retail) wrote: ...I have never seen a process that reports it succesfully has an input and output volume not actually doing any work. ... Oh, thou hast not experienced the full breadth of yon world... :-) This is usually the case where software

oracle agent help

2005-07-05 Thread Shaban Ahmad
hi , my name is shaban ,I'm facing problem when i run tdpocon,exe password, get this error ANS1087e (RC106) access to the specified file or directory is denid so i can not continue on configure oracle backup . os is windows 2003 and oracle is 9.2 please any help. best ragards, shaban -

Re: The end of the TSM FAQ list as we know it

2005-07-05 Thread Andy Huebner
Is there a mirror of the ADSM.QuickFacts? BU.edu is not accessible to me due to a problem that is not at my end. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of John Bremer Sent: Friday, July 01, 2005 11:57 AM To:

incompatible operator

2005-07-05 Thread Joni Moyer
Hello Everyone! I think I had this issue before, but I can't seem to find the solution to it. Any suggestions as to why this will not work? I am trying to get that listing pinpointed to reporting each tape on the first day that it becomes pending and it just doesn't see to like my syntax.

Re: cancelled process waiting around

2005-07-05 Thread Warren, Matthew (Retail)
I had looked into the problem variously, and came up with nothing. No panel errors, nothing in the AIX errpt, actlog, drive light nice and green. I had overlooked tapeutil though. It is not unusual to find TSM in this state, or variations of; and restarting dsmserv is the only way of clearing

Re: The end of the TSM FAQ list as we know it

2005-07-05 Thread Warren, Matthew (Retail)
There is the tsmwiki, built from the QuickFacts, at http://tsmwiki.com/tsmwiki/ And within the quickfacts, it mentions it is 'referenced by' the following. Whether 'referenced' is linked to, indexed, or a copy of, I'm not sure. http:#47#47dir.adsm.org#47FAQ#47 http:#47#47dir.adsm.org#47Cool#47

Re: incompatible operator

2005-07-05 Thread PAC Brion Arnaud
Joni, Try something like : where days(current_timestamp)-days(pending_date) =1 This should work ! Cheers. Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002

The end of the TSM FAQ list as we know it

2005-07-05 Thread Warren, Matthew (Retail)
Repost with correct subject-line for conversation-thread -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Warren, Matthew (Retail) Sent: Tuesday, July 05, 2005 4:17 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: The end of the TSM FAQ list as we know

Re: incompatible operator

2005-07-05 Thread Andrew Raibeck
I think the problem is that you are mixing date data with timestamp data (the latter includes date and time). Try changing this: ... and date(pending_date) (current_timestamp - 1 day) and ... to this: ... and date(pending_date) (date(current_timestamp) - 1 day) and ... Regards, Andy Andy

Re: incompatible operator

2005-07-05 Thread Warren, Matthew (Retail)
Playing with this, my SQL knowledge not being so good I have a question. Why does this; pending_date current_timestamp - 1 day return the same as this pending_date (current_timestamp - 1 day) But they both return different from this Date(pending_date) date(current_timestamp - 1 day) I'm

Re: incompatible operator

2005-07-05 Thread Warren, Matthew (Retail)
This will also work, date(pending_date) date(current_timestamp - 1 day) Computer says 'No'.. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Tuesday, July 05, 2005 4:10 PM To: ADSM-L@VM.MARIST.EDU Subject: incompatible operator

Re: Tape return script question?

2005-07-05 Thread Warren, Matthew (Retail)
Hi, I'm not sure I follow what your after, but you may be able to alter this script to get the desired effect, http://www.tsmwiki.com/tsmwiki/SelectStatements/ReclaimableByDays That script runs several queries to show how many volumes went pending by stgpool by day. Adding in the extra clauses

Re: compare between LTOPOOL and VAULTPOOL

2005-07-05 Thread Mark D. Rodriguez
I am not sure if this is exactly what you are looking for but this select statement gives you the number of files and the amount of data in each pool. Then you can compare the totals of your primary pools vs. your copy pools. select stgpool_name as Storage Pool,sum(num_files) as Number of

Tape Housecleaning

2005-07-05 Thread Richard Mochnaczewski
Hi Everybody, Does anyone have any thoughts on saving on the number of tapes TSM uses ? After auditing our backups and finding that the backups are clean i.e backing up only what is needed, and the correct number of versioning is being applied to files, and reclamation is used, if there is a

Re: Tape Housecleaning

2005-07-05 Thread Kelly Martin
On 7/5/05, Richard Mochnaczewski [EMAIL PROTECTED] wrote: Hi Everybody, Does anyone have any thoughts on saving on the number of tapes TSM uses ? After auditing our backups and finding that the backups are clean i.e backing up only what is needed, and the correct number of versioning is