1. 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.
  2. 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 get count open sesssion?

Discussion in 'TSM Reporting & Monitoring' started by TaSMania, May 3, 2017.

  1. TaSMania

    TaSMania ADSM.ORG Member

    Joined:
    Nov 17, 2015
    Messages:
    38
    Likes Received:
    0
    So I have ANR0429W with max session reached,
    Rather than count rows by rows, how could I get a count of open sessions( should be list of server taking backup).
     
  2.  
  3. Rigido

    Rigido ADSM.ORG Senior Member

    Joined:
    Apr 21, 2006
    Messages:
    103
    Likes Received:
    4
    Occupation:
    AIX, TSM and Storage specialist
    Location:
    Rome, Italy
    Hi TaSMania,
    do you know you can use SQL select statements to do query on TSM (now SP) database?
    From the admin command line you can try something like:
    Code:
    select count(*) from sessions where SESSION_TYPE='Node'
     

Share This Page