Re: [ADSM-L] Request for some TSM queries to use
2009-01-07 17:03:07
You need to change the " to '
Other than that it works fine.
Andy Huebner
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Larry Clark
Sent: Wednesday, January 07, 2009 3:16 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Request for some TSM queries to use
Hi,
My TSM query usage is a bit rusty. These days it's VIO builds but I need to
participate in a customer DR exercise and will be restoring files to AIX
servers by fs (mount point). To avoid resource conflicts I'd like to be able
to determine what filespaces are on what volumes by node. Would this do it
from the TSN command line? Since I normally do not have access to the TSM
server I will not be able to test it until the DR exercise:
SELECT VOLUMEUSAGE.NODE_NAME, VOLUMEUSAGE.COPY_TYPE,
VOLUMEUSAGE.FILESPACE_NAME, VOLUMEUSAGE.STGPOOL_NAME,
VOLUMEUSAGE.VOLUME_NAME FROM VOLUMEUSAGE
WHERE (((VOLUMEUSAGE.NODE_NAME)="MY_NODE_NAME") AND
((VOLUMEUSAGE.STGPOOL_NAME)="MY_STG_POOL"));
Also, does anyone have a query that would produce a list of what nodes
occupy what volumes? We may have time to produce an overall usage list while
the mksysbs are being restored prior to the restore of the mount points.
Thank you
This e-mail (including any attachments) is confidential and may be legally
privileged. If you are not an intended recipient or an authorized
representative of an intended recipient, you are prohibited from using, copying
or distributing the information in this e-mail or its attachments. If you have
received this e-mail in error, please notify the sender immediately by return
e-mail and delete all copies of this message and any attachments.
Thank you.
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] Greetings & request for help, Yudi Darmadi
- [ADSM-L] Antwort: [ADSM-L] Greetings & request for help, Ullrich Mänz
- Re: [ADSM-L] Greetings & request for help, Yudi Darmadi
- [ADSM-L] AW: [ADSM-L] Greetings & request for help, Bethke, Ralph
- Re: [ADSM-L] AW: [ADSM-L] Greetings & request for help, Yudi Darmadi
- [ADSM-L] AW: [ADSM-L] AW: [ADSM-L] Greetings & request for help, Bethke, Ralph
- Re: [ADSM-L] AW: [ADSM-L] AW: [ADSM-L] Greetings & request for help, Andrew Raibeck
- Re: [ADSM-L] AW: [ADSM-L] AW: [ADSM-L] Greetings & request for help, Yudi Darmadi
- [ADSM-L] Request for some TSM queries to use, Larry Clark
- Re: [ADSM-L] Request for some TSM queries to use,
Huebner,Andy,FORT WORTH,IT <=
- Re: [ADSM-L] Request for some TSM queries to use, Larry Clark
- Re: [ADSM-L] Request for some TSM queries to use, Bob Levad
- Re: [ADSM-L] Request for some TSM queries to use, Bob Levad
- [ADSM-L] TDP for Oracle - multi channel restore, Richard Rhodes
- Re: [ADSM-L] TDP for Oracle - multi channel restore, goc
- Re: [ADSM-L] TDP for Oracle - multi channel restore, Richard Rhodes
- Re: [ADSM-L] TDP for Oracle - multi channel restore, Mark Scott
- [ADSM-L] TSM 6 announcement date?, Remco Post
- Re: [ADSM-L] TDP for Oracle - multi channel restore, Richard Sims
- Re: [ADSM-L] TDP for Oracle - multi channel restore, Oscar Kolsteren
|
|
|