How to Determine the Number of JDBC Connections from the Sterling B2B Integrator (B2Bi) Noapp Process

Body

The following steps can be used for any of the B2Bi processes. For example the noapp, ops, bilisten, activemq, extpurge. Not all processes have children pids and only the noapp process can be monitored within the B2Bi application.

Unix/Linux installs:

1) cat the noapp.pid in the root directory of the Sterling B2B Integrator install.

2) grep the noapp pid and determine the child pid for the noapp pid.

ps -ef | grep "noapp pid"

3) Determine the database port. The sandbox.cfg in the <SI_Install>/properties directory will have the following parameter.

DB_PORT=

4) Now that you have the child pid for the noapp pid and have determined the DB_PORT you can use this information to run a netstat command. The netstat will provide the number (count) of jdbc connections coming from the noapp pid on the DB_PORT.

Linux:

netstat -anop | grep "DB_PORT" | grep "child pid" | wc -l 

For aix:  

lsof -i :1521 | grep noapp child pid | wc -l

Windows example:

Determine the noapp pid using the Windows Task Manager. Under the Details tab of Windows Task Manager Find the noapp.exe and the pid will be listed next to it.

netstat -ano | find "1521" | find "noapp pid" /c 

5) Compare this count to a jdbc report or a DB Usage screenshot and add up all the pool size numbers. These numbers should be equal or very close.

Operations > System > Troubleshooter > DBUsage

Add up the "Size=" for each pool. In my example above the pool counts = 13 which matches my count from the netstat command in the Linux netstat count example above.

You can also go to Operations > System > JDBC Monitor > View JDBC Report and add up the <SIZE>1</SIZE> node for each pool on the default DB.

6) In my example above the pool counts in B2Bi matched the counts from the netstat. This is what would be expected. The counts should be equal or very close.

However if you have a discrepancy between the counts then something might be closing connections prematurely and will need to be investigated further.