Re: SV: Suggestion for Archive?

2008-01-04 Thread Henrik Wahlstedt
Hi, I agree and I understand that you will have gaps whenever you use periodic archives/backups. But you are actually suggesting via delete filsapce command to aggressivly framgment TSM DB. And to only make one export copy..?? Export volumes are not part of a stgpool and therefore not included i

Obtaining stats with proxynode...

2008-01-04 Thread Ibán Bernaldo de Quirós Márquez
Hi, Taking a look to the summary table I find the following... At this time I was using a proxynode config to backup a big gpfs: Fields, node_name,date,activity,start,end,length,Gibabytes,files,successful MN_GPFS_PRO1 2008-01-03 BACKUP 23:03:44 02:35:42 03:31:58

Select statement

2008-01-04 Thread Ribeiro, Ricardo
Hello, Does anyone has a select statement I can use to find out how many tapes I used on a daily basis? Thanks!

Re: Select statement

2008-01-04 Thread Choudarapu, Ramakrishna (GTI)
We use this to find out the scratch counts: select library_name, status, count(*) as VOL_COUNT from libvolumes group by library_name,status Is this the one, you are looking for? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ribeiro, Ricardo Sent:

Re: Select statement

2008-01-04 Thread Ribeiro, Ricardo
No, I need one that tells me how many I used and not how many I have... Thanks! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Choudarapu, Ramakrishna (GTI) Sent: Friday, January 04, 2008 11:17 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Sele

Re: Select statement

2008-01-04 Thread Larry Peifer
This is what I run to get that kind of information: select library_name,volume_name from libvolumes where status='Scratch' select stgpool_name,status,count(*) from volumes where scratch='YES' group by stgpool_name,status select library_name, last_use, status, count(status) from libvolumes group

Re: Select statement

2008-01-04 Thread Richard Sims
On Jan 4, 2008, at 1:12 PM, Ribeiro, Ricardo wrote: Hello, Does anyone has a select statement I can use to find out how many tapes I used on a daily basis? Thanks! Most commonly, tapes automatically come from the scratches collection and return to scratch when emptied (rather than being assign

Re: Select statement

2008-01-04 Thread Ribeiro, Ricardo
Thank you! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Friday, January 04, 2008 12:47 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Select statement On Jan 4, 2008, at 1:12 PM, Ribeiro, Ricardo wrote: > Hello, > Does any

Little problem

2008-01-04 Thread Darcy Roberto Ganga Ponce
Hi, I need your help. I try archiving the Datafile and redolog the oracle using dsmc arch, but have the next problem. Node Name: LAJA Session established with server TSM: AIX-RS/6000 Server Version 5, Release 4, Level 2.0 Server date/time: 01/04/08 17:58:25 Last access: 01/04/08 17:48:

Re: Select statement

2008-01-04 Thread Fred Johanson
You could also look at volhistory where use(?)='STGNEW' and date =desired range. From: ADSM: Dist Stor Manager on behalf of Ribeiro, Ricardo Sent: Fri 1/4/2008 2:51 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Select statement Thank you! -Original Mes