AIX sub-system refresh problem

AIX sub-system refresh problem

Post by axel.. » Wed, 03 Jan 2001 18:42:53

I'm on AIX 4.3 and am encountering a problem with the refresh command :
refresh -s snmpd lags, and then returns an 0513-056 error (some timeout
Can somebody help me out this problem ? (OS is "out of the box", no

By the way -see error message- I am not indicating a distant host. So -
r option on srcmstr should not be necessary.

Many thanks !

Example :
# refresh -s snmpd
0513-056 Dpas*t de dlai lors de l'attente d'une rponse une
commande. Si vous avez indiqu un systme h?te loign,
vrifiez, dans le fichier /etc/inittab contenu sur cet h?te que le
dmon SRC (srcmstr) a t lanc avec l'option -r pour accepter les
demandes loignes.

For English speaking users, I try to translate the error : timeout
occured while waiting for a command's answer. If you have indicated a
distant host, check /etc/inittab 's content for this host, and that the
SRC daemon has been launched with -r option to enable distant commands.

Sent via


1. Oracle 8.0.5, aix 4.3.2 & VSS Raid Sub-System

Hi all,

Can anyone out there offer advice on how to configure an IBM VSS disk
subsystem to give reasonable performance with an Oracle 8.0.5 DB.
Current throughput rates are around 9Mbs for read and only 1.5Mb for

The application is a DSS and is of the order of 150Gb.

The configuration is an IBM VSS with 8 drawers, each drawer has two RAID
5 arrays on the same SSA loop with each array being divided up into 2 x

I don't want any replies stating the obvious, that you shouldn't use
RAID 5 etc. for DSS systems, the point is we've been lumbered with one
and we have to get the best from it.

IBM recommend using 32K striping and using as many SCSI adapters as
possible. However there seems to be a real problem with parallel queries
generating what seems to, the subsystem & it's cache, random I/O when in
fact it's really sequential table scans and therefor fails to provoke
the read cache into performing read-ahead.

We've actually tried not striping the data and improved read-only
queries by trying to predict where the Oracle optimiser will start each
parallel query and laying out the raw LVs used by the tables to
coincide, but it's a lot of work.

Read/Write performance is especially low at perhaps 1/6th of the
read-only rate. This makes me think that the write cache is not being
invoked in "lazy" write mode or something similar although even then I'd
only have expected the rate to quarter. However, perhaps two-phase
commitment is accounting for the remainder.

So my questions are :-

What rate of throughput should I expect from my SCSI adapters when I'm
doing read-only & 50% read/write workloads.

What, if anything, can I do about the disk layout which will improve

What, if anything, can I suggest to our Oracle programmers to bend the
application to get more from the hardware we're stuck with ?

I'd also welcome views on, if I reverted to classical SSA disks, how
should I best configure them for Oracle Parallel Queries, JBOD, RAID,
should I stripe, if so at what level 4k, 8k, 32K or at the LVM partition

On a related matter, I personally think using LVM stripping isn't worth
the bother. I don't see the performance gain outweighing the loss of
mirroring type facilities for online backups, migration etc. and it
makes disk replacement a nightmare. Comments please.


John McQue

IMS Health

2. Which video cards work best?

3. Sub-sub-sub-sub-sub subdomains?

4. How tell if ksh interactive?

5. IPC Shared Memory sub-system on IBM AIX 3.1.5

6. Loss of network connection

7. Sub-system problem

8. can't backtrace assert(0) with new/delete

9. Problem with SCO sub-system login

10. Looking for Raid Sub-System

11. TCP/IP sub-system going very slow?

12. How to Kill Process and Its sub-process and its sub-process??

13. NIS+ Sub-Domain client: should it be a member of the master domain AND sub-domain?