• 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 generate backup information for a filespace?

ldmwndletsm

ADSM.ORG Member
I would like to determine the total byte size for all backups for a given file space for the primary tape pool and then the same for the copy pool and compare to ensure they match. Also, I would like to see the tape volumes that the given file space has been backed up to (both primary and copy pool) as well as the number of bytes written to each tape for that specific file space.

Of course, I would not expect that the number of tapes, or the amount written to each, for that file space, would be the same between those two storage pools, but I would still like to review it.

Anyway, how can I wrest this information from the TSM database?
 

merouan

ADSM.ORG Member
hi, here is the query , it can take long response


select occ.NODE_NAME,occ.stgpool_name,occ.filespace_name,SUM(occ.PHYSICAL_MB) from tsmdb1.occupancy occ inner join tsmdb1.contents cc on cc.filespace_name=occ.filespace_name and occ.node_name='xxxx' group by occ.NODE_NAME,occ.stgpool_name,occ.filespace_name
;
 

ldmwndletsm

ADSM.ORG Member
Thanks. The QUERY OCCUPANCY command achieves much of what I was looking for as far as giving me some numbers and allowing me to compare the pools. That output is a good starting point for me. But for the corresponding tape volume information, I guess that's going to require some additional work, most likely SQL, I'm guessing [sigh ...].

Merouan, I'm rusty on my SQL. There are no column names with 'occ' in the tsmdb1.occupancy table, right? What is 'occ'? Is this creating a temporary table? And what about 'cc'? Could you kindly break down the syntax for me here on what this command is doing? Also, how can I specify the file space name to narrow down the search time?

Anyway, I tried to run the command as is, and it didn't complain, but it never finished. I finally had to cancel it. The value that I specified for 'xxxx' is a node without that much data or file spaces, so I was hoping that it would return results much faster.
 

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

    Votes: 60 61.2%
  • Let's be formal and just say Spectrum Protect

    Votes: 12 12.2%
  • Other (please comement)

    Votes: 8 8.2%

Forum statistics

Threads
31,716
Messages
135,196
Members
21,721
Latest member
abucci63
Top