IDS Forum

RE: Informix 10 on HPUX 11.11

Posted By: Clifton Bean
Date: Friday, 8 September 2006, at 1:21 p.m.

In Response To: Re: Informix 10 on HPUX 11.11 (André Luiz Rufino)

If you so desire, you can run this in the background while you are
performing your import (you are using the -n argument, right?):

while 1

do

onmode -c

sleep 30 # or whatever you wish

done

In the long-term, you might want to compare your ONCONFIG files. You may
have a larger BUFFER pool available on your "new" machine, "preventing" the
instance from writing the buffer contents to disk until the end. You also
might want to look at your LRU settings, making them smaller so that writes
to disk occur more frequently.

Take care.
Clifton

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of André
Luiz Rufino
Sent: Friday, September 08, 2006 12:11 PM
To: ids@iiug.org
Subject: Re: Informix 10 on HPUX 11.11 [7444]

The dbimport process is been made without logging. I got a identical server,

but less processors. The same mirror is working very well. Hte customer
wants to chance the server because he got a processors bottleneck. We made a

lot of dbimport on the old server and, yes is is slow, but it never made a
400 checkpoint duration operation.

André Luiz

>From: "Obnoxio The Clown" <obnoxio@serendipita.com>
>Reply-To: ids@iiug.org
>To: ids@iiug.org
>Subject: Re: Informix 10 on HPUX 11.11 [7443]
>Date: Fri, 8 Sep 2006 12:33:34 -0400 (EDT)
>
>André Luiz Rufino said:
> >
> > Ladies and Gentleman,
> >
> > I have a situation. I tried to make a dbimport on HPUX server. The
> > dbspaces
> > are located in a external storage. The HPUX server, once the dbimport
>has
> > been started, alocate all memory as it can. And the checkpoint duration
>is
> > absurd (400 seconds). The external storage have two physical disks and
> > they
> > are mirrored.
>
>Do the dbimport without logging. What's absurd about a 400 second
>checkpoint? How often are you going to do a dbimport anyway?
>
>--
>Bye now,
>Obnoxio
>
>"... no bill is required as no value was provided."
>-- Christine Normile
>
>--
>This message has been scanned for viruses and
>dangerous content by OpenProtect(http://www.openprotect.com), and is
>believed to be clean.
>
>

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

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

Messages In This Thread

• Informix 10 on HPUX 11.11
  André Luiz Rufino -- Friday, 8 September 2006, at 12:30 p.m.
  • Re: Informix 10 on HPUX 11.11
    Obnoxio The Clown -- Friday, 8 September 2006, at 12:33 p.m.
    • Re: Informix 10 on HPUX 11.11
      André Luiz Rufino -- Friday, 8 September 2006, at 1:10 p.m.
      • RE: Informix 10 on HPUX 11.11
        Clifton Bean -- Friday, 8 September 2006, at 1:21 p.m.
      • FW: Informix 10 on HPUX 11.11
        Clifton Bean -- Friday, 8 September 2006, at 1:37 p.m.
  • Re: Informix 10 on HPUX 11.11
    Darren_Jacobs@carmax.com -- Friday, 8 September 2006, at 1:11 p.m.
    • Re: Informix 10 on HPUX 11.11
      André Luiz Rufino -- Friday, 8 September 2006, at 1:27 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.