Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: performance issue in AIX
Operating Systems AIX performance issue in AIX Post 302419263 by mad_man12 on Thursday 6th of May 2010 04:06:14 PM
Old 05-06-2010
performance issue in AIX
Gurus, i have process that runs 5 times a day.
it runs normally (takes about 1 hour) to complete in 3 runs
but it is takes about ( 3 hrs to complete) two times
So i need to figure out why it takes significanlty high time during
those 2 runs.
The process is a shell script that connect to database and fetches some data
through simple select statement(in a stored procedure)

i ran a iostat 10 in the machine during normal and extented time
and compared the cpu utilisation and checks to see if there is any other
process that is taking the bulk of cpu usage but didn't find
any.

The only differnce was on cpu utilization where the process took .3 % of cpu
during normal runs and .1% during extended run




normal run
Code:
root       516 44.2  1.0    8 6012      - A      Apr 22 8500:53 kproc
root     19618 15.2  1.0 10404 10148      - A    22:30:50  2:34 sendmail: DAF0424
root     23072 14.3  3.0 24428 24176      - A    22:00:50  6:43 sendmail: DBX2008
sybase   13166  9.1  0.0 4060 2452      - A      Apr 22 1742:49 /sybase/syb1103/b
root     11098  2.6  6.0 88020 58316      - A      Apr 22 509:52 /usr/bin/dsmc sch
root      3396  0.4  0.0  156   36      - A      Apr 22 78:52 /usr/sbin/syncd 6
sa       16098  0.4  0.0 1876 1420      - A    20:10:55  0:37 sshd: sa@pts/1
root      1032  0.2  1.0   64 6060      - A      Apr 22 47:31 kproc
sa       18556  0.2  0.0  720  724      - A    22:26:57  0:03 isql -P


extended run
Code:
root       516 43.9  1.0    8 5832      - A      Apr 22 8520:52 kproc
root     18858 14.1  2.0 20760 20380      - A    00:30:50  5:32 sendmail: BAO2168
root     24542  9.8  0.0 4984 4600      - A    01:00:50  0:55 sendmail: FBI2230
sybase   13166  9.0  0.0 4060 1388      - A      Apr 22 1754:12 /sybase/syb1103/b
root     11098  2.8  0.0 88024 2784      - A      Apr 22 549:07 /usr/bin/dsmc sch
root      3396  0.4  0.0  156   36      - A      Apr 22 79:32 /usr/sbin/syncd 6
root      1032  0.2  1.0   64 5880      - A      Apr 22 47:41 kproc
sa       17734  0.1  0.0  724  240      - A    23:50:03  0:06 isql -P

The last process isql -P being my process
Please advice on how to find the bottleneck.
PS: vmstat doesn't work in it ,My /var is about 90% does that have any effect in it?
 

10 More Discussions You Might Find Interesting

1. AIX

performance issue

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

performance issue

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

performance issue

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

Performance issue in expect library on AIX 5.3

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

Performance issue in AIX 5.3

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

Performance issue!

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

Performance issue or something else?

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

AIX performance issue

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

Performance issue

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

Performance issue

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 MOJAVE

systemd-volatile-root.service

SYSTEMD-VOLATILE-ROOT.SERVICE(8)                           systemd-volatile-root.service                          SYSTEMD-VOLATILE-ROOT.SERVICE(8)

NAME

       systemd-volatile-root.service, systemd-volatile-root - Make the root file system volatile

SYNOPSIS

       systemd-volatile-root.service

       /lib/systemd/systemd-volatile-root

DESCRIPTION

       systemd-volatile-root.service is a service that replaces the root directory with a volatile memory file system ("tmpfs"), mounting the
       original (non-volatile) /usr inside it read-only. This way, vendor data from /usr is available as usual, but all configuration data in
       /etc, all state data in /var and all other resources stored directly under the root directory are reset on boot and lost at shutdown,
       enabling fully stateless systems.

       This service is only enabled if full volatile mode is selected, for example by specifying "systemd.volatile=yes" on the kernel command
       line. This service runs only in the initial RAM disk ("initrd"), before the system transitions to the host's root directory. Note that this
       service is not used if "systemd.volatile=state" is used, as in that mode the root directory is non-volatile.

SEE ALSO

       systemd(1), systemd-fstab-generator(8), kernel-command-line(7)

systemd 237                                                                                                       SYSTEMD-VOLATILE-ROOT.SERVICE(8)
All times are GMT -4. The time now is 12:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy