The undocumented, but well known, "show volumeusage node_name" lists the volumes in the order they were assigned to the client.
At 10:51 AM 3/10/2005 +0800, you 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 .
~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 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.volume_name=vu.volume_name - group by vu.node_name,vo.status,vu.copy_type,vo.est_capacity_mb,vo.pct_utilized,vo.vo lume_name - order by vo.volume_name, - vu.node_name,vu.copy_type,vo.pct_utilized
----- Original Message ----- From: "Norita binti Hassan" <[EMAIL PROTECTED]> To: <ADSM-L@VM.MARIST.EDU> Sent: Wednesday, March 09, 2005 11:51 AM Subject: Volume sequence
> Hi, > > Is there any select statement that can display the volume sequence number > so > that I can list all the volumes in sequence that has been used by specific > node. > > NORITA BINTI HASAN > Senior Programmer > Enterprise Systems Services > Information Communication Tech.Div > 6th Floor, Pos Malaysia Berhad > 50670 Kuala Lumpur > > Tel : 03 - 22756638 > > > > Pos Malaysia Berhad is Malaysia's national postal company > Visit us online at www.pos.com.my > > NOTICE > This message may contain privileged and/or confidential > information. If you are not the addressee or authorised > to receive this email, you must not use, copy, disclose > or take any action based on this email. If you have > received this email in error, please advise the sender > immediately by reply e-mail and delete this message. > Pos Malaysia Berhad takes no responsibility for the > contents of this email. >
Pos Malaysia Berhad is Malaysia's national postal company Visit us online at www.pos.com.my
NOTICE This message may contain privileged and/or confidential information. If you are not the addressee or authorised to receive this email, you must not use, copy, disclose or take any action based on this email. If you have received this email in error, please advise the sender immediately by reply e-mail and delete this message. Pos Malaysia Berhad takes no responsibility for the contents of this email.
Fred Johanson ITSM Administrator University of Chicago 773-702-8464
