IDS Forum

Re: Re: Informix HADR - Add new Database

Posted By: Art Kagel
Date: Thursday, 13 August 2009, at 9:58 a.m.

In Response To: Re: Re: Informix HADR - Add new Database (Lloyd S)

Are any of your tables larger than 2GB? If not, then you should be OK if
you are discarding the logical logs during the load or have them backing up
continuously as they fill either using ontape -c or through the
ALARMPROGRAM.

Art

Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. 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, Aug 12, 2009 at 12:22 PM, Lloyd S <lloyd_s@rediffmail.com> wrote:

> I am going to used dbexport/onunload copy to create the database, now if
> give
> the -l option it will fill up the logical logs and go into long
> transaction. I
> have a 10gb database and a 2gb logspace, will that hold without any errors.
>
> On Wed, 12 Aug 2009 21:46:09 +0530 wrote
> >Sorry to be pedantic, but DB2 has HADR. IDS has HDR.
>
> The question I have for you is why did you not create the database with
> logging in the first place? eg
>
> Create database with logging
>
> Lloyd S wrote:
> > Hello All,
> >
> > I have IDS 11.5 on Hpunix, HADR has been setup. I want to add a new
> database
> > with unbuffered logging, whenever i try to use ontape or ondblog commands
> i
> > get the below error - Error changing logging status - 'test'. iserrno
> 188,
> > which means ISAM error: Cannot add transaction logging on a DR primary
> with
> DR
> > on.
> > Is there a way i can add a database without bringing HADR down, if not
> can
> you
> > please give me the steps to be run on primary/secondary server.
> > I think we need to make it to standard mode and create the database and
> then
> > again set it back.
> > Please advise.
> >
> > Regards,
> > lloyd
>
> Sorry to be pedantic, but DB2 has HADR. IDS has HDR (HADR being several
> years
> behind HDR in terms of functionality).
>
> The question I have for you is why did you not create the database with
> logging in the first place? eg
>
> create database with log;
>
> That would have done the trick for you quite happily.
> This said there's a very good reason why the engine doesn't let you change
> logging mode with HDR active: since the database is not logged,
> transactions
> are not passed to the secondary and therefore the secondary is not
> consistent
> with the primary. If you were allowed to turn logging on, the logical log
> records pertaining to that database might be related to rows that had been
> changed on the primary only - the net result would be that the secondary
> would
> be unable to apply said log records, and spend it's time AF'ing.
> The only clean way to do it is the way the engine is asking you to.
>
> In a similar vein, even without hdr, if you turn on logging on a database,
> you
> have to take an archive before you are allowed to write to it. If this
> requirement wasn't enforced, you restored from a previous archive, and
> tried
> to rollforward the logs, you'd get rollforward failures, which wouldn't
> leave
> your database in a nice shape.
>
> Have you considered reading the manual?
>
> --
> Ciao,
> Marco
>
> ______________________________________________________________________________
> Marco Greco /UK /IBM Standard disclaimers apply!
>
> Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
> 4glworks http://www.4glworks.com
> Informix on Linux http://www.4glworks.com/ifmxlinux.htm
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--0023545bcfe080ae050471065554

Messages In This Thread

• Informix HADR - Add new Database
  Lloyd S -- Wednesday, 12 August 2009, at 12:03 p.m.
  • RE: Informix HADR - Add new Database
    Everett Mills -- Wednesday, 12 August 2009, at 12:11 p.m.
    • FW: RE: Informix HADR - Add new Database
      Everett Mills -- Wednesday, 12 August 2009, at 12:23 p.m.
      • RE: RE: Informix HADR - Add new Database
        PROC Tapia La Torre Pedro -- Wednesday, 12 August 2009, at 12:34 p.m.
      • Re: FW: RE: Informix HADR - Add new Database
        Prasad Mujumdar -- Wednesday, 12 August 2009, at 1:05 p.m.
  • Re: Informix HADR - Add new Database
    Marco Greco -- Wednesday, 12 August 2009, at 12:17 p.m.
    • Re: Re: Informix HADR - Add new Database
      Lloyd S -- Wednesday, 12 August 2009, at 12:22 p.m.
      • Re: Re: Informix HADR - Add new Database
        Art Kagel -- Thursday, 13 August 2009, at 9:58 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.