Data Protection Software

Expand all | Collapse all

Query to get the current backup session

  • 1.  Query to get the current backup session

    Posted Wed December 26, 2018 11:54 AM
    Hi All,

    can we get the information of current/real time session for a specific node has backed up how  much data from select query.

    ------------------------------
    Prem Singh

    ------------------------------


  • 2.  RE: Query to get the current backup session

    Posted Thu December 27, 2018 02:07 AM
    Hi,

    select * from sessions


    ------------------------------
    Håkon Phillip Tønder-Keul
    ------------------------------



  • 3.  RE: Query to get the current backup session

    Posted Thu December 27, 2018 02:48 AM
    This select will produce result of all current ongoing sessions, I believe I am looking for a specific session or specific node for current ongoing session.

    Thanks & regards
    Prem Singh Bathyal
    Mobile - 8527337214





  • 4.  RE: Query to get the current backup session

    Posted Thu December 27, 2018 04:43 AM
    Hi

    This is what I use, you can modify to fit with what you need:

     select NODE_NAME,COPY_TYPE,VOLUME_NAME from volumeusage where NODE_NAME='YOUR-Reg-Node-Name' and STGPOOL_NAME='StG-Pool-Name'

    Now you can modify this command adding removing etc... full details of select commands and examples are in 
    https://www.ibm.com/support/knowledgecenter/SSGSG7_7.1.7/srv.reference/r_cmd_select.html

    Please let me know if you need further information

    Regards

    Mark
      


    ------------------------------
    Morhaf Al-Bizri
    IT Solution Consultant
    MBteck
    Bury
    +44 (0) 7500 820198
    ------------------------------



  • 5.  RE: Query to get the current backup session

    Posted Thu December 27, 2018 04:52 AM
    Thanks I will check and let you know accordingly

    Thanks & regards
    Prem Singh Bathyal
    Mobile - 8527337214