IDS Forum

Re: IDS 7.31UD7 on MP-RAS not able to initialize

Posted By: rroussey@comcast.net
Date: Wednesday, 16 March 2011, at 4:37 p.m.

In Response To: Re: IDS 7.31UD7 on MP-RAS not able to initialize (BILL FLORENCE)

Yeesh!

- Does NCR certify MP-RAS to run on the Dell box? (If neither company certifies it......)
- Are there drivers from Dell or NCR to specifically run MP-RAS on this box? (could affect SHM access)
- Before you start the db, can you view $INFORMIXDIR/etc/$ONCONFIG ok? (is the environment good)?
- Are all the permissions and ownership under $INFORMIXDIR and subdirectories correct? Especially $INFORMIXDIR/bin/

Just asking.

Bob

----- Original Message -----
From: "BILL FLORENCE" <spider348@hotmail.com>
To: ids@iiug.org
Sent: Wednesday, March 16, 2011 3:12:11 PM
Subject: Re: IDS 7.31UD7 on MP-RAS not able to initialize [23116]

Art,

re. the buffers and locks low numbers - yes, I agree, however they were left
that way (low) on purpose. Reasoning is I am only trying to get the server
'up' and do not want to introduce other potential issues. At one time we did
try with actual production values (larger) but it still hung. I will
re-configure and/or re-initialize later.

re. You are correct about the Dell hardware. NCR MP-RAS is on it and "running"
albiet this is a new venture. I originally had the multiprocessor = 1 but last
iteration was 0 as seen in my config - great suggestion though.

I set both your suggestions and retried but still hangs....
no shared memory is being allocated per ipcs - arg.

I was not able to find machine notes or much at all regarding Dell T410 and
Informix with MP-RAS so I am not sure where to go from here.

Is it possible this proof of concept will end here because of hardware
differences?

Any other suggestions , opinions ?

Thanks,
Bill

Couple of problems, I don't know how well the MP-RAS 3.2 is supposed to run
on Dell hardware rather than the original Teradata boxes, so I can't comment
on compatibility there. However, I do see some problems with the Informix
configuration. The Dell T410 is a dual socket motherboard and I assume if
you purchased it recently that there are at least two cores per socket (the
default processor for this box, Xeon 5620, is a four core per socket
processor).

However, your configuration shows:

MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor

MULTIPROCESSOR should be set to '1' if there are more than a single
processor core (on a single processor chip) in the machine. Otherwise
certain locks and latches will be disabled that prevent concurrent access to
shared memory structures by multiple tasks and threads which is possible if
there are more than one core. This may be the cause of the hang during
server initialization.

NOAGE 0 # Process aging

This has nothing to do with the hang at startup, and I don't know about
MP-RAS, but most UNIX based OSes are agressive about reducing the runtime
priority of long running processes and the Informix engine's oninit
processes are certainly long running by any measure. You should have NOAGE
set to '1'. The release notes files will tell you whether NOAGE is
supported on MP-RAS, but supported or not, it can't hurt to enable this
feature.

LOCKS 2000 # Maximum number of locks
BUFFERS 200 # Maximum number of shared buffers

Again, nothing to do with the hang, but, are you really configuring a
production server with only 2000 locks and 200 buffers? Only if there are
fewer than a dozen users and less than 4MB of data on disk! You REALLY
should resize these parameters to something realistic.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• IDS 7.31UD7 on MP-RAS not able to initialize
  BILL FLORENCE -- Wednesday, 16 March 2011, at 1:23 p.m.
  • Re: IDS 7.31UD7 on MP-RAS not able to initialize
    Art Kagel -- Wednesday, 16 March 2011, at 2:21 p.m.
    • Re: IDS 7.31UD7 on MP-RAS not able to initialize
      BILL FLORENCE -- Wednesday, 16 March 2011, at 3:12 p.m.
      • Re: IDS 7.31UD7 on MP-RAS not able to initialize
        BILL FLORENCE -- Wednesday, 16 March 2011, at 3:46 p.m.
        • Re: IDS 7.31UD7 on MP-RAS not able to initialize
          John Miller iii -- Wednesday, 16 March 2011, at 5:43 p.m.
          • Re: IDS 7.31UD7 on MP-RAS not able to initialize
            BILL FLORENCE -- Wednesday, 16 March 2011, at 7:38 p.m.
      • Re: IDS 7.31UD7 on MP-RAS not able to initialize
        rroussey@comcast.net -- Wednesday, 16 March 2011, at 4:37 p.m.
        • Re: IDS 7.31UD7 on MP-RAS not able to initialize
          BILL FLORENCE -- Wednesday, 16 March 2011, at 8:57 p.m.
          • Re: IDS 7.31UD7 on MP-RAS not able to initialize
            Mark Jamison -- Wednesday, 16 March 2011, at 9:27 p.m.
            • Re: IDS 7.31UD7 on MP-RAS not able to initialize
              BILL FLORENCE -- Wednesday, 16 March 2011, at 10:39 p.m.
  • Re: IDS 7.31UD7 on MP-RAS not able to initialize
    Paul Watson -- Thursday, 17 March 2011, at 11:00 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.