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
