This is not a specifc question to answer...
As a start , you have to find out if need optimization in your database
enviroment or not. Regardless of what your answer to this question is you
have to watch (monitor) what goes on in your system..
The basics you might consider is to review your SQL statements and try
to add effective indexes.
Increase the size of your bufferpool..
Monitor if you meet lock escalations.
Seperating your group of tables into other tablespaces.
Also in your fetch(read statements) try to read as Uncomitted Read that
is to avoid the pessimistic locks.
Additionally avoid modifying the configuration parameter all together.
It is more effective to appyl them one by one to see if you are on the
right track
I'd advise you to read the DB2 Administration Guide and Performance Tuning
Guide .. the books that you may find them in Prentice Hall Press and IBM's
RedBook..
Good luck!
Salih Sipahi
Veritabanı Yöneticisi
Hitit Güneşi
Hattusas
" " <db2udbdba-ezmlmshield-x69448615.[Email address protected]
28.04.2006 16:11
Kime
"LazyDBA Discussion" <[Email address protected]
Bilgi
Konu
What are DB/DBM Parameters need to be changed.........
Hi Guru's,
I'm new to DB2 DBA,What are the main database or Manager(DBM)
parameters to be changed when the concurrent users/applications are
connected to the Database by using GUI(Portals/Java/JSP).
In my application no of concurrent users 150 to 300.
Thanks & Regards,
RK
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page