Re: how to identify ofsite tapes for specific node
My knowledge of select statements is fairly limited but you will probably have to use the information in the BACKUPS table but I am unsure how to figure out which tape the file is stored on. My guess is to use the OBJECT_ID field and there must be another table that stores what tape that OBJECT_ID is on. Julian Armendariz System Support Analyst - UNIX H.B. Fuller >>> [EMAIL PROTECTED] 03/07/02 02:53AM >>> Julian, I have been having a look at using your select statement below and with slight modifications I am getting the number of tapes that are needed for each filespace for the particular node. I believe that the results brought back by this select command are effectively any tape which has a file from the particular filespace, whether it be an active copy or an inactive copy. I tested this by running the statement against a filespace on a node and it came back with a list of 7 tapes that would be needed. I then performed a selective backup of that filespace and allowed the overnight processing to do its stuff (updating all the offsite pools). Checking the results this morning instead of just having one tape returned, 8 tapes were listed. My question to you or anyone out there who knows more about select statements than me (a lot of people I reckon) is: Is there a select statement that would bring back a list of tapes that would be needed to restore a particular filespace for a node that only takes into account the active files needed? Thanks in advance Steve Copper -Original Message- From: Julian Armendariz [mailto:[EMAIL PROTECTED]] Sent: 05 March 2002 14:56 To: [EMAIL PROTECTED] Subject: Re: how to identify ofsite tapes for specific node This email and any files transmitted have been checked by the MessageLabs Virus Scanning Service for the presence of computer viruses. Please exercise caution when receiving any attachment(s) from unknown sources. If in any doubt, do not open any attachment and delete the message immediately. Thank you for your co-operation. _ I use this SQL script to get the volumes used by a specific node in a specific storagepool. select distinct node_name,volume_name from volumeusage where node_name=upper('$1') and stgpool_name=upper('$2') You can either run this from a command line and replace the $1 with the node name and $2 with the storage pool or add the script to the server and type "run name_of_script nodename storagepool". You can type the names either upper or lower case. Julian Armendariz System Support Analyst - UNIX H.B. Fuller >>> [EMAIL PROTECTED] 03/04/02 09:39PM >>> hi guys, please help me to identify offsite tapes belong to a specific node. i have a problem on my onsite tapes for specific node but i could not easily identify which offsite tapes belong to that node from my offsite location. Do you have a SQL scripts or commands to get done this tasks? your help is really appreciated. thanks, Zosi Noriega ADNOC - UAE _ This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this message has been swept for all known viruses by the MessageLabs Virus Scanning Service. For further information please visit http://www.messagelabs.com
Re: how to identify ofsite tapes for specific node
Julian, I have been having a look at using your select statement below and with slight modifications I am getting the number of tapes that are needed for each filespace for the particular node. I believe that the results brought back by this select command are effectively any tape which has a file from the particular filespace, whether it be an active copy or an inactive copy. I tested this by running the statement against a filespace on a node and it came back with a list of 7 tapes that would be needed. I then performed a selective backup of that filespace and allowed the overnight processing to do its stuff (updating all the offsite pools). Checking the results this morning instead of just having one tape returned, 8 tapes were listed. My question to you or anyone out there who knows more about select statements than me (a lot of people I reckon) is: Is there a select statement that would bring back a list of tapes that would be needed to restore a particular filespace for a node that only takes into account the active files needed? Thanks in advance Steve Copper -Original Message- From: Julian Armendariz [mailto:[EMAIL PROTECTED]] Sent: 05 March 2002 14:56 To: [EMAIL PROTECTED] Subject: Re: how to identify ofsite tapes for specific node This email and any files transmitted have been checked by the MessageLabs Virus Scanning Service for the presence of computer viruses. Please exercise caution when receiving any attachment(s) from unknown sources. If in any doubt, do not open any attachment and delete the message immediately. Thank you for your co-operation. _ I use this SQL script to get the volumes used by a specific node in a specific storagepool. select distinct node_name,volume_name from volumeusage where node_name=upper('$1') and stgpool_name=upper('$2') You can either run this from a command line and replace the $1 with the node name and $2 with the storage pool or add the script to the server and type "run name_of_script nodename storagepool". You can type the names either upper or lower case. Julian Armendariz System Support Analyst - UNIX H.B. Fuller >>> [EMAIL PROTECTED] 03/04/02 09:39PM >>> hi guys, please help me to identify offsite tapes belong to a specific node. i have a problem on my onsite tapes for specific node but i could not easily identify which offsite tapes belong to that node from my offsite location. Do you have a SQL scripts or commands to get done this tasks? your help is really appreciated. thanks, Zosi Noriega ADNOC - UAE _ This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this message has been swept for all known viruses by the MessageLabs Virus Scanning Service. For further information please visit http://www.messagelabs.com
Re: how to identify ofsite tapes for specific node
I use this SQL script to get the volumes used by a specific node in a specific storagepool. select distinct node_name,volume_name from volumeusage where node_name=upper('$1') and stgpool_name=upper('$2') You can either run this from a command line and replace the $1 with the node name and $2 with the storage pool or add the script to the server and type "run name_of_script nodename storagepool". You can type the names either upper or lower case. Julian Armendariz System Support Analyst - UNIX H.B. Fuller >>> [EMAIL PROTECTED] 03/04/02 09:39PM >>> hi guys, please help me to identify offsite tapes belong to a specific node. i have a problem on my onsite tapes for specific node but i could not easily identify which offsite tapes belong to that node from my offsite location. Do you have a SQL scripts or commands to get done this tasks? your help is really appreciated. thanks, Zosi Noriega ADNOC - UAE
Re: how to identify ofsite tapes for specific node
I use this script to gather tapes for DR testing. I think this is what you want: Name Line Command Number -- -- BRSLIST1 select volume_name,status from volumes where volume_name in (select volume_name from volumeusage where node_name='$1'and stgpool_name='$2') order by status,volume_name NameDescription Managing profile --- -- BRSLIST Usage: RUN BRSLIST SERVERNAME STGPOOLNAME i.e. 'Run brslist FS010 COPYVAULT' - Server and stgpool must be UPPER CASE. Take care, Al Alan Davenport Senior Storage Administrator Selective Insurance [EMAIL PROTECTED] (973) 948-1306 -Original Message- From: Zosimo Noriega (ADNOC IS&T) [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 10:39 PM To: [EMAIL PROTECTED] Subject: how to identify ofsite tapes for specific node hi guys, please help me to identify offsite tapes belong to a specific node. i have a problem on my onsite tapes for specific node but i could not easily identify which offsite tapes belong to that node from my offsite location. Do you have a SQL scripts or commands to get done this tasks? your help is really appreciated. thanks, Zosi Noriega ADNOC - UAE
Re: how to identify ofsite tapes for specific node
You could try something like this: select volume_name from volumes where volume_name in (select distinct volume_name from contents where node_name='STORMAN') and stgpool_name='COPYPOOL' and access='OFFSITE' (This is one long command that I put on multiple lines for readability.) Notes: - You will need to change COPYPOOL to whatever your offsite storage pool is. - You will need to change STORMAN to whatever node name you are interested in. - The values in single quotes must be in upper case, as I have depicted. - If the volumes in the volume name column wrap (i.e. if the volume names are greater than 18 characters), you can extend the column width like this: select volume_name as "VOLUME NAME" from volumes ... etc. Hope this helps, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. hi guys, please help me to identify offsite tapes belong to a specific node. i have a problem on my onsite tapes for specific node but i could not easily identify which offsite tapes belong to that node from my offsite location. Do you have a SQL scripts or commands to get done this tasks? your help is really appreciated. thanks, Zosi Noriega ADNOC - UAE