IDS Forum

Re: Problem with dbexport

Posted By: Art Kagel
Date: Wednesday, 3 October 2012, at 11:03 a.m.

In Response To: Re: Problem with dbexport (Jonathan Leffler)

Gustavo:

I'm going to have to agree with Jonathan. Unless you have recently
replaced all of your drives, then #1 you are at severe risk of a hard disk
crash as the drive(s) must be long past their MTBF rating, #2 the
filesystem you are using for the server chunks is probably being shared
with Windows which is slowing things down, #3 the Informix version you are
running is from circa 1999 or maybe earlier.

I would a) Get a new server machine, say an x86/64 machine running Linux
and b) Upgrade your server on the new machine to the latest release
(11.70.FC5W2 IB). Talk to an IBM salesperson or a competent IBM partner
(like me ;-) who is familiar with the Informix product line about licensing
options. Today's systems are so much more powerful than what you probably
bought in 1999 that relicensing with a current release may be very
reasonable.

Direct to your checkpoint problem: Long checkpoints are a problem in
Informix 7.xx that was finally solved in v11.10 and later releases with
non-blocking checkpoint technology. There are ways to tune your instance
to reduce the impact and duration of checkpoints. I would suggest that you
get a server HealthCheck from an experienced Informix consultancy. A
couple of choices are: Advanced DataTools Corp. for which I work, Oninit
US, XTivia, Oninit UK, and Ardenta in the UK come quickly to mind though
there are others out there.

I have to wonder why you are performing (or attempting to anyway) a
dbexport every week. For backup purposes you should be using ontape or
onbar instead neither of which will lock the databases like dbexport does
and will allow you to make archives even daily without affecting users in
any way.

Art

Art

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

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

On Wed, Oct 3, 2012 at 10:24 AM, Jonathan Leffler <
jonathan.leffler@gmail.com> wrote:

> On Wed, Oct 3, 2012 at 7:13 AM, GUSTAVO ECHENIQUE <
> gustavo.echenique@cemdo.com.ar> wrote:
>
> > I'm Sorry Art, I forgot this information. The Informix is an IDS 7.31
> TD6,
> > and
> > the platform is a Windows 2000 Advanced Server.
> >
>
> It's trying to tell you "I'm old and decrepit and want to be retired"...
>
> --
> Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org
> "Blessed are we who can laugh at ourselves, for we shall never cease to be
> amused."
>
> --20cf306f7e38cb0f2104cb28631b
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--e89a8f23585fc62cfc04cb28f1b1

Messages In This Thread

• Problem with dbexport
  GUSTAVO ECHENIQUE -- Wednesday, 3 October 2012, at 9:12 a.m.
  • Re: Problem with dbexport
    Art Kagel -- Wednesday, 3 October 2012, at 9:42 a.m.
    • Re: Problem with dbexport
      GUSTAVO ECHENIQUE -- Wednesday, 3 October 2012, at 10:13 a.m.
      • Re: Problem with dbexport
        Jonathan Leffler -- Wednesday, 3 October 2012, at 10:24 a.m.
        • Re: Problem with dbexport
          Art Kagel -- Wednesday, 3 October 2012, at 11:03 a.m.
  • Re: Problem with dbexport
    Jonathan Leffler -- Wednesday, 3 October 2012, at 10:22 a.m.
  • Re: Problem with dbexport
    FRANK J. COMPUTER -- Wednesday, 17 October 2012, at 11:52 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.