Hi all,
Thanks for your valuable suggestion.

In my Scenario i need to do both read and update the database (not necessarily same record ).I am getting good read performance.But Update performance is very poor. I will try the thrashing parameter.
Thanks
Vallish

I am using db2 8.1 version in suse Linux ....

Hi All,

I am struggling because of the update performance of db2 . Is it possible to improve update performance using the bufferpool size of tablespace?? I read it in some document but they didn't say how to change or how to relate a tablespace with the perticular table.Also can we disable logging in db2 level.(not the NOT LOGGED INITIALLY!! any other tech) .

Also How to improve my db2 database update performance its...