Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB2 UDB Connection Overhead

Status
Not open for further replies.

LarryR

Technical User
Jun 12, 2001
3
US
We are running DB2 UDB for AIX V7.1. The tables in our Operational Data Store are updated with IBM's DpropR. We have about 30 subscriptions that process every 5 minutes. I've noticed that the monitor output shows about 150,000 connects per week. I'm assuming most of the connects are from DpropR. We do ACTIVATE the data base to reduce connection time.

I'm assuming that there is some overhead associated with each connection. Does anyone have a method of determining the costs of all these connects?

Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top