Re: Request for some TSM queries to use
Drop the "not" and it will work fine. You might want to order by node_name. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Larry Clark Sent: Wednesday, January 07, 2009 5:57 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Request for some TSM queries to use How About this? Would it provide a list of volumes used by each node is a storage pool?: select distinct volume_name,node_name,stgpool_name from volumeusage where not stgpool_name='' This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Request for some TSM queries to use
How About this? Would it provide a list of volumes used by each node is a storage pool?: select distinct volume_name,node_name,stgpool_name from volumeusage where not stgpool_name=''
Re: Request for some TSM queries to use
Larry, Your query works fine if you switch the double quotes to single quotes. This query will tell you where every node resides. select distinct vu.stgpool_name, - vu.node_name, - vu.volume_name, - v.pct_utilized - from volumeusage vu, - volumes v - where v.volume_name=vu.volume_name - order by vu.stgpool_name, - vu.node_name, - v.pct_utilized As multiple nodes can and probably do exist on each tape, this can be a very long list unless further qualified. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Larry Clark Sent: Wednesday, January 07, 2009 3:16 PM To: ADSM-L@VM.MARIST.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 electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Request for some TSM queries to use
You need to change the " to ' Other than that it works fine. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Larry Clark Sent: Wednesday, January 07, 2009 3:16 PM To: ADSM-L@VM.MARIST.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.
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
