in one box is it necessary we have db2 client and db2 server ?

M_RAS · #1 (**permalink**) 01-26-06, 10:10

I am working with db2 v8.2.2 (FP10) aix 5.2

in point of performance view is it better we have just db2 server in one box?

Marcus_A · #2 (**permalink**) 01-26-06, 10:54

If your client is on the same box as the server, you will cut down on network time for SQL requests, which can be signigicant in some situations. But the application (client) will use CPU and memory on the server, that would otherwise be available to the DB2 engine (server). So it depends on your specific application.

M_RAS · #3 (**permalink**) 01-26-06, 11:19

Quote:

Originally Posted by Marcus_A

If your client is on the same box as the server, you will cut down on network time for SQL requests, which can be signigicant in some situations. But the application (client) will use CPU and memory on the server, that would otherwise be available to the DB2 engine (server). So it depends on your specific application.

Thank you Marcus for your reply,
sorry I take your time, one more question , does FP9 prerequisites for FP10?

Marcus_A · #4 (**permalink**) 01-26-06, 11:34

No, FP10 can be applied to the base 8.1 (no fixpack) or any higher fixpack.

FP11 will be available any day now. If you are still in development, I would recommend FP11.

Internet Services

Web Development

Digital Marketing

Consumer Tech