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

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:
    52
    Likes Received:
    1
    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:
    106
    Likes Received:
    5
    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