Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Posts
    6

    Unanswered: Tracking open connections in db2

    Hi all

    I need a way to track open db connections to my db2 database through
    some mechanism.

    I tried using the Control center available with the db2 install but it shows lot of connections which apparently are not created.(Kind of confusing).Also it does not give the machine name or IP from where the connection is created.

    Is there a tool/command to track open connections with db2.

    Appreciate everyones help.

    Thanks
    -MM

  2. #2
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: Tracking open connections in db2

    You can use the command to

    get snapshot for all applications


    If an application is connected it will say so.

    Look under " Inbound communication address" for the ip address, you can searh on "Application status "
    with a status of excuting to find all the things connected and see what there doing.

  3. #3
    Join Date
    Sep 2003
    Posts
    6

    Re: Tracking open connections in db2

    Tried what you mentioned but got this.Any clues ?

    db2 => get snapshot for all applications
    SQL1611W No data was returned by Database System Monitor. SQLSTATE=00000

    -MM

    Originally posted by quigleyd
    You can use the command to

    get snapshot for all applications


    If an application is connected it will say so.

    Look under " Inbound communication address" for the ip address, you can searh on "Application status "
    with a status of excuting to find all the things connected and see what there doing.

  4. #4
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: Tracking open connections in db2

    Make sure your monintor switches are on.

    Buffer pool (DFT_MON_BUFPOOL) = ON
    Lock (DFT_MON_LOCK) = ON
    Sort (DFT_MON_SORT) = ON
    Statement (DFT_MON_STMT) = ON
    Table (DFT_MON_TABLE) = ON
    Unit of work (DFT_MON_UOW) = ON


    According to IBM leaving them on won't hurt performace. Plus it will make your job easier.

    And also make sure you mon_haep_sz has some memory allocated to it, usually 256 is good enough

  5. #5
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: Tracking open connections in db2

    test this commad:
    list application <show detail>

    Abel.

  6. #6
    Join Date
    Dec 2002
    Posts
    134

    Re: Tracking open connections in db2

    To get appl with ip (If your clients are using tcp/ip to comunicate)

    1. "list applications", for every application - get snapshot for aplication agentid <id> and check for "Inbound communication address "parameter

    2. Use my db2 monitor
    http://chuzhoi_files.tripod.com

    regards,
    dmitri

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •