Dear All,

I installed DB2 in two servers A and B, and linked a A's database XYZ
in B. However, it is pretty slow to access XYZ from B. From the command
window, "connect to XYZ" took quite a while to execute.

Is there any way to check where the bottleneck is, and how to fine
tune the performance?

Thanks.

Make sure that your databases are catalogued with the "authentication server" option (assuming that you are using type 2 connections).

If you don't have applications always connected, then issue the "activate db" command. Unless a database is activated, the first connection has to allocate a lot of memory each time (including all the buffer pools), and these are de-allocated when the last connnection disconnects. Using activate db eliminates that problem.

Just a question myself - how come the 'authentication sever' option is quicker?

I've noticed since going from DB2 8.1 FP7A to FP9A, I've had to recatalog all my databases from 'DBM config' to 'authentication server' to make the connection quicker.

Also - I've tried 'activate' a database to overcome users' complaints that connections are slow initially. However I find i have to reactivate every other day. Is there a permanent settting somewhere? eg some environment variable etc?

I don't exactly know why, and I don't particularly care.

Activate db should be permanent. But if someone issues a force application command, quiesce, db2stop, etc, then it may be need to be issued again.