Sponsored Content
Full Discussion: DB2 high CPU
Operating Systems AIX DB2 high CPU Post 302445536 by Vit0_Corleone on Monday 16th of August 2010 07:37:12 AM
Old 08-16-2010
Yes these heavily loaded disks are located on the DS8000 storadge.. but I have no good understanding how to work with this storadge and therefore I cant check anything on that storadge Smilie
and here is vmstat -v result and i want to thank you for your help...
Code:
vmstat -v
              6291456 memory pages
              6091921 lruable pages
               733113 free pages
                    3 memory pools
               483310 pinned pages
                 80.0 maxpin percentage
                  3.0 minperm percentage
                 90.0 maxperm percentage
                  4.5 numperm percentage
               278340 file pages
                  0.0 compressed percentage
                    0 compressed pages
                  4.5 numclient percentage
                 90.0 maxclient percentage
               278340 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
                54484 client filesystem I/Os blocked with no fsbuf
                    0 external pager filesystem I/Os blocked with no fsbuf
CDR /home #



---------- Post updated at 06:37 AM ---------- Previous update was at 06:34 AM ----------

and we are running out of storage space and in September we are going to make some upgrade... We think like you that splitting tablespaces/containers will give us some performance....
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
VMSTAT(1)						    BSD General Commands Manual 						 VMSTAT(1)

NAME
vmstat -- report virtual memory statistics SYNOPSIS
vmstat [-CefHiLlmstUvW] [-c count] [-h hashname] [-M core] [-N system] [-u histname] [-w wait] [disks] DESCRIPTION
vmstat reports certain kernel statistics kept about process, virtual memory, disk, trap, and CPU activity. The options are as follows: -C Report on kernel memory caches. Combine with the -m option to see information about memory pools that back the caches. -c count Repeat the display count times. The first display is for the time since a reboot and each subsequent report is for the time period since the last display. If no wait interval is specified, the default is 1 second. -e Report the values of system event counters. -f Report fork statistics. -H Report all hash table statistics. -h hashname Report hash table statistics for hashname. -i Report the values of system interrupt counters. -L List all the hashes supported for -h and -H. -l List the UVM histories being maintained by the kernel. -M core Extract values associated with the name list from the specified core instead of the default /dev/mem. -m Report on the usage of kernel dynamic memory listed first by size of allocation and then by type of usage, followed by a list of the kernel memory pools and their usage. -N system Extract the name list from the specified system instead of the default /netbsd. -s Display the contents of the uvmexp structure. This contains various paging event and memory status counters. -t Display the contents of the vmtotal structure. This includes information about processes and virtual memory. The process part shows the number of processes in the following states: ru on the run queue dw in disk I/O wait pw waiting for paging sl sleeping The virtual memory section shows: total-v Total virtual memory active-v Active virtual memory in use active-r Active real memory in use vm-sh Shared virtual memory avm-sh Active shared virtual memory rm-sh Shared real memory arm-sh Active shared real memory free Free memory All memory values are shown in number of pages. -U Dump all UVM histories. -u histname Dump the specified UVM history. -v Print more verbose information. When used with the -i, -e, or -m options prints out all counters, not just those with non-zero values. -W Print more verbose information about kernel memory pools. -w wait Pause wait seconds between each display. If no repeat count is specified, the default is infinity. By default, vmstat displays the following information: procs Information about the numbers of processes in various states. r in run queue b blocked for resources (i/o, paging, etc.) memory Information about the usage of virtual and real memory. Virtual pages (reported in units of 1024 bytes) are considered active if they belong to processes which are running or have run in the last 20 seconds. avm active virtual pages fre size of the free list page Information about page faults and paging activity. These are averaged every five seconds, and given in units per second. flt total page faults re page reclaims (simulating reference bits) pi pages paged in po pages paged out fr pages freed per second sr pages scanned by clock algorithm, per-second disks Disk transfers per second. Typically paging will be split across the available drives. The header of the field is the first charac- ter of the disk name and the unit number. If more than four disk drives are configured in the system, vmstat displays only the first four drives. To force vmstat to display specific drives, their names may be supplied on the command line. faults Trap/interrupt rate averages per second over last 5 seconds. in device interrupts per interval (including clock interrupts) sy system calls per interval cs CPU context switch rate (switches/interval) cpu Breakdown of percentage usage of CPU time. us user time for normal and low priority processes sy system time id CPU idle FILES
/netbsd default kernel namelist /dev/mem default memory file EXAMPLES
The command ``vmstat -w 5'' will print what the system is doing every five seconds; this is a good choice of printing interval since this is how often some of the statistics are sampled in the system. Others vary every second and running the output for a while will make it appar- ent which are recomputed every second. SEE ALSO
fstat(1), netstat(1), nfsstat(1), ps(1), systat(1), iostat(8), pstat(8) The sections starting with ``Interpreting system activity'' in Installing and Operating 4.3BSD. BUGS
The -c and -w options are only available with the default output. The -l, -U, and -u options are useful only if the system was compiled with support for UVM history. BSD
October 22, 2009 BSD
All times are GMT -4. The time now is 03:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy