RE: Memory -DB2

I'd find out what is happening at that time frame - Examples:

* Someone is running a batch job that is poorly tuned and using
an abnormal amount of resources

* Lots of people are signing on to the system and the login
procedure is resource intensive

I'd capture the SQL that is being run when the problem occurs (start the
capture before the problem begins) and see what is being executed.

Douglas Kostelnik

Senior Database Administrator/Architect

[Email address protected]

AAA Auto Club South

(813)-289-1342

-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x75722966.[Email address protected]
Sent: Wednesday, January 25, 2006 8:25 AM
To: LazyDBA Discussion
Subject: Re: Memory -DB2

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

---------------------------------------------------------------------

PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE

website: http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html

<html>
 <align=justify> 
_____________________________________________________________ 
The information transmitted is intended only for the person(s) or entity to which it is addressed and may contain confidential and or privileged material and should be treated as a confidential AAA Auto Club South communication. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
</html>

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