DB2 high CPU


 
Thread Tools Search this Thread
Operating Systems AIX DB2 high CPU
# 15  
Old 08-18-2010
Quote:
Originally Posted by zaxxon
Code:
54484 client filesystem I/Os blocked with no fsbuf

zaxxon was of course correct to point this counter out, but i would like to explain it a bit more, for completeness:

This counter (and similar ones, like "paging space I/Os blocked with no psbuf", etc.) are collected from boot time. Therefore the value itself is not that interesting but its change over time is.

A high value which doesn't (or does hardly) change over time hints to a problem in the past which is not occurring right now. That doesn't necessarily mean that the problem is solved, just its symptom is not occurring. Always take the number one advice of performance monitoring/tuning to heart: a problem is not solved when its symptom cannot be observed, but only when the symptom doesn't occur any more and you understand why this is so!

If you have to trace this or a similar counter always take snapshots over some extended period (every hour, every day, ...) and compare. Notice how much the counter increases - that is: the order of magnitude of the increment. If the counter increases in the tens over a day everything is ok, if it increases in the hundreds over an hour you have to investigate, if the increment is even higher you have to act immediately.

I hope this helps.

bakunin
This User Gave Thanks to bakunin For This Post:
# 16  
Old 08-18-2010
yesterday and today I have often run the command: vmstat -v and the values are not changing to tell the truth.. here is the output
Code:
vmstat -v
              6291456 memory pages
              6091921 lruable pages
              1024402 free pages
                    3 memory pools
               407822 pinned pages
                 80.0 maxpin percentage
                  3.0 minperm percentage
                 90.0 maxperm percentage
                  2.9 numperm percentage
               182505 file pages
                  0.0 compressed percentage
                    0 compressed pages
                  2.9 numclient percentage
                 90.0 maxclient percentage
               182505 client pages
                    0 remote pageouts scheduled
                    0 pending disk I/Os blocked with no pbuf
                    0 paging space I/Os blocked with no psbuf
                 2484 filesystem I/Os blocked with no fsbuf
                  650 client filesystem I/Os blocked with no fsbuf
                    0 external pager filesystem I/Os blocked with no fsbuf
CDR / #

# 17  
Old 08-18-2010
Looks like a good sign. As bakunin said - just have a look on it maybe twice every week or have a script informing you every day in the morning as a report. Anyway it might be a good idea to split your storage for smoother performance.
# 18  
Old 08-18-2010
zaxxon yes and thanks again to you and to everybody who tried to help me :-) as soon as we make storage upgrade I will allocate DB2 containers to separate File Systems.. Let's than see what will happen :-)
# 19  
Old 08-19-2010
My comments:
Code:
vmstat –v | grep 'filesystem I/Os blocked with no fsbuf'

it’s statistics about filesystems jfs
Code:
vmstat –v |grep 'client filesystem I/Os blocked with no fsbuf'

It’s statistics about filesystems nfs, veritas, …
Code:
vmstat –v|grep 'external pager filesystem I/Os blocked with no fsbuf'

It’s statisctics about filesystems jfs2
Conclusions are obvious.

Vit0_Corleone
you have disks on SAN. by NFS or FiberConnect(etherConnect)
It's maybe problem with tcp.
When will be the problem do
Code:
netstat -s

You can test the connect make big transfer from server to dysk, better to same disks.

Last edited by john1212; 08-19-2010 at 05:23 AM..
# 20  
Old 10-11-2010
Well we have finished upgrading of DS8000 and I located DB2 containers on separate filesystems.. the performance is just a perfect!!! thanks to everybody
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

Kswapd high cpu utilization.

Hi, Please suggest how to troubleshoot, kswapd is utilizing high cpu? also wanted to know which parameters are important and needs to be added with sar command for monitoring the performance of Linux (Oracle 5.8 -64 bit Please guide me. I am facing the issue where server is getting... (0 Replies)
Discussion started by: manoj.solaris
0 Replies

2. Shell Programming and Scripting

High cpu usage

I have created one script and i have added it into cron to run after 10 mins. However I have noted that whenever that script runs, It causes CPU utilization of server to increase about 10-20 % I have rechecked script and there is no way i can make changes, Script contain only 2-3 commands. So... (4 Replies)
Discussion started by: Nakul_sh
4 Replies

3. 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

4. Red Hat

High CPU Utilization

Hi Experts, I need to understand few basic things regarding top command result from one of the node i have collected: Cpu0 : 4.6%us, 2.0%sy, 0.0%ni, 91.4%id, 1.3%wa, 0.3%hi, 0.3%si, 0.0%st Cpu1 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu2 : ... (5 Replies)
Discussion started by: mackjack87
5 Replies

5. 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

6. Web Development

High CPU with Moodle

Hello list, I am managing a Moodle site on Apache2 server with Ubuntu. There are 20-30 simultaneous users and the server get 100% CPU and it stop working. The server is a dual core 3GHz and 4GB o memory. I think thta it is enough powerful machine for a Moodle site. How could I configure... (0 Replies)
Discussion started by: jlazkano
0 Replies

7. 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

8. 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

9. 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

10. 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