UNIX for Dummies Questions & Answers

I wrote a very simple script to calculate the DB connection from an appserver and check the total netstat connection to a particular DB exceed 25 then it will send mail

Code:

netstat -a 2> /dev/null | awk '/[pP][dD][pP][dD].*ESTAB/{print $5}' | cut -d. -f1 | uniq -c | awk '{if ($1 > 25)print $2," exceed ",$1;}'

Now the problem for me started when there is one more application deployed in the same server and connecting to the same DB. Now the total netstat connection value is total of the two server DB connection, so i am unable to check respect to the application. Is there any way to find out DB connection using any other command in unix per application.
Note: Here the two application servers connect to the DB with different user ID and these application servers use connection pool for connecting the DB.
Do i need to check from the application or any script will give me a solution.

I guess it is not that easy. I don't know what type of DBM you are using but in DB2 for example there was a command like "list applications" and by this I think it was possible to see how many connections for which DB or by what application was currently connected. Maybe you have a chance to look it up from the DB's side with this and trigger scripts etc.