10-24-2011
We need to see the existing script to help you further!!! Can you share the SQL query? What do you mean by "automate this task and pass the top processes" if the SQL script can derive the CPU eating processes using by itself as you mentioned?
Please clarify your goal, so that we can help you!!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear all
I want to execute some isql command from unix shell script. Kindly suggest me. isql command mention below.
isql -U -P
use gdb_1
go
select count (*) from table_x
go (3 Replies)
Discussion started by: jaydeep_sadaria
3 Replies
2. Shell Programming and Scripting
I want to write a script to go to particular path in file and run shell script from there.
what will be shell script for the same. (2 Replies)
Discussion started by: shekhar_ssm
2 Replies
3. UNIX for Dummies Questions & Answers
I need to write a Unix shell script which will list top 10 files in a directory tree on basis of size. i.e. first file should be the biggest in the whole directory and all its sub directories.
Please suggest any ideas (10 Replies)
Discussion started by: abhilashnair
10 Replies
4. AIX
HI All,
Can anyone send me a command to find TOP 5 Memory consuming process.
It would be lelpful if I get output something like below
processname - pid - memory(in MB) - command
I tried few commands from the internet but the result only give the real memory usage or pagging, I want total... (4 Replies)
Discussion started by: bce_groups
4 Replies
5. AIX
Okay, I am trying to come up with a multi-platform script to report top ten CPU and memory hog processes, which will be run by our enterprise monitoring application as an auto-action item when the CPU and Memory utilization gets reported as higher than a certain threshold
I use top on other... (5 Replies)
Discussion started by: thenomad
5 Replies
6. Shell Programming and Scripting
I m using following command to find top 10 cpu consuming processes.
However whenever i execute the command i get
following warning.
What can be done to avoid it?
# ps -auxf | sort -nr -k 3 | head -10
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.7/FAQ
root ... (6 Replies)
Discussion started by: pinga123
6 Replies
7. Shell Programming and Scripting
When I run 'top' command,I see the following
Memory: 32G real, 12G free, 96G swap free
Though it shows as 12G free,I am not able to account for processes that consume the rest 20G.
In my understanding some process should be consuming atleast 15-16 G but I am not able to find them.
Is... (1 Reply)
Discussion started by: prasperl
1 Replies
8. Shell Programming and Scripting
Hi All,
I am new to Scripting , please give me guidance to write the script to see top processes on the Linux operating system.
I executed this script on my Virtual Server(Linux)
DATE=`date +%Y%m%d%H%M%S`
HOME=/home/xmp/testing/xmp_report
RADIUS_PID=`xms -xmp sh pr | grep... (2 Replies)
Discussion started by: madala
2 Replies
9. UNIX for Dummies Questions & Answers
Platform: Oracle Linux 6.4
To find the most memory consuming processes, I tried the following 2 methods
1. Method1
# ps aux | head -1 ; ps aux | sort -nk +4 | tail -7
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 95 0.0 0.0 0 0 ? ... (2 Replies)
Discussion started by: kraljic
2 Replies
10. UNIX for Dummies Questions & Answers
hi all
sleeping processes in the following output , are they doing anything , but consuming lot of sources, should I need to kill them , how to know , , what they are doing
and the output says out of 260 processes only 9 are running , and 251 are sleeping , what does the sleeping means, can... (8 Replies)
Discussion started by: sidharthmellam
8 Replies
LEARN ABOUT PHP
ifx_fieldproperties
IFX_FIELDPROPERTIES(3) 1 IFX_FIELDPROPERTIES(3)
ifx_fieldproperties - List of SQL fieldproperties
SYNOPSIS
array ifx_fieldproperties (resource $result_id)
DESCRIPTION
Returns the Informix SQL fieldproperties of every field in the query as an associative array. Properties are encoded as: "SQL-
TYPE;length;precision;scale;ISNULLABLE" where SQLTYPE = the Informix type like "SQLVCHAR" etc. and ISNULLABLE = "Y" or "N".
PARAMETERS
o $result_id
-$result_id is a valid resultid returned by ifx_query(3) or ifx_prepare(3) (select type queries only!).
RETURN VALUES
Returns an associative array with fieldnames as key and the SQL fieldproperties as data for a query with $result_id. Returns FALSE on
errors.
EXAMPLES
Example #1
Informix SQL fieldproperties
<?php
$properties = ifx_fieldproperties($resultid);
if (!isset($properties)) {
/* ... error ... */
}
foreach ($properties as $fname => $val) {
echo "$fname: property = $val
";
}
?>
SEE ALSO
ifx_fieldtypes(3).
PHP Documentation Group IFX_FIELDPROPERTIES(3)