Re: Problem is still there with a LTO volume

2008-04-04 Thread Thorneycroft, Doug
for a mount, but it should eventually time out.) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Jacquelin Bouchard Sent: Friday, April 04, 2008 5:13 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Problem is still there with a LTO volume Hi, Is the

Re: Problem is still there with a LTO volume

2008-04-04 Thread Jacquelin Bouchard
Hi, Thanks for your help, the problem is solved now; as recommended by Doug and Richard, i run these commands: update vol A00043 access=readw audit volume a00043 fix=yes and now the volume status is "empty". Jacquelin Bouchard At 08:34 2008-04-04 -0400, you wrote: On Apr 4, 2008, at 8:

Re: Problem is still there with a LTO volume

2008-04-04 Thread Richard Sims
On Apr 4, 2008, at 8:12 AM, Jacquelin Bouchard wrote: Hi, Is the audit process read the tape, because the volume is really "offsite" in vault ? Have you tried changing the access mode of the tape to readwrite (or even readonly) as Doug recommended yesterday? In the case of a database i

Re: Problem is still there with a LTO volume

2008-04-04 Thread Jacquelin Bouchard
PROTECTED] Behalf Of Jacquelin Bouchard Sent: Thursday, April 03, 2008 1:20 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Problem is still there with a LTO volume Hi Richard, I have tried to audit the volume: audit volume a00043 fix=yes Output: ANR2425E AUDIT VOLUME: Unable to acc

Re: Problem is still there with a LTO volume

2008-04-03 Thread Thorneycroft, Doug
Update vol to access=readwrite and try the audit again. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Jacquelin Bouchard Sent: Thursday, April 03, 2008 1:20 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Problem is still there with a LTO volume Hi

Re: Problem is still there with a LTO volume

2008-04-03 Thread Jacquelin Bouchard
Hi Richard, I have tried to audit the volume: audit volume a00043 fix=yes Output: ANR2425E AUDIT VOLUME: Unable to access volume A00043 - access mode is set to "offsite". Jacquelin Bouchard At 15:35 2008-04-03 -0400, you wrote: This volume is probably the victim of a TSM datab

Re: Problem is still there with a LTO volume

2008-04-03 Thread Warren Becker
PROTECTED] On Behalf Of Jacquelin Bouchard Sent: Thursday, April 03, 2008 2:23 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Problem is still there with a LTO volume 1) q vol a00043 f=d Output: Volume Name : A00043 Storage Pool Name : TPCE_BCK_DATA_COPY Device Class N

Re: Problem is still there with a LTO volume

2008-04-03 Thread Richard Sims
This volume is probably the victim of a TSM database inconsistency, where an AUDit Volume will likely be needed to clear its problem. Richard Sims

Re: Problem is still there with a LTO volume

2008-04-03 Thread Thorneycroft, Doug
till there with a LTO volume 1) q vol a00043 f=d Output: Volume Name : A00043 Storage Pool Name : TPCE_BCK_DATA_COPY Device Class Name : LTO2 Estimated Capacity : 381 468 Scaled Capacity Applied : Pct Util : 0,2 Vol

Problem is still there with a LTO volume

2008-04-03 Thread Jacquelin Bouchard
1) q vol a00043 f=d Output: Volume Name : A00043 Storage Pool Name : TPCE_BCK_DATA_COPY Device Class Name : LTO2 Estimated Capacity : 381 468 Scaled Capacity Applied : Pct Util : 0,2 Volume Status :Filling Access :

Re: Something special with a LTO Volume

2008-04-02 Thread Jacquelin Bouchard
Hi Thomas, The 2 commands give the same result: ANR2034E QUERY CONTENT: No match found using this criteria. The LTO is a copy in vault of something in a tape storage pool; maybe, it will be necessary to recreate all the copies for vault of this originating tape storage pool. Jacquelin Bouch

Re: Something special with a LTO Volume

2008-04-02 Thread Thomas Denier
-Jacquelin Bouchard wrote: - >When i execute the following request for a particular volume >(A00043) > > [SQL deleted] > >>this result is printed and everything is OK > >VOL_NAME: A00043 >STGPOOL_NAME: TPCE_BCK_DATA_COPY >EST_CPCTY_MB:381468.0 >PCT_UTIL: 0.

Something special with a LTO Volume

2008-04-02 Thread Jacquelin Bouchard
Hello, When i execute the following request for a particular volume (A00043) select - volumes.volume_name as "VOL_NAME",- volumes.stgpool_name as "STGPOOL_NAME",- volumes.est_capacity_mb as "EST_CPCTY_MB",- volumes.pct_utilized as "PCT_UTIL",- vol

Re: LTO Volume

2005-03-10 Thread Loon, E.J. van - SPLXM
ECTED] Behalf Of Richard Sims Sent: Sunday, 6 March 2005 1:14 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: LTO Volume Akash - I term this "Tape leak", as I summarize in http://people.bu.edu/rbs/ADSM.QuickFacts . We had a good discussion of this about 6 months ago on ADSM-L. One member was pursu

Re: LTO Volume

2005-03-09 Thread Akash Jain
ACCESS: READWRITE LAST_WRITE_DATE: 2005-03-08 05:57:28 Regards Akash -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Richard Sims Sent: Sunday, 6 March 2005 1:14 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: LTO Volume Akash - I term this "Tape

Re: LTO Volume

2005-03-07 Thread Iain Barnetson
IL PROTECTED] On Behalf Of Andreas Priebe Sent: 07 March 2005 15:29 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] LTO Volume Hi Iain > tsm: ABZBKUP001>SELECT STGPOOL_NAME AS "STORAGE POOL ", > - > cont> CHAR(VOLUME_NAME,6) AS "VOLNAME", PCT_UTILIZED as &quo

Re: LTO Volume

2005-03-07 Thread Andreas Priebe
Hi Iain tsm: ABZBKUP001>SELECT STGPOOL_NAME AS "STORAGE POOL ", - cont> CHAR(VOLUME_NAME,6) AS "VOLNAME", PCT_UTILIZED as "PCT UTIL", - cont> DEC(EST_CAPACITY_MB,7) AS "MB_CAPACITY", CHAR(ACCESS,11) AS "ACCESS", - cont> LEFT(CHAR(LAST_WRITE_DATE),19) AS "LAST_WRITE_DATE" -

Re: LTO Volume

2005-03-07 Thread Iain Barnetson
r UKN Infrastructure Operations -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: 07 March 2005 15:03 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] LTO Volume If you look up message ANR2948E, it will tell you what the trouble is. Yo

Re: LTO Volume

2005-03-07 Thread Andrew Raibeck
SQL > data type DECIMAL(7,1). > > | > V.. > ED as "PCT UTIL", DEC(EST_CAPACITY_MB,7) AS "MB_CAPACITY", CH > > ANS8001I Return code 26. > >

Re: LTO Volume

2005-03-07 Thread Iain Barnetson
NR2948E The value '4096000.0' can not be assigned or converted to SQL data type DECIMAL(7,1). | V.. ED as "PCT UTIL", DEC(EST_CAPACITY_MB,7) AS "MB_CAPACITY",

Re: LTO Volume

2005-03-07 Thread Richard Sims
Good suggestion, Andreas, now that we're getting into "terrorbytes". thanks, Richard Sims On Mar 7, 2005, at 8:28 AM, Andreas Priebe wrote: Hi Richard, The Select is tried-and-true, and works well. On one of my TSM servers it gives me an SQL error due to the formmating: ANR2948E The value '381468

Re: LTO Volume

2005-03-07 Thread Andreas Priebe
Hi Richard, The Select is tried-and-true, and works well. On one of my TSM servers it gives me an SQL error due to the formmating: ANR2948E The value '381468.0' can not be assigned or converted to SQL data type DECIMAL(6,1). | V.

Re: LTO Volume

2005-03-07 Thread Richard Sims
On Mar 7, 2005, at 6:25 AM, Iain Barnetson wrote: Ruichard, I tried the SQL query below that you gave, but got an error "where status='filling'" at the '=' bit And the error was... ? The Select is tried-and-true, and works well. Perhaps you tried to string the whole command out on one line, rather

Re: LTO Volume

2005-03-07 Thread Iain Barnetson
ROTECTED] On Behalf Of Richard Sims Sent: 05 March 2005 19:44 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] LTO Volume Akash - I term this "Tape leak", as I summarize in http://people.bu.edu/rbs/ADSM.QuickFacts . We had a good discussion of this about 6 months ago on ADSM-L. One memb

Re: LTO Volume

2005-03-06 Thread Richard Sims
Akash - In analyzing problems, get into the habit of acquiring the complete information available about the ingredients of the problem scenario so that it becomes more understandable. In this case, problem analysis is handicapped by not employing the Format=Detailed option of Query commands, in par

Re: LTO Volume

2005-03-05 Thread Akash Jain
ailto:[EMAIL PROTECTED] Behalf Of Richard Sims Sent: Sunday, 6 March 2005 1:14 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: LTO Volume Akash - I term this "Tape leak", as I summarize in http://people.bu.edu/rbs/ADSM.QuickFacts . We had a good discussion of this about 6 months ago on ADSM-L. On

Re: LTO Volume

2005-03-05 Thread Richard Sims
, at 12:27 PM, Akash Jain wrote: Hi experts, I have one simple query. While taking backups on LTO through, it occupies new LTO volume only after the used and in process volume will display status as ‘FULL’. But in my case I had observed that it had started taking backup on other LTO vo

LTO Volume

2005-03-05 Thread Akash Jain
Hi experts, I have one simple query. While taking backups on LTO through, it occupies new LTO volume only after the used and in process volume will display status as ‘FULL’. But in my case I had observed that it had started taking backup on other LTO volume in spite of the previous one in

Corrupt LTO volume restore

2004-05-13 Thread Copperfield Adams
Hi all, A couple of days ago I had a problem with missing slots in my 3583 library. With your advice I managed to discover that it was due to a corrupt volume that would not read during and 'AUDIT LIBR'. I have subsequently set the status of the tape to 'DESTROYED' and recalled necessary volume