Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: DB2 high CPU
Operating Systems AIX DB2 high CPU Post 302445515 by Vit0_Corleone on Monday 16th of August 2010 06:33:08 AM
Old 08-16-2010
Code:
vmstat -w 1 10 

System configuration: lcpu=16 mem=24576MB ent=4.00

 kthr   memory                 page                       faults                 cpu          
-------  ------------------------------------ ------------------ -----------------------
  r   b        avm        fre    re    pi    po    fr     sr    cy    in     sy    cs us sy id wa    pc    ec
  2   0    5235358     868064     0     0     0     0      0     0  2999  10933  6223  5  3 88  4  0.40  10.1
  0   0    5235359     868063     0     0     0     0      0     0  2629   9390  5547  4  3 89  4  0.34   8.6
  0   0    5235357     868065     0     0     0     0      0     0  2547  13373  5302  5  4 88  4  0.40  10.0
  0   0    5235357     868065     0     0     0     0      0     0  3038  11937  6316  6  3 88  4  0.43  10.7
  0   0    5235357     868064     0     0     0     0      0     0  2421   9710  5455  4  3 89  4  0.35   8.8
  0   0    5235358     868063     0     0     0     0      0     0  2604   9692  5381  4  3 89  4  0.33   8.3
  0   0    5235358     868063     0     0     0     0      0     0  3722  11819  7843  5  4 87  4  0.45  11.3
  1   0    5235356     868065     0     0     0     0      0     0  3055  12577  6214  5  3 88  3  0.43  10.6
  0   0    5235357     868064     0     0     0     0      0     0  3354  20234  6494  6  4 86  3  0.51  12.8
  0   0    5235357     868064     0     0     0     0      0     0  2444   8784  5198  4  3 89  4  0.32   8.1


and here is iostat and I guess the only problem is that disks are heavily loaded
Code:
Disks:        % tm_act     Kbps      tps    Kb_read   Kb_wrtn
hdisk3          99.8     17080.0     897.1      75544     95384
hdisk2          94.6     16653.1     905.1      76600     90056
hdisk4          20.2     880.5     152.6         16      8796
hdisk0           1.4      28.4       2.8          4       280
hdisk1           1.3      28.0       2.7          0       280

 

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

LEARN ABOUT PHP

db2_pclose

DB2_PCLOSE(3)								 1							     DB2_PCLOSE(3)

db2_pclose - Closes a persistent database connection

SYNOPSIS

       bool db2_pclose (resource  $resource)

DESCRIPTION

	This function closes a DB2 client connection created with db2_pconnect(3) and returns the corresponding resources to the database server.

       Note

	       This function is only available on i5/OS in response to i5/OS system administration requests.

	If  you  have a persistent DB2 client connection created with db2_pconnect(3), you may use this function to close the connection. To avoid
       substantial connection performance penalties, this function should only be used in rare cases when the  persistent  connection  has  become
       unresponsive or the persistent connection will not be needed for a long period of time.

PARAMETERS

	      o $connection
		- Specifies an active DB2 client connection.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Closing a persistent connection

	       The following example demonstrates a successful attempt to close a connection to an IBM DB2 i5/OS database.

	      <?php
	      $conn = db2_pconnect('', '', '');
	      $rc = db2_pclose($conn);
	      if ($rc) {
		  echo "Connection was successfully closed.";
	      }
	      ?>

	      The above example will output:

	      Connection was successfully closed.

SEE ALSO

       db2_close(3), db2_pconnect(3).

PHP Documentation Group 													     DB2_PCLOSE(3)
All times are GMT -4. The time now is 09:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy