• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

How to find tape with a certain file

davas

Newcomer
Joined
Nov 18, 2015
Messages
4
Reaction score
0
Points
0
Good afternoon, please tell me what command you can use to see which tape contains a certain file, for example doc.txt ?
 

Sunhillow

ADSM.ORG Senior Member
Joined
Oct 27, 2003
Messages
404
Reaction score
16
Points
0
Location
Stuttgart, Germany
Hello,
recently I needed a similar command to list all files from one tape. I modified it a bit, so it should do what you are looking for:
select volume_name, filespace_name, file_name, CAST((FILE_SIZE/1024/1024) As DECIMAL(7,2)) AS SIZE_MB, object_id, segment from contents where file_name = '$filename'

But be aware that CONTENTS may be a huge table!
The "segment" is important in case the file is spanned over two tapes
 

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 22 19.5%
  • Keep using TSM for Spectrum Protect.

    Votes: 67 59.3%
  • Let's be formal and just say Spectrum Protect

    Votes: 15 13.3%
  • Other (please comement)

    Votes: 9 8.0%

Forum statistics

Threads
31,839
Messages
134,906
Members
21,810
Latest member
BackupPlan
Top