Check the queries is it properly indexed or not if not then
update the statistics by using(reorg and runstat command)
also if indexes are not used properly by the db then increates
SORTHEAP size[db parameter].

Try to mointor your Bufferpool,and if nedded create new one
What my knowledege is saying we need at least 50 to 60 %
of memmory free for db server.

use this command
db2 get snapshot for bufferpools on <db name>.
Tre to understand the page reds of table and indexes.
It will be helpfull in determining your bufferpool status.
Most important check the hard disk space[df -h command] of
your db server it should be at least 60 % free.

Further you can find better tips on net.


-----
Ajitesh Kr. Singh
Database Administrator
Contact : 09886187186
Davlin Software Pvt. Ltd.
II Floor, Punja Building,
M.G.Road,Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5 Extn : 27



DISCLAIMER: This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended
recipient you should not disseminate,distribute,store,print, copy or
deliver this message.Please notify the sender immediately by e-mail if
you have received this e-mail by mistake and delete this e-mail from
your system.

DB2 & UDB email list listserv db2-l LazyDBA home page