Informix 10 on HPUX 11.11
A user running IDS 10 on HP-UX 11.11 found that a dbimport (into dbspaces on mirrored external storage) made the server grab all available memory and produced checkpoints lasting ~400 seconds, far worse than on an older, similar machine. Replies asked whether logging was on (it wasn't; the command was plain 'dbimport logix -d prd'), suggested forcing frequent checkpoints with a background loop of 'onmode -c', and recommended comparing ONCONFIG settings on the two servers — notably a larger buffer pool and LRU min/max settings that delay flushing dirty pages to disk. The original poster never reported back, so no confirmed resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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.
Anybody?
Thanks a lot,
André Luiz
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.
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.
>
are you performing the import with logging on? if so, try the import
without the -l option.
can you send us the dbimport statement?
=
"Andr=C3=A9 Luiz =
Rufino" =
<andre_rufino@msn =
To
.com> ids@iiug.org =
Sent by: =
cc
ids-bounces@iiug. =
org Subj=
ect
Informix 10 on HPUX 11.11 [7442]=
=
09/08/2006 12:30 =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
Ladies and Gentleman,
I have a situation. I tried to make a dbimport on HPUX server. The dbsp=
aces
are located in a external storage. The HPUX server, once the dbimport h=
as
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.
Anybody?
Thanks a lot,
Andr=E9 Luiz
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
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.
dbimport logix -d prd
>From: "Darren_Jacobs@carmax.com" <Darren_Jacobs@carmax.com>
>Reply-To: ids@iiug.org
>To: ids@iiug.org
>Subject: Re: Informix 10 on HPUX 11.11 [7445]
>Date: Fri, 8 Sep 2006 13:11:34 -0400 (EDT)
>
>are you performing the import with logging on? if so, try the import
>without the -l option.
>
>can you send us the dbimport statement?
>
>=
>
>"Andr=C3=A9 Luiz =
>
>Rufino" =
>
><andre_rufino@msn =
>To
>
>..com> ids@iiug.org =
>
>Sent by: =
>cc
>
>ids-bounces@iiug. =
>
>org Subj=
>ect
>
>Informix 10 on HPUX 11.11 [7442]=
>
>=
>
>09/08/2006 12:30 =
>
>PM =
>
>=
>
>=
>
>Please respond to =
>
>ids@iiug.org =
>
>=
>
>=
>
>Ladies and Gentleman,
>
>I have a situation. I tried to make a dbimport on HPUX server. The dbsp=
>aces
>
>are located in a external storage. The HPUX server, once the dbimport h=
>as
>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.
>
>Anybody?
>
>Thanks a lot,
>
>Andr=E9 Luiz
>
>***********************************************************************=
>********
>
>Forum Note: Use "Reply" to post a response in the discussion forum.
>
>=
>
>
>*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Forget about the -n option ... was thinking of dbload I guess :)
The rest of the information still applies.
Take care.
Clifton
-----Original Message-----
From: Clifton Bean [mailto:cbean@ctm.com]
Sent: Friday, September 08, 2006 12:27 PM
To: 'ids@iiug.org'
Subject: RE: Informix 10 on HPUX 11.11 [7444]
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.