Danieleinfn
Technical User
Hi all,
when I backup or archive a file in a pool, how I can know in wich tape my file is store?
TNX
D.
when I backup or archive a file in a pool, how I can know in wich tape my file is store?
TNX
D.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
File-->tape association
- Thread starter Danieleinfn
- Start date
- Status
ProbablyDown
MIS
Not sure why you would need to know what tape the actual file is on.. Let TSM worry about that ;-)
BUT you could see what volume data for a particular node is on by looking at the volumeusage table.
To find all the tables you can run a "select tabname from tables" and note the table name (in this case VOLUMEUSAGE)
Then to find the columns in that table you can:
select colname from columns where tabname='VOLUMEUSAGE'
From there you can say "select NODE_NAME, VOLUME_NAME from volumeusage where node_name='MYNODE'" or whatever the node name is...
BUT you could see what volume data for a particular node is on by looking at the volumeusage table.
To find all the tables you can run a "select tabname from tables" and note the table name (in this case VOLUMEUSAGE)
Then to find the columns in that table you can:
select colname from columns where tabname='VOLUMEUSAGE'
From there you can say "select NODE_NAME, VOLUME_NAME from volumeusage where node_name='MYNODE'" or whatever the node name is...
- Status
Similar threads
- Question