ADSM-L

Re: Verifying Tape Contents

2001-08-16 09:00:02
Subject: Re: Verifying Tape Contents
From: Maurice van 't Loo <maurice AT COMPARE.MYWEB DOT NL>
Date: Thu, 16 Aug 2001 15:01:02 +0200
John,

You could use a sql select statement on the table contents, jl. if tapename is 
tape001:
select distinct node_name from contents where (volume_name like "tape001")
This shows you all of the nodenames that haves data on the tape.

Or if you like a long, long, LONG coffeebreak:
select * from contents
:-) give you every file on every tape with a lot of detail

The columns of the table contents are:
volume_name, node_name, type, filespace_name, file_name, aggregated, file_size, 
segment and cached

A list of all the tables:
select * from tables

You can use the sql select statements on the tsm command line (also in the 
admin web client) and in scripts, you can find with this statements everything 
you want.

Good Luck,
   Maurice
   The Netherlands



<Prev in Thread] Current Thread [Next in Thread>