471,887 Members | 1,513 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,887 software developers and data experts.

Slow connects to database

DB2 7.2 EEE
AIX 5.2
Instance is partitioned over two servers.

Server A - Catalog node & 4 data node
Server B - 4 data node

Local and remote connection times to the only database on this instance
is recently taking around 65 seconds. Sometimes the connects are
normal. Once connected the performance seems to be normal.

* Its not just the first connection which is taking a long time.
Connects are slow even after explicitly activating the db.

* We are using circular logging

* Authentication is done locally (No NIS or anything special)

* i/o waits are mostly bellow 10%, but sometimes above 80%. Other OS
level stats like CPU, memory etc look ok.

* Re-booting the servers didn't help. (They had an uptime of 352 days)

* No hints in db2diag.log even when increased to 4.

* There are no changes been done to this db recently. No change in
db/dbm or BP.

Any hint on what could be the culprit here.

Thanks a lot

Nov 12 '05 #1
0 1206

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Stuart Mueller | last post: by
reply views Thread by NuB | last post: by
46 posts views Thread by dunleav1 | last post: by
8 posts views Thread by php-taz | last post: by
3 posts views Thread by jku | last post: by
reply views Thread by Demetris | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.