|
|
Sponsored Content
Operating Systems
AIX
performance issue in AIX
Post 302419452 by zaxxon on Friday 7th of May 2010 08:05:22 AM
05-07-2010
Moving to AIX subforum.
---------- Post updated at 02:05 PM ---------- Previous update was at 01:48 PM ----------
You could check several things:
Having var at 90% should not be an issue. No idea what isql does but from googling I guess it's just a SQL java client to issue some SQL on a box. Is the database in that case running on the same box or a remote box? You might have to check if the issued runs are different in execution etc. ie. if table scans occure that because of a now missing index or something like that. Need a bit more info about your infrastructure, what you are doing with isql etc. and which app is on which box etc.
The 0.1% to 0.3% should be really no issue. If your box has no room CPU wise for 0.2%, then there you have another big general problem.
And make vmstat running - it is very helpful.
---------- Post updated at 02:05 PM ---------- Previous update was at 01:48 PM ----------
You could check several things:
- Make sure your box has no general performance problem. This can be achived with running topas or vmstat (get it working!
) instead of just iostat since they give much more interessting info on virtual memory (paging space in/outs etc.), kernel thread queues etc... - Make sure there is no other jobs running at this time in parallel which were not running in the days before when everything was fine.
- Set up nmon and nmontools (nmon2rrd) for long term monitoring (free available via IBM websites). With the tools you can generate nice looking reports in form of html sites with good formatted graphics so it will be easier to identify in a short time, if there were any obscurities in the different runs, like other processes running in parallel which are not supposed to be there and so on.
Having var at 90% should not be an issue. No idea what isql does but from googling I guess it's just a SQL java client to issue some SQL on a box. Is the database in that case running on the same box or a remote box? You might have to check if the issued runs are different in execution etc. ie. if table scans occure that because of a now missing index or something like that. Need a bit more info about your infrastructure, what you are doing with isql etc. and which app is on which box etc.
The 0.1% to 0.3% should be really no issue. If your box has no room CPU wise for 0.2%, then there you have another big general problem.
And make vmstat running - it is very helpful.
|
|
10 More Discussions You Might Find Interesting
1. AIX
We have a AIX v5.3 on a p5 system with a poor performing Ingres database.
We added one CPU to the system to see if this would help. Now there are two CPU's.
with sar and topas -P I see good results: CPU usage around 30%
with topas I only see good results in the process output screen, the... (1 Reply)
Discussion started by: rein
1 Replies
2. UNIX for Advanced & Expert Users
Hi,
on a linux server I have the following :
vmstat 2 10
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
0 4 0 675236 39836 206060 1617660 3 3 3 6 8 7 1 1 ... (1 Reply)
Discussion started by: big123456
1 Replies
3. Shell Programming and Scripting
I want to read a file.
is it good to use File I/O or shell script??
which one is the best option? (1 Reply)
Discussion started by: vishwaraj
1 Replies
4. AIX
Hi All,
I am getting a performance issue in expect5.43.0 library on IBM AIX 5.3. When I have used exp_fexpectv call for pattern matching with the expect string, the execution latency of the call is approximately 200 ms. In that way, I am able to complete only 4 or 5 transactions per... (2 Replies)
Discussion started by: ravindra_maddal
2 Replies
5. AIX
Is there is any way to increase the CPU utilization of a Embedded SQL program in AIX 5.3 .. for performance purpose. (0 Replies)
Discussion started by: Gyanendra Awast
0 Replies
6. UNIX for Advanced & Expert Users
In my C program i am using very large file(approx 400MB) to read parts of it frequently. But due to large file the performance of the program goes down very badly. It shows very high I/O usage and I/O wait time.
My question is, What are the ways to optimize or tune I/O on linux or how i can get... (10 Replies)
Discussion started by: mavens
10 Replies
7. Shell Programming and Scripting
Hi All,
I have the following script which I use in Nagios to check the health of the applications, the problem with it is that the curl part ($TOTAL) does not return anything after running for 2-3 hrs, even though from command line the script runs fine but not from Nagios.
There are 17... (1 Reply)
Discussion started by: jacki
1 Replies
8. AIX
Hi Guys,
This is the situation I am in. Provide your views and input where should I start?
I have one P7 test server and a p520 production server. the job is taking pretty long on the P7 test server when compared to the P5 production server. below is the full detail.
Informix... (5 Replies)
Discussion started by: ithinksgreen
5 Replies
9. UNIX for Dummies Questions & Answers
hi I am having a performance issue with the following requirement
i have to create a permutation and combination on a set of three files
such that each record in each file is picked and the output is redirected in
a specific format but it is taking around 70 odd hours to prepare a
combination... (7 Replies)
Discussion started by: mad_man12
7 Replies
10. AIX
Hi,
We have 2 lpars on p6 blade. One of the lpar is having 3 core cpu with 5gb memory running sybase as database. An EOD process takes 25 min. to complete.
Now we have an lpar on P7 server with entitled cpu capacity of 2 with 16 Gb memory and sybase as database. The EOD process which takes... (17 Replies)
Discussion started by: vjm
17 Replies
LEARN ABOUT SUSE
gst-complete-0.8
gst-complete-0.8(1) User Commands gst-complete-0.8(1) NAME
gst-complete-0.8, gst-complete - perform bash completion for gst-launch command lines SYNOPSIS
complete -Cgst-complete-0.8 gst-launch gst-complete [--gst-list-mm] [--gst-mm=string] [--print] DESCRIPTION
gst-complete-0.8 enables bash to provide context-sensitive tab completion for gst-launch command lines. See gst-launch(1) for the syntax of gst-launch command lines. You must have a version of bash that supports programmable completion. Such versions of bash provide the complete built-in command. gst-complete is a wrapper script that runs the latest installed version of gst-complete-X.X. For example, if both gst-complete-0.7 and gst- complete-0.8 are installed on your system, gst-complete runs gst-complete-0.8. OPTIONS
The following options are supported by gst-complete-0.8 and gst-complete: --help Display detailed usage message. You can also use -? to specify this option. The following options are supported by gst-complete only: --gst-list-mm List found major/minor versions. This option displays the versions that are available. --gst-mm=string Force major/minor version. This option enables you to specify a specific version to run, if you do not want to run the default version. --print Print wrapped command line. This option displays the command that will be run, and then runs the command. EXAMPLES
Example 1: Generating the Registry of Available Plugins by Running gst-compprep Run the following command in your .bash_profile or other appropriate place: example% complete -C gst-complete-0.8 gst-launch Example 2: Running the Wrapper Script and Displaying the Command Name example% gst-complete --print /usr/bin/gst-complete-0.8 FILES
The following files are used by this application: /usr/bin/gst-complete-0.Executable for bash completion for gst-launch /usr/bin/gst-complete Wrapper script that runs the latest installed version of gst-complete-X.X ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWgnome-media | +-----------------------------+-----------------------------+ |Interface stability |External | +-----------------------------+-----------------------------+ SEE ALSO
gst-compprep(1), gst-feedback(1), gst-inspect(1), gst-launch(1), gst-launch-ext(1), gst-md5sum(1), gst-register(1), gst-thumbnail(1), gst- typefind(1), gst-xmlinspect(1), gst-xmllaunch(1), gstreamer-properties(1), libgstreamer-0.8(3), libgstgetbits(3) NOTES
Original man page written by the GStreamer team at http://gstreamer.net/. Updated by Brian Cameron, Sun Microsystems Inc., 2004. SunOS 5.10 14 Oct 2004 gst-complete-0.8(1)