470,618 Members | 1,822 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,618 developers. It's quick & easy.

throughput between application-db2

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
Jan 3 '06 #1
2 1621
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
Jan 3 '06 #2
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

Jan 3 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by JP | last post: by
reply views Thread by Stephan Steiner | last post: by
1 post views Thread by Jerome Symons | last post: by
2 posts views Thread by Dave Griffin | last post: by
1 post views Thread by Macca | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.