• 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.


    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 do I know which tapes have been written to most often/least?


We are working on implementing a new policy of refreshing our tape pool with new ones, while destroying the oldest ones, but we'd like to base it the number of reads/writes. Any thoughts? Thanks every1!



ADSM.ORG Senior Member
you can use un select * from volumes and review the values there are

also you can move the data in tapes an another tapes and at this point you can destroy old tapes



ADSM.ORG Senior Member
Assuming that your volhistory is not purged periodically a record of every time a tape is added to or removed from an stgpool will be recorded. A query like this will give you the volume list in order of date used. These would be amongst your oldest used tapes.

select volume_name as "Volume ",date_time as "Date/Time " from volhistory where type='STGNEW' order by date_time

Volume Date/Time
------------------ -------------------------------
T01042 2006-02-28 13:01:03.000000
T01043 2006-02-28 13:01:07.000000
T01044 2006-02-28 16:00:56.000000

Similarly, you can query to determine the number of times a tape was added to a stgpool, and that could very loosely correlate to an approximation of how often it was used. This is not the same as the number of times it was mounted. it also does not include the number of times the tape may have been used for a DB backup, export, DBSnap etc.

select volume_name, count(*) from volhistory where type='STGNEW' group by volume_name order by 2 desc

VOLUME_NAME Unnamed[2]
------------------ -----------
T01050 38
T01801 37
T01088 34

Or you can simplify it even more to this to give a raw count of the number of times a tape is recorded in the volhistory table.

select volume_name, count(*) from volhistory group by volume_name order by 2 desc

Of course you would then need to determine which of these tapes are empty so they can be ejected and replaced with tapes using a different volser.


I have a similar request, however is there a way to query Tape Media in Tapepool and order by Date Last Writen or Date Last read and easily view those dates?


ADSM.ORG Moderator
I have a similar request, however is there a way to query Tape Media in Tapepool and order by Date Last Writen or Date Last read and easily view those dates?
That post was 6 years old. Not sure those folks are still around. You'd be better off starting a new thread with your question an provide more details, I'm not 100% sure what you are asking.

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

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: 18 18.6%
  • Keep using TSM for Spectrum Protect.

    Votes: 59 60.8%
  • Let's be formal and just say Spectrum Protect

    Votes: 12 12.4%
  • Other (please comement)

    Votes: 8 8.2%

Forum statistics

Latest member