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

Sumanth wrote:
> 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
>
>
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

You may use this article to start tuning your database application that
loads data
http://www-128.ibm.com/developerwork...ins/index.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