Is this when everyone starts up the connections to the database via the WAS
connection pool ?
Is the database always being used? or do all the connections go away after
days end?

Find out what "slow" means. Is it the first connect ? or some other thing
they are doing and track it down from there.






"Avudaiappan
Jeyapaul"
<[Email address protected] To
v.za> <[Email address protected]
cc
01/25/2006 02:28 DANIEL CALLAHAN/Bedford/[Email Address Removed]
AM Subject
Memory -DB2










Hello Everyone,

Good Morning.

We are running an application in SuSe Linux 9.0 , IBM WAS 6.0 and IBM DB2
UDB 8.2. It is an intranet application.

Every day morning around 9:00 to 9:00 AM I am getting a complaint from all
the users that system is very slow.
I have checked the System memory using free -m command and it is
comfortable and I can see some of the db2 services is
taking more memory , I can see that in TOP command .

OUTPUT OF THE TOP:

PID - User - PR -NI - VIRT- RES - SHR-S-%CPU-- %MEM
--Command
25807 - db2inst1 - 16 - 0 -696m- 240m-55m-S- 85 --12 * db2sysc

Can anyone please let me know wot is the respective process for the PID. Is
there any tools or commands to find out the application pertaining to the
PID. So that it will be easy for me to tune the application / Stored
Procedure.



Thanks and Regards
Avu




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