Re: TSM Query to determine what is on a single tape
I use this to count files by client per tape:
select volume_name,node_name,count(file_name)
as #files from contents where
volume_name=upper('$1') group by
volume_name,node_name
This lists client's files on a given tape:
select node_name,file_name as "File Name
" from contents where
node_name=upper('$1') and
volume_name=upper('$2')
Shouldn't be too hard to add filespace on either one.
At 11:23 AM 10/6/2003 -0700, you wrote:
Given a tape, is there a select query that will tell me what servers have
data on that particular tape? It'd be nice to know what file systems as well
but that level of granularity isn't necessary. I.e. I have tape XYZ, I run
query and find out CLIENTA, CLIENTB, and CLIENTC have data on it.
Gerald Wichmann
Manager, Systems Engineering
ZANTAZ, Inc.
925.598.3099 (w)
This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm)
service. For more information, visit us at www.zantaz.com.
IMPORTANT: This electronic mail message is intended only for the use of the
individual or entity to which it is addressed and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law. If the reader of this message is not the intended recipient, or the
employee or agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If you have received
this communication in error, please notify the sender immediately by
telephone or directly reply to the original message(s) sent. Thank you.
Re: TSM Query to determine what is on a single tape
tsm: TSMSERVER>select colname, index_keyseq from syscat.columns where tabname='CONTENTS' COLNAMEINDEX_KEYSEQ -- VOLUME_NAME 1 NODE_NAME TYPE FILESPACE_NAME FILE_NAME AGGREGATED FILE_SIZE SEGMENT CACHED FILESPACE_ID FILESPACE_HEXNAME FILE_HEXNAME tsm: TSMSERVER>select distinct(node_name) from contents where volume_name='123456' tsm: TSMSERVER>select node_name, filespace_name from contents where volume_name='123456' group by node_name, filespace_name Alex Paschal Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Gerald Wichmann [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:24 AM To: [EMAIL PROTECTED] Subject: TSM Query to determine what is on a single tape Given a tape, is there a select query that will tell me what servers have data on that particular tape? It'd be nice to know what file systems as well but that level of granularity isn't necessary. I.e. I have tape XYZ, I run query and find out CLIENTA, CLIENTB, and CLIENTC have data on it. Gerald Wichmann Manager, Systems Engineering ZANTAZ, Inc. 925.598.3099 (w) This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm) service. For more information, visit us at www.zantaz.com. IMPORTANT: This electronic mail message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by telephone or directly reply to the original message(s) sent. Thank you.
TSM Query to determine what is on a single tape
Given a tape, is there a select query that will tell me what servers have data on that particular tape? It'd be nice to know what file systems as well but that level of granularity isn't necessary. I.e. I have tape XYZ, I run query and find out CLIENTA, CLIENTB, and CLIENTC have data on it. Gerald Wichmann Manager, Systems Engineering ZANTAZ, Inc. 925.598.3099 (w) This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm) service. For more information, visit us at www.zantaz.com. IMPORTANT: This electronic mail message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by telephone or directly reply to the original message(s) sent. Thank you.
