throughput between application-db2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sumanth - 03 Jan 2006 20:27 GMT

How do we increase the throughput between an app server and the DB2 server.

I tried increasing the bufferpage size, and get throughput around 5.4
mb/sec. I compute throughput by calculating the total number of bytes
inserted/ total time taken.

I tried increasing the buffer pool page size to 32KB the maximum allowed .
and the mode is in non-blocking mode..any other params that i can tune?

Thanks,
Sumanth

Reply to this Message

Larry - 03 Jan 2006 21:25 GMT

> How do we increase the throughput between an app server and the DB2 server.
>
[quoted text clipped - 7 lines]
> Thanks,
> Sumanth

I'll leave it to others to comment, but I'm not sure that increasing
your BP page size to 32K is going to help ... I would think it depends
upon the row sizes that your application needs to access in your database.

Is your app server and your DB2 server on the same physical machine? Is
there a network between them? What is the network speed? Have you spoken
to your network support people about getting that segment tuned from a
network perspective?

Larry Edelstein

Reply to this Message

Eugene F - 03 Jan 2006 22:54 GMT

You may use this article to start tuning your database application that
loads data
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0403wilkins/ind
ex.html
But first, you would need to do diagnose where is the time spent:
whether in the application processing or in the database using
available DB2 application trace facilities (jdbc, odbc, cli) and/or DB2
monitors.

-Eugene

Reply to this Message