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
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.
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)
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)
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)
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)
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)
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)
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)
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)
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
create-connector-connection-pool
asadmin-create-connector-connection-pool(1AS) User Commands asadmin-create-connector-connection-pool(1AS)NAME
asadmin-create-connector-connection-pool, create-connector-connection-pool - adds a connection pool with the specified connection pool name
SYNOPSIS
create-connector-connection-pool --user admin_user [--password admin_password] [--host localhost] [--port 4848] [--secure|-s] [--password-
file filename] [--terse=false] [--echo=false] [--interactive=true] [--steadypoolsize 8] [--maxpoolsize 32] [--maxwaittime 3000] [--poolre-
size 2] [--idletimeout 300] [--failallconnections=false]--raname resource_adapter_name --connectiondefinition connection-definition_name
[--property name=value[:name=value]*] pool_name
Adds a new connector connection pool. Before you can add a new connector connection pool, you must first deploy the associated RAR file.
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. Default is false.
--echo setting to true will echo the command line statement on the standard output. Default is false.
--interactive if set to true (default), only the required password options are prompted.
--steadypoolsize minimum and initial number of connections maintained in the pool (default is 8).
--maxpoolsize maximum number of connections that can be created to satisfy client requests (default is 32).
--maxwaittime amount of time, in milliseconds, that a caller will have to wait before a connection is created if a connection is
not available. If set to 0 the caller is blocked indefinately until a resource is available or an error occurs
(default is 60000).
--poolresize the number of connections to be removed when idletimeout timer expires. Connections that have idled for longer than
the timeout are candidates for removal. When the pool size reaches the steadypoolsize, the connection removal
stops.
--idletimeout the maximum time that a connection can remain idle in the pool. After this amount of time, the pool can close this
connection (default is 300).
--failallconnections if true, closes all connections in the pool if a single validation check fails. This parameter is mandatory only if
the is-connection-validation-required is set to true. Legal values are: on, off, yes, no, 1, 0, true or false
(default is false).
--raname module name of the deployed resource adapter. In case of a resource adapter that is embedded in an application, the
raname will be appname#raname.
--connectiondefinition identifies one of the connection definitions in the deployment descriptor of a resource adapter. Value of connec-
tionfactory-interface sub-element in the connection-definition element.
--property name/value pair of the configuration properties of the managedconnectionfactory-class of the connectiondefinition
for which the pool is being created. The UserName and Password are accepted by default for all pools. The escape
character "
OPERANDS
pool_name name of the connection pool to be created.
Example 1: Using create-connector-connection-pool
The JMS resource adapter that is prepackaged with the application server is used for this example. Before you can add a new connector con-
nection pool, you must first deploy the associated RAR file.
To deploy the RAR file:
asadmin> deploy --user admin --password adminadmin jmsra.rar
Command deploy executed successfully
asadmin> create-connector-connection-pool --user admin1
--password adminadmin1 --steadypoolsize 20 --maxpoolsize 100 --poolresize 2
--maxwait 60000 --raname jmsra --connectiondefinition javax.jms.QueueConnectionFactory
--property UserName=guest:Password=guest jms/qConnPool
Command create-connector-connection-pool executed successfully
EXIT STATUS
0 command executed successfully
1 error in executing the command
asadmin-deploy(1AS), asadmin-delete-connector-connection-pool(1AS), asadmin-list-connector-connection-pools(1AS)J2EE 1.4 SDK March 2004 asadmin-create-connector-connection-pool(1AS)