Re: On which volumes are my files?
Richard Sims schrieb: A very obvious but conspicuously missing option from client restores is a Preview capability, which would nicely address this restoral planning need that has historically been the subject of so many postings. When you think about it, it's rather amazing that the product has us embark upon restorals with no fore-awareness of what will be involved. A Preview capability would tell us: - What volumes would be required; - If all the volumes are available (onsite, offsite, volumes Unavailable, files Damaged, etc.); - If sufficient drives are available, and how many would be used; - The amount of data that will be restored. As I say, all this is too obvious... So how come Development has never added such a capability to the product? Competition with other products should alone be enough incentive. Richard Sims, BU There seems to be no obvious answer to your last question ;-). Anyway, I would be happy to find such a preview capability in a future release. Werner
Re: On which volumes are my files?
Richard Sims wrote: Does anyone know a fast way to get a list of all volumes on which a node has files of a specific subdirectory? A query of the volumeusage table does the job on filespace level but not on file/directory level. The only way I know is to search in the output of query content or the corresponding select query which is very slow. The Content query is the standard method - which has to wend its way through the whole file inventory to gather the limited information you need. There is another, creative approach: Perform a client restore of that subdirectory to a trash area, and then see what tapes were mounted. :-) If you have ready access to the same type of system as that client, and know the client's password, you can perform the restoral cross-node, and not actually have to use that client. Restore doesn't have to go through the SQL layers that we have to when issuing server commands, and is certainly far faster. In fact I often wondered why a restore of a specific file or directory can start so fast if a simple query for the same things is so slow. I understand that walking through the file inventory is time consuming as well as the SQL layers. I hoped there is a method to do it the same way the restore does it. Although I agree perfectly that your approach would be much faster it is not feasible in this case: The reason behind the original question was to get in advance a list of offsite tapes which have to be checked in for a file or directory restore operation before starting the restore itself. If you have no collocation and quite small tapes like 3570 the list you will get by a simple volumeusage query can be fairly large and it would be nice to shrink it to the really needed tapes. Thanks for all answers, Werner
Re: On which volumes are my files?
Although I agree perfectly that your approach would be much faster it is not feasible in this case: The reason behind the original question was to get in advance a list of offsite tapes which have to be checked in for a file or directory restore operation before starting the restore itself. If you have no collocation and quite small tapes like 3570 the list you will get by a simple volumeusage query can be fairly large and it would be nice to shrink it to the really needed tapes. A very obvious but conspicuously missing option from client restores is a Preview capability, which would nicely address this restoral planning need that has historically been the subject of so many postings. When you think about it, it's rather amazing that the product has us embark upon restorals with no fore-awareness of what will be involved. A Preview capability would tell us: - What volumes would be required; - If all the volumes are available (onsite, offsite, volumes Unavailable, files Damaged, etc.); - If sufficient drives are available, and how many would be used; - The amount of data that will be restored. As I say, all this is too obvious... So how come Development has never added such a capability to the product? Competition with other products should alone be enough incentive. Richard Sims, BU
Knowledge of node's password is not mandatory (was Re: On which volumes are my files?)
-- ... and know the client's password ... This is not mandatory! Every administrator with node owner (or system) authority can use nodename/virtualnodename option authenticating to the server with admin_id/admin_pwd instead of node_id/node_pwd. The wording from Administrator's Reference, GRAnt AUTHority command: A user with client owner authority can access a web backup-archive client through the web client interface and also access their data from another client using the -NODENAME parameter This also helps avoid force-change of generated node's password. I've done it many times myself. Zlatko Krastev IT Consultant Richard Sims [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 03.01.2003 14:33 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: On which volumes are my files? Does anyone know a fast way to get a list of all volumes on which a node has files of a specific subdirectory? A query of the volumeusage table does the job on filespace level but not on file/directory level. The only way I know is to search in the output of query content or the corresponding select query which is very slow. The Content query is the standard method - which has to wend its way through the whole file inventory to gather the limited information you need. There is another, creative approach: Perform a client restore of that subdirectory to a trash area, and then see what tapes were mounted. :-) If you have ready access to the same type of system as that client, and know the client's password, you can perform the restoral cross-node, and not actually have to use that client. Restore doesn't have to go through the SQL layers that we have to when issuing server commands, and is certainly far faster. Richard Sims, BU Think different. - Apple
On which volumes are my files?
Does anyone know a fast way to get a list of all volumes on which a node has files of a specific subdirectory? A query of the volumeusage table does the job on filespace level but not on file/directory level. The only way I know is to search in the output of query content or the corresponding select query which is very slow. Thanks for any ideas, Werner -- Werner BaurTel.:++49-89-28928781 Leibniz-Rechenzentrum Fax:++49-89-2809460 Barer Str. 21mailto:[EMAIL PROTECTED] D-80333 Muenchen, Germany http://www.lrz.de
Re: On which volumes are my files?
Hi I generally use the following select statement, however if there is an easier way please let me know. select distinct node_name,volume_name,stgpool_name from volumeusage where node_name='nodename' and stgpool_name='storage pool' Lawrie -Original Message- From: Werner Baur [mailto:[EMAIL PROTECTED]] Sent: 03 January 2003 09:33 To: [EMAIL PROTECTED] Subject: On which volumes are my files? Does anyone know a fast way to get a list of all volumes on which a node has files of a specific subdirectory? A query of the volumeusage table does the job on filespace level but not on file/directory level. The only way I know is to search in the output of query content or the corresponding select query which is very slow. Thanks for any ideas, Werner -- Werner BaurTel.:++49-89-28928781 Leibniz-Rechenzentrum Fax:++49-89-2809460 Barer Str. 21mailto:[EMAIL PROTECTED] D-80333 Muenchen, Germany http://www.lrz.de
Re: On which volumes are my files?
Does anyone know a fast way to get a list of all volumes on which a node has files of a specific subdirectory? A query of the volumeusage table does the job on filespace level but not on file/directory level. The only way I know is to search in the output of query content or the corresponding select query which is very slow. The Content query is the standard method - which has to wend its way through the whole file inventory to gather the limited information you need. There is another, creative approach: Perform a client restore of that subdirectory to a trash area, and then see what tapes were mounted. :-) If you have ready access to the same type of system as that client, and know the client's password, you can perform the restoral cross-node, and not actually have to use that client. Restore doesn't have to go through the SQL layers that we have to when issuing server commands, and is certainly far faster. Richard Sims, BU Think different. - Apple
Réf. : Re: On which volumes are my files?
I use this kind of script ... It works
$1 node name
$2 name of pool
select
volumeusage.volume_name,volumes.access,volumes.error_state,volumeusage.stgpool_name
from volumeusage,volumes where volumeusage.node_name=upper('$1')and
volumeusage.stgpool_name='$2' and volumeusage.volume_name =
volumes.volume_name order by volume_name
Cordialement
François Chevallier
Parc Club du Moulin à Vent
33 av G Levy
69200 - Vénissieux France
tél : 04 37 90 40 56
Re: On which volumes are my files?
it seems it be easier to just create a backupset with a 1 day retention. Tony Garrison I/T Sr. Systems Programmer USAA 210-913-9836 -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 6:34 AM To: [EMAIL PROTECTED] Subject: Re: On which volumes are my files? Does anyone know a fast way to get a list of all volumes on which a node has files of a specific subdirectory? A query of the volumeusage table does the job on filespace level but not on file/directory level. The only way I know is to search in the output of query content or the corresponding select query which is very slow. The Content query is the standard method - which has to wend its way through the whole file inventory to gather the limited information you need. There is another, creative approach: Perform a client restore of that subdirectory to a trash area, and then see what tapes were mounted. :-) If you have ready access to the same type of system as that client, and know the client's password, you can perform the restoral cross-node, and not actually have to use that client. Restore doesn't have to go through the SQL layers that we have to when issuing server commands, and is certainly far faster. Richard Sims, BU Think different. - Apple
Re: On which volumes are my files?
Hi Werner Here's one that shows volumes by filespacename and stgpool name select distinct node_name,volume_name,stgpool_name from volumeusage where node_name='$1' and filespace_name='$2' and stgpool_name'$3' Laura Buckley SSSI/STORServer, Inc. [EMAIL PROTECTED] -Original Message- From: Werner Baur [mailto:[EMAIL PROTECTED]] Sent: 03 January 2003 09:33 To: [EMAIL PROTECTED] Subject: On which volumes are my files? Does anyone know a fast way to get a list of all volumes on which a node has files of a specific subdirectory? A query of the volumeusage table does the job on filespace level but not on file/directory level. The only way I know is to search in the output of query content or the corresponding select query which is very slow. Thanks for any ideas, Werner -- Werner BaurTel.:++49-89-28928781 Leibniz-Rechenzentrum Fax:++49-89-2809460 Barer Str. 21mailto:[EMAIL PROTECTED] D-80333 Muenchen, Germany http://www.lrz.de
Re: On which volumes are my files?
Oops - Correction to my last post. I took my select from a script I wrote trying to find volumes that weren't in certain pools. Here's what I really meant select distinct volume_name,stgpool_name from volumeusage where node_name='$1' and filespace_name='$2' and stgpool_name='$3' Laura -Original Message- From: Werner Baur [mailto:[EMAIL PROTECTED]] Sent: 03 January 2003 09:33 To: [EMAIL PROTECTED] Subject: On which volumes are my files? Does anyone know a fast way to get a list of all volumes on which a node has files of a specific subdirectory? A query of the volumeusage table does the job on filespace level but not on file/directory level. The only way I know is to search in the output of query content or the corresponding select query which is very slow. Thanks for any ideas, Werner -- Werner BaurTel.:++49-89-28928781 Leibniz-Rechenzentrum Fax:++49-89-2809460 Barer Str. 21mailto:[EMAIL PROTECTED] D-80333 Muenchen, Germany http://www.lrz.de
