Re: Volume sequence

2005-03-10 Thread Steven Harris
VER01 used 2 tapes and so on. Can anybody help me?? Thank you ~Norita Hasan~ -Original Message- From: fred johanson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 10:43 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Volume sequence The undocumented, but well known, "show volumeusa

Re: Volume sequence

2005-03-10 Thread Norita binti Hassan
t SERVER01 used 2 tapes and so on. Can anybody help me?? Thank you ~Norita Hasan~ -Original Message- From: fred johanson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 10:43 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Volume sequence The undocumented, but well known, "s

Re: Volume sequence

2005-03-10 Thread fred johanson
ied more than 1 tape. How do I know which tape is the first one, and which is next . ~Norita Hasan~ -Original Message- From: goc [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 8:53 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Volume sequence you can try this ... it givec a lot more an

Re: Volume sequence

2005-03-10 Thread Richard Sims
On Mar 9, 2005, at 9:51 PM, Norita binti Hassan wrote: I've tried that script, but I need to know the file sequence. Eg. I have a large database of 170GB.It should occupied more than 1 tape. How do I know which tape is the first one, and which is next . There is no sequence numbering of filespace v

Re: Volume sequence

2005-03-09 Thread Norita binti Hassan
esday, March 09, 2005 8:53 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Volume sequence you can try this ... it givec a lot more and it's useful i think select vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.pct_utilized,vo.vo lume_name - from volumeusage vu,volumes vo - where vo.v

Re: Volume sequence

2005-03-09 Thread goc
you can try this ... it givec a lot more and it's useful i think select vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.pct_utilized,vo.volume_name - from volumeusage vu,volumes vo - where vo.volume_name=vu.volume_name - group by vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.p