1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

Management Classes

Discussion in 'Scripting' started by Andrew21210, Dec 6, 2017 at 1:46 PM.

  1. Andrew21210

    Andrew21210 ADSM.ORG Member

    Joined:
    Apr 10, 2008
    Messages:
    88
    Likes Received:
    1
    I've been asked to produce a breakdown of what filespaces are being backed up under what management classes on a node by node basis. This is a small TSM server with 62 nodes on it and it's also old and EOS (5.5.6.0 MVS). Is there a sql select or series of selects that I can use to pull this information?
     
  2.  
  3. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,641
    Likes Received:
    372
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    You can try:
    select distinct node_name,filespace_name,class_name from backups order by node_name,filespace_name,class_name

    Keep in mind that objects are bound to management classes, not filespaces. So if you have objects bound to different management classes in a same filespace, that filespace will come out more than once in the output.
     
  4. Andrew21210

    Andrew21210 ADSM.ORG Member

    Joined:
    Apr 10, 2008
    Messages:
    88
    Likes Received:
    1

    Thanks marclant. I think that will bring the servers to its knees. I'm willing to run the select against each node one by one since there aren't that many. How would I modify the select to do that?
     
  5. Andrew21210

    Andrew21210 ADSM.ORG Member

    Joined:
    Apr 10, 2008
    Messages:
    88
    Likes Received:
    1
    EDIT: I forgot to add that they are looking to get amounts of data per file space per management class! Is that even possible?
     
  6. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,641
    Likes Received:
    372
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    It's not an intense query. It's not doing any counts or math. With "distinct", after it found one iteration, it jumps to the next.
     
  7. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,641
    Likes Received:
    372
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    That will bring your server to it's knees. I don't know the syntax, but you'd need to join the occupancy and the backups table as the management class is in the backups table and the size in the occupancy table.
     
  8. Andrew21210

    Andrew21210 ADSM.ORG Member

    Joined:
    Apr 10, 2008
    Messages:
    88
    Likes Received:
    1
    I can just ballpark it with a "q occ" for each node. At least I can get occupancy for the file space.
     

Share This Page