Aix high cpu activity


 
Thread Tools Search this Thread
Operating Systems AIX Aix high cpu activity
# 1  
Old 07-04-2008
Aix high cpu activity

Hello everyone

I have this process running on my server.

topas command

User 98.6 |############################

I have this process

Name PID CPU% PgSp Owner
db2fm 565264 25.6 1.5 ldapdb2
db2fm 348328 23.6 1.5 idsldap
db2fm 491706 20.5 1.5 idsldap
db2fm 594162 16.4 1.5 ldapdb2

My question is What can I check to see what's causing this high CPU activity.

This server always on almost 100% cpu use.

The database process is taking all the cpu. which command i neeed to see if I have more than one database.

or if I can see that there is a zombie process. I want to fix it the high cpu activity but dont mess up.


Thanks for your tips
# 2  
Old 07-07-2008
Quote:
I have this process

Name PID CPU% PgSp Owner
db2fm 565264 25.6 1.5 ldapdb2
db2fm 348328 23.6 1.5 idsldap
db2fm 491706 20.5 1.5 idsldap
db2fm 594162 16.4 1.5 ldapdb2

My question is What can I check to see what's causing this high CPU activity.
You already gave yourself the answer. I am sorry to say, but since you don't know how to check which DBs are running on that system, I doubt you can find any performance problems inside DB2 that easy.

To see which DBs are there, connect to the instance and do a
Code:
list db directory

Since those processes you listed have "ldap" in their names, it would make things easier, if you explain what this DB is used for and what those users are doing.
But I guess it goes more into DB2/LDAP than into AIX itself. Else you might post some rows of vmstat, iostat and vmstat -v while these problems occure.
# 3  
Old 07-10-2008
It's your LDAP DB2 instance is using so much.. thats kind of strange... hw many DB instances you have? You can use:

Code:
$DB2_INSTALL_DIR/instance/db2ilist

to find the instances..

How many db2 agents running?
# 4  
Old 07-10-2008
This process is not a instance process. That looks like the db2fm command and is used to configure the DB2 fault monitor.

can you paste in (please use the code tags for the output)


Code:
ps -u idsldap -f
ps -u ldapdb2 -f

# 5  
Old 07-11-2008
I had this problem before, I remember. And yes, this is the way you fix it basically...

Fault Monitor processes is not required in normal cases. you can disable fm as the method specified in this page:

IBM - IY64683: DB2FM (FAULT MONITOR) RESPONSIBLE FOR HIGH CPU USAGE ON THE SYSTEM

What version db2 you care using? This is already a bug identified in version 8.1 FP6 and FP8. Give a try.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Red Hat

CPU is high

Hi , We found CPU is high due to python process .Is this something that Oracle team should look on or Unix team has to work on it ?Could you please advise use of python process ? top - 12:03:03 up 43 days, 15:11, 5 users, load average: 1.53, 1.33, 1.23 Tasks: 126 total, 3 running, 123... (12 Replies)
Discussion started by: Maddy123
12 Replies

2. Shell Programming and Scripting

what would a script include to find CPU's %system time high and user time high?

Hi , I am trying to :wall: my head while scripting ..I am really new to this stuff , never did it before :( . how to find cpu's system high time and user time high in a script?? thanks , help would be appreciated ! :) (9 Replies)
Discussion started by: sushwey
9 Replies

3. Red Hat

apache high cpu load on high traffic

i have a Intel Quad Core Xeon X3440 (4 x 2.53GHz, 8MB Cache, Hyper Threaded) with 16gig and 1tb harddrive with a 1gb port and my apache is causing my cpu to go up to 100% on all four cores heres my http.config <IfModule prefork.c> StartServers 10 MinSpareServers 10 MaxSpareServers 15... (4 Replies)
Discussion started by: awww
4 Replies

4. UNIX for Advanced & Expert Users

high cpu utilization

good morning. just wanted to ask if there's a way to check what causes the high cpu utilization of a server for the past 2 months? My jffnms report resulted to high utilization for a specific server last month. is there a way to check via a command line? thanks (9 Replies)
Discussion started by: lhareigh890
9 Replies

5. AIX

DB2 high CPU

Hello dear friends, I have Lpar AIX 6.1 and there is DB2 installed. I have 8 Virtual CPU's configured on my Lpar and when I run nmon the CPU waiting time is always big.. I will provide screenshot for better realizing.. my question is what may produce so big waiting time?? Thanks in advance! (19 Replies)
Discussion started by: Vit0_Corleone
19 Replies

6. UNIX for Dummies Questions & Answers

CPU Activity

One of my user always complains about the load on the server, he works in a different location & time zone. Is it possible to check the CPU activity during specific time/days? let us say for example, i want to check the load on the server at 9 pm to 10 PM on August 22th ? Not the current load.... (2 Replies)
Discussion started by: sydney2008
2 Replies

7. UNIX and Linux Applications

High CPU activity running Oracle

I'm running Oracle 10g on a V880 using Solaris 8 connected to a NetApps SAN and recently I've been getting cpu activity that normally is 2 -3 % now running from 14% ass a low up to 90% peak against oracle PIDs. No recent changes have been to Oracle or the OS. THere has been some firmware updates to... (4 Replies)
Discussion started by: stocksj
4 Replies

8. AIX

High CPU utilization

Hi am facing high cpu utilization on my sybase server. I have P550 Number Of Processors: 4 Processor Clock Speed: 1656 MHz CPU Type: 64-bit Kernel Type: 32-bit LPAR Info: 1 65-D837E Memory Size: 7840 MB in topas it shows Name PID CPU% PgSp Owner dataserv 565264 ... (1 Reply)
Discussion started by: vjm
1 Replies

9. Solaris

High CPU Utilization

Good morning, I need some help figuring out what's eating up my cpu. My application can't get enough cpu to do its job. this is a sunfire V440 2CPU's at 1/593 GHZ with 8GB of memory. In the morning hours the box is at less than 3%. I can't figure out what else is using the CPU. We use foglight and... (2 Replies)
Discussion started by: bbouhaik
2 Replies
Login or Register to Ask a Question