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

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.

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

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

test this commad:
list application <show detail>

Abel.

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