Topic
3 replies Latest Post - ‏2013-06-20T17:12:02Z by LukeNumrych
mortenb
mortenb
49 Posts
ACCEPTED ANSWER

Pinned topic Monitor number of connections

‏2013-06-18T08:54:28Z |

Hi all

I only have access to a db2 client. but I like to know how many active connections I have to the database and their memory footprint.

Is it possible to get this info from the cli:

 

oracle have v$session and v$process which you can easily monitor if you have installed the dba views and have access.

mysql has show process_list etc.

 

  • LukeNumrych
    LukeNumrych
    55 Posts
    ACCEPTED ANSWER

    Re: Monitor number of connections

    ‏2013-06-18T15:03:11Z  in response to mortenb

    You did not indicate which version of DB2 LUW are you using, but if you are on 9.7 or newer, check out the following:

    MON_GET_CONNECTION

    and 

    MON_GET_CONNECTION_DETAILS

    Is this what you are looking for?

    • mortenb
      mortenb
      49 Posts
      ACCEPTED ANSWER

      Re: Monitor number of connections

      ‏2013-06-20T09:58:04Z  in response to LukeNumrych

      Thanks Luke

      I didn't know This looks exactly what I need.

      unfortunately our big databases are still on 9.5 but I've been using 9.7 and 10.1 in test for a long time.

       

      • LukeNumrych
        LukeNumrych
        55 Posts
        ACCEPTED ANSWER

        Re: Monitor number of connections

        ‏2013-06-20T17:12:02Z  in response to mortenb

        You are welcome.  For 9.5, it seems it is not as straightforward to find what you are looking for, but see if the APPLICATIONS administrative view will provide some of it.  This information, combined with the other Administrative SQL routines and views may give you what you need...  It may have to be pieced together from several views and/or function calls.

        If you like my answer, make your thread as "answered" ;)