Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Query :: Using Netstat finding total value to a db connection
Top Forums UNIX for Dummies Questions & Answers Query :: Using Netstat finding total value to a db connection Post 302332733 by senthil.ak on Friday 10th of July 2009 02:55:36 AM
Old 07-10-2009
Lightbulb Query :: Using Netstat finding total value to a db connection
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.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Netstat command query

hy guys, I did netstat and it is listening, what can i do from the client side that to see if the port is open? Regards Charneet (1 Reply)
Discussion started by: charneet
1 Replies

2. Shell Programming and Scripting

Finding the total of a column using awk

Here is my file name countries USSR 8650 262 Asia Canada 3852 24 North America China 3692 866 Asia USA 3615 219 North America Brazil 3286 116 South America India 1269 637 Asia Argentina 1072 ... (8 Replies)
Discussion started by: ironhead3fan
8 Replies

3. Solaris

How to kill the TCP ESTABLISHED connection in netstat

Hello, Actually there are some bugs in application which does not close the TCP connection to other server though CORBA. We need to kill that ESTABLISHED connections as new connection are not happeneing as the allocated ports were used and showing as ESTABLISHED Is there any... (4 Replies)
Discussion started by: GIC1986
4 Replies

4. UNIX for Dummies Questions & Answers

TCP failed connection attempts from netstat -s

Dear experts, I am seeing a lot of TCP failed connection attempts from "netstat -s" on one of our servers. How can I pin point what connection failed and what are the ports involved? Any tools/commands I can dig in deeper to diag. what went wrong on these "failed connection attempts"? ... (2 Replies)
Discussion started by: cache51
2 Replies

5. Shell Programming and Scripting

Finding total Percentage CPU usage

Hi, How can I find total CPU usage in percentage? e.g. if my system has 8 CPUs and I want to list total usage for all of them, is it possible through a command? I have tried some of the commands like top, mpstat, sar. The output of those commands has to be manipulated to derive the percentage... (14 Replies)
Discussion started by: jal_capri
14 Replies

6. Shell Programming and Scripting

DB connection and query

Hi I'm trying to create a connection with DB from shell script using the following string sqlplus <user>@<db_instance>/<password> in which I'm successful. However, after connecting to DB it is giving me a sql prompt as follows ===================== Connected to: Oracle Database 10g... (2 Replies)
Discussion started by: sainisumit1
2 Replies

7. AIX

Finding Total Memory Of VIO Server.

Hi, I would like to know how to find Total Memory of Vio Server? I have used command prtconf | grep Memory , though this command is showing allocated memory of vio server. But I would like to find out Total Memory of VIO Server, Though this can be find out using browser http://<ip address... (9 Replies)
Discussion started by: manoj.solaris
9 Replies

8. UNIX for Advanced & Expert Users

Finding out total memory usage

Hi, I have a server box with 16GB ram in it, within the server box there are 3 VMs running with a total allocation of 9GB. if I add up all the numbers under memory info using vmstat I get 15.8GB so I can say it adds up to 16Gb... Is there a way to see from the command line how much memory... (2 Replies)
Discussion started by: speedhunt3r
2 Replies

9. Shell Programming and Scripting

Finding total count of a word.

i want to find the no:of occurrences of a word in a file cat 1.txt unix script unix script unix script unix script unix script unix script unix script unix script unix unix script unix script unix script now i want to find , how many times 'unix' was occurred please help me thanks... (6 Replies)
Discussion started by: mahesh1987
6 Replies

10. UNIX for Dummies Questions & Answers

Dig total query time?

I'm using a .txt file filled with domain names for dig to use, the problem is that when i look at the results I get the query time for each individual query, I want to know how long it took in total for all queries to run, how can I achieve this? any help would be greatly appreciated, thank you.... (3 Replies)
Discussion started by: r7a7v7
3 Replies

LEARN ABOUT SUNOS

asadmin-delete-jdbc-connection-pool

asadmin-delete-jdbc-connection-pool(1AS)			   User Commands			  asadmin-delete-jdbc-connection-pool(1AS)

NAME

       delete-jdbc-connection-pool  - removes the JDBC connection pool

SYNOPSIS

       delete-jdbc-connection-pool  --user  admin_user	[--password admin_password] [--host localhost] [--port 4848] [--secure|-s] [--passwordfile
       filename] [--terse=false] [--echo=false] [--interactive] [--cascade=false] connection_pool_ID

       Removes the JDBC connection pool. This command is supported in remote mode only.

OPTIONS

       --user		       authorized domain application server administrative username.

       --password	       password to administer the domain application server.

       --host		       machine name where the domain application server is running.

       --port		       port number of the domain application server listening for administration requests.

       --secure 	       if true, uses SSL/TLS to communicate with the domain application server.

       --passwordfile	       file containing the domain application server password.

       --terse		       indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
			       formatted data for consumption by a script.

       --echo		       setting to true will echo the command line statement on the standard output.

       --interactive	       prompts you for the required options that are not already specified.

       --cascade	       If set to true, deletes all the connector resources associated with the pool, apart from the pool itself. If set to
			       false (default), the deletion of the pool fails if there are any resources associated with  the	pool.  Either  the
			       resource has to be deleted explicitly, or set the option to true.

OPERANDS

       connection_pool_id      name of the JDBC connection pool to be deleted.

       Example 1: Using the delete-jdbc-connection-pool command

       asadmin> delete-jdbc-connection-pool --user admin
       --password adminadmin --host fuyako port 7070 XA_connection_pool
       Deleted the JDBC connection pool resource with id = XA_connection_pool

       Where: the XA_connection_pool resource is deleted.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-create-jdbc-connection-pool(1AS), asadmin-list-jdbc-connection-pools(1AS)

J2EE 1.4 SDK							    March 2004				  asadmin-delete-jdbc-connection-pool(1AS)
All times are GMT -4. The time now is 01:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy