08-16-2010
Yes there is some traffic on hdisk2 and hdisk3 having a high busy time and lots of transactions while using some bandwith.
Else CPU and memory wise the box looks good so that "wwwww"s in nmon will be the kernel wait processes, nothing to worry.
If you experience any slow behaviour though, you might want to think if it there is any improvement of the disk layout possible, ie. splitting tablespaces/containers to more than 2 volumes. Maybe also db2expln shows that there can be more efficiency by implementing an index at the right place etc.
I guess you have some SAN storage behind this with a cache - if this is the case, you might want to check if those SAN disks are ok with that load or not.
A vmstat -v might be interessting too in that case.
10 More Discussions You Might Find Interesting
1. Solaris
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
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
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
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
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
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
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
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
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
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_close
DB2_CLOSE(3) 1 DB2_CLOSE(3)
db2_close - Closes a database connection
SYNOPSIS
bool db2_close (resource $connection)
DESCRIPTION
This function closes a DB2 client connection created with db2_connect(3) and returns the corresponding resources to the database server.
If you attempt to close a persistent DB2 client connection created with db2_pconnect(3), the close request is ignored and the persistent
DB2 client connection remains available for the next caller.
PARAMETERS
o $connection
- Specifies an active DB2 client connection.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Closing a connection
The following example demonstrates a successful attempt to close a connection to an IBM DB2, Cloudscape, or Apache Derby database.
<?php
$conn = db2_connect('SAMPLE', 'db2inst1', 'ibmdb2');
$rc = db2_close($conn);
if ($rc) {
echo "Connection was successfully closed.";
}
?>
The above example will output:
Connection was successfully closed.
SEE ALSO
db2_connect(3), db2_pclose(3), db2_pconnect(3).
PHP Documentation Group DB2_CLOSE(3)