Sponsored Content
Operating Systems AIX Asynchronous I/O on AIX and DB performance Post 302514730 by arizah on Sunday 17th of April 2011 08:58:16 PM
Old 04-17-2011
Hi ,

Thanks for your answer. I like your analogy but I thought that in my case dealing with a big Database server (5 TB data warehouse database ) having extra Async I/O processes would increase/help performance. What worries me is I'm executing the isotat -AQ command and I'm getting :
Code:
176            186             /db/twd/NODE0004/WKSPACE001
177            160             /db/twd/NODE0004/WKSPACE002
181            166             /db/twd/NODE0006/WKSPACE001
182            162             /db/twd/NODE0006/WKSPACE002
186            148             /db/twd/NODE0008/DBSPACE001
187            148             /db/twd/NODE0008/DBSPACE002
191            176             /db/twd/NODE0010/WKSPACE001
192            139             /db/twd/NODE0010/WKSPACE002

I thought that this could be sign that there is a bottleneck in this case. Maybe there isn't because I'm not a Unix expert.

Last edited by Scott; 04-18-2011 at 02:55 AM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

AIX server performance problem!

Hello, I have a performance problem on an AIX box. I'm not sure what is causing this and hoping someone may have suggestions. Currently I'm noticing that cpu's are waiting while the box is in a idle state. I checked the disks and none of them are at 100%. If they were then I would understand... (3 Replies)
Discussion started by: ctcuser
3 Replies

2. UNIX for Dummies Questions & Answers

AIX performance

Hiya all, I am a newbie sysadmin to AIX, i have worked on HPUX for 3 years. I have started a new role with in an IBM house and because there is me and one other there are a couple of issues I cannot work out: We havehad a production server slowing down processing batch jbs over the past... (6 Replies)
Discussion started by: chlawren
6 Replies

3. AIX

Performance testing on AIX

I'm doing performance testing for one application which works on AIX. But I don't know which performance parameters of memory need to be collected. Now, I just know very few: 1. page in 2. page out 3. fre They are all collected by "vmstat" command. I want to know, except for above... (2 Replies)
Discussion started by: adasong
2 Replies

4. AIX

AIX 5.2 performance question

I am trying to analyze the performance of an AIX system. I think I may have a disk I/O issue, but I am asking for help to validate or invalidate this assumption. I ran the commands below during a period of peak load. Please help me to find any performance bottlenecks. Thanks in advance for your... (15 Replies)
Discussion started by: jhall
15 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. AIX

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... (2 Replies)
Discussion started by: mad_man12
2 Replies

7. 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

8. AIX

Need some help for AIX performance monitoring

Hello I am new user of AIX; I have only basic knowledge of the UNIX commands, and I want to create script that will monitor the performance and resources usage on AIX 6.1 machine. Basically I wan to start a loop that will grab, every 10 seconds, the CPU usage, the memory usage, the disk usage,... (1 Reply)
Discussion started by: adaher
1 Replies

9. AIX

AIX 5.3 performance problems

Hello, I encounter some performance issues on my AIX 5.3 server running in a LPAR on a P520. How do I investigate performance issues in AIX. Is there any kind of procedure that takes me to the steps to investigate my server and find the sub systems that is causing the issues? The performance... (1 Reply)
Discussion started by: petervg
1 Replies

10. AIX

Performance stats from AIX 6

Hi, I'm supposed to capture many performance stats on AIX 6 and stuck up with below: Priority queue Disk cache hit% Page out rate Swap out rate Memory queue I see vmstatis helpful for "page out" but not sure how to get the "rate". Could anyone please let me know how to get these... (4 Replies)
Discussion started by: reddyr
4 Replies
MRINFO(8)						      System Manager's Manual							 MRINFO(8)

NAME
mrinfo - Displays configuration info from a multicast router SYNOPSIS
/usr/sbin/mrinfo [ -d debug_level ] [ -r retry_count ] [ -t timeout_count ] multicast_router DESCRIPTION
mrinfo attempts to display the configuration information from the multicast router multicast_router. mrinfo uses the ASK_NEIGHBORS IGMP message to the specified multicast router. If this multicast router responds, the version number and a list of their neighboring multicast router addresses is part of that response. If the responding router has a recent multicast version num- ber, then mrinfo requests additional information such as metrics, thresholds, and flags from the multicast router. Once the specified mul- ticast router responds, the configuration is displayed to the standard output. INVOCATION
"-d" option sets the debug level. When the debug level is greater than the default value of 0, addition debugging messages are printed. Regardless of the debug level, an error condition, will always write an error message and will cause mrinfo to terminate. Non-zero debug levels have the following effects: level 1 packet warnings are printed to stderr. level 2 all level 1 messages plus notifications down networks are printed to stderr. level 3 all level 2 messages plus notifications of all packet timeouts are printed to stderr. "-r retry_count" sets the neighbor query retry limit. Default is 3 retry. "-t timeout_count" sets the number of seconds to wait for a neighbor query reply. Default timeout is 4 seconds. SAMPLE OUTPUT
mrinfo mbone.phony.dom.net 127.148.176.10 (mbone.phony.dom.net) [version 3.3]: 127.148.176.10 - 0.0.0.0 (?) [1/1/querier] 127.148.176.10 - 127.0.8.4 (mbone2.phony.dom.net) [1/45/tunnel] 127.148.176.10 - 105.1.41.9 (momoney.com) [1/32/tunnel/down] 127.148.176.10 - 143.192.152.119 (mbone.dipu.edu) [1/32/tunnel] For each neighbor of the queried multicast router, the IP of the queried router is displayed, followed by the IP and name of the neighbor. In square brackets the metric (cost of connection), the threshold (multicast ttl) is displayed. If the queried multicast router has a newer version number, the type (tunnel, srcrt) and status (disabled, down) of the connection is displayed. IMPORTANT NOTE
mrinfo must be run as root. SEE ALSO
mrouted(8), map-mbone(8), mtrace(8) AUTHOR
Van Jacobson 4.2 Berkeley Distribution MRINFO(8)
All times are GMT -4. The time now is 06:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy