Hello,
I have tried this command: select * from volumeusage where
node_name='NAS_SERVER_2_OFFSITE' and have received the following output:
NODE_NAME: NAS_SERVER_2_OFFSITE
COPY_TYPE: BACKUP
FILESPACE_NAME: /
STGPOOL_NAME: TAPE_NDMP_OFFSITE
VOLUME_NAME: N00020
FILESPACE_ID: 47
I guess my next question would be, how do I find a listing of particular
tapes that were just created over the weekend? Saturday (3/18/2006) and
Sunday (3/19/2006)
I believe that I would probably also combine this command with either the
volumes or volhistory table, but I cannot seem to find a way to
successfully combine them. Any help is appreciated! Thanks!
********************************
Joni Moyer
Highmark
Storage Systems, Senior Systems Programmer
Phone Number: (717)302-9966
Fax: (717) 302-9826
[EMAIL PROTECTED]
********************************
"Choudarapu,
Ramakrishna
(GTI)" To
<Ramakrishna_Chou ADSM-L@VM.MARIST.EDU
[EMAIL PROTECTED]> cc
Sent by: "ADSM:
Dist Stor Subject
Manager" Re: Find what tape a particular
<[EMAIL PROTECTED] backup resides on
.EDU>
03/22/2006 10:14
AM
Please respond to
"ADSM: Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
SELECT VOLUME_NAME FROM VOLUMEUSAGE WHERE NODE_NAME='node_name'
Regards,
Rama
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: Wednesday, March 22, 2006 10:05 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Find what tape a particular backup resides on
Hello everyone,
I am trying to figure out what tape a particular backup is on for our
NAS
NDMP full backups. I noticed that you can query the node_name, FSID,
filespace_name, etc. but is there a way that I can tie the volume table
onto this so that I can see which tape(s) have server_1's backups on?
This
is on a TSM 5.2.4.5 server on AIX. Thanks in advance!
********************************
Joni Moyer
Highmark
Storage Systems, Senior Systems Programmer
Phone Number: (717)302-9966
Fax: (717) 302-9826
[EMAIL PROTECTED]
********************************
--------------------------------------------------------
If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain
or redistribute it. Click here for important additional terms relating to
this e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------
