Re: Volume sequence
Norita, It sounds like your management is attempting to impose a standard derived for a less sophisticated product onto TSM. What they want, as I read it, is an assurance that they know what is on any given tape, in case of a disaster recovery - if that is the case, then they need an offsite database backup, and a recovery plan file: nothing else will do. That way they know which offsite tape has the latest database backup and can perform a restore if need be. Ask them for the result that they wish to achieve, not the means to provide it. I realize that as a technician it is often difficult to resist the unreasonable and unthinking demands of management, but you are the one who is charged with running this, not them. Be firm. Regards Steve. Steve Harris Brisbane, Australia - Original Message - From: "Norita binti Hassan" <[EMAIL PROTECTED]> To: Sent: Friday, March 11, 2005 1:13 PM Subject: Re: [ADSM-L] Volume sequence Thanks.. where can we get documentation or manual on the 'Show" command? But what my management want is a list of tapes, their nodes and the file sequence number and the backup date From whisch tables can I retreive all these info. e.g Tape Number Node Name Backup Date Seq. No --- - --- -- TEST001 SERVER01 2005-01-01 1 TEST001 SERVER01 2005-01-01 2 TEST002 SERVER03 2005-01-05 1 TEST003 SERVER05 2005-01-05 1 So, from this report, we will know that 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, "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.v o 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.v o 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: 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 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.
Re: Volume sequence
Thanks.. where can we get documentation or manual on the 'Show" command? But what my management want is a list of tapes, their nodes and the file sequence number and the backup date From whisch tables can I retreive all these info. e.g Tape Number Node Name Backup Date Seq. No --- - --- -- TEST001 SERVER012005-01-01 1 TEST001 SERVER012005-01-01 2 TEST002 SERVER032005-01-05 1 TEST003 SERVER052005-01-05 1 So, from this report, we will know that 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, "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.v o >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.v o >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: >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 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.
Re: Volume sequence
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: 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
Re: Volume sequence
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 volumes: there doesn't need to be, as restorals may be for individual files or directories which may be on various tapes. TSM catalogs the location of aggregates of files on their containing tapes: it knows where to get files when it needs them. For your purposes, once you know the volumes associated with a node (volumeusage info) then you can simply sort by Last Write Date. But, again, such sequencing is artificial and of no real value. Richard Sims
Re: Volume sequence
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: 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.
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.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.pct_utilized,vo.volume_name - order by vo.volume_name, - vu.node_name,vu.copy_type,vo.pct_utilized - Original Message - From: "Norita binti Hassan" <[EMAIL PROTECTED]> To: 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.
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.