| Author |
Message
|
| mq_crazy |
 Posted: Tue Sep 30, 2008 8:49 am Post subject: Checking Number of connections to the database |
 |
|
Master
Joined: 30 Jun 2004
Posts: 295
|
Hi Guys,
Is there any command in Broker to check the number of connections open to the database?? Also what is the procedure to make sure the connection is good from database side before creating the broker, if the database is on the remote server?? |
|
| Back to top |
|
 |
| adhuri |
| Posted: Tue Sep 30, 2008 11:41 am Post subject: Check with your database tools supplied with product |
|
|
Newbie
Joined: 29 Sep 2008
Posts: 3
|
Listing database connections that the broker holds
The broker does not have any functionality to list the connections it has to a database, instead use the facilities that your database supplies to list connections. Refer to the documentation for your database to find out about these.
Related concepts
User database connections
Related tasks
Creating a DB2 database on Windows
Creating a DB2 database on Linux and UNIX systems
Changing the Database Heap Size on DB2 broker databases
Enabling connections to the databases
Authorizing access to the databases
Related reference
Supported databases
Quiescing a database
WebSphere MQ connections |
|
| Back to top |
|
|
| Tibor |
| Posted: Wed Oct 01, 2008 12:47 am Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
mq_crazy: what kind of database? btw, you can check the numbers of network connections between the appserver and dbserver, only the port number is database dependent.
HTH,
Tibor |
|
| Back to top |
|
|
| mq_crazy |
| Posted: Wed Oct 01, 2008 6:32 pm Post subject: |
|
|
Master
Joined: 30 Jun 2004
Posts: 295
|
|
| Back to top |
|
|
| Tibor |
| Posted: Thu Oct 02, 2008 2:31 am Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
Testing the Oracle client connection:
where dbname is same as the ServerName is the odbc.ini
Querying all sessions (from sqlplus):
| Code: |
select pid,spid, osuser, s.program
from v$process p, v$session s
where p.addr=s.paddr; |
|
|
| Back to top |
|
|
| mq_crazy |
| Posted: Thu Oct 02, 2008 6:55 am Post subject: |
|
|
Master
Joined: 30 Jun 2004
Posts: 295
|
| Thanks Tibor for your response. |
|
| Back to top |
|
|
| mq_crazy |
| Posted: Thu Oct 02, 2008 11:07 am Post subject: |
|
|
Master
Joined: 30 Jun 2004
Posts: 295
|
| I was wondering if there was any linux command to check the number of connections to the database |
|
| Back to top |
|
|
|
|
