IDS Forum

RE: RE: Re: DDL with HDR

Posted By: Marcus Haarmann
Date: Monday, 18 June 2007, at 8:53 a.m.

In Response To: RE: Re: DDL with HDR (Madison Pruet)

Sure, but this works with IDS 10.

Marcus

-----Original Message-----
From: Madison Pruet [mailto:mpruet@us.ibm.com]
Sent: Monday, June 18, 2007 2:43 PM
To: ids@iiug.org
Subject: RE: Re: DDL with HDR [9389]

As long as the changes don't cause the log file to wrap. ;-)

Seriously though -- the time that it takes to convert the HDR secondary=
to an RSS node and vice versa is just about the same time that it takes
t= o bring down and back up the HDR secondary. And that approch would
have = the advantage that when the secondary is reconverted back to the
HDR second= ary, then it would be caught up with the primary. By
bouncing the HDR secondary, you would still have to spend some time
getting caught back = up.

M.P.

=

"Marcus Haarmann" =

<marcus.haarmann@ =

midoco.de> =
To

Sent by: ids@iiug.org =

ids-bounces@iiug. =
cc

org =

Subj=
ect

RE: Re: DDL with HDR [9388] =

06/18/2007 03:04 =

AM =

=

=

Please respond to =

ids@iiug.org =

=

=

Hi,

I would suggest to stop HDR (shutdown secondary server) while doing the=

structural changes.
This should force the primary server to react without these locks.
After restart of the secondary the instance will apply the changes from=

the logs.
I remember we had these problems once and I think this was the solution=

we used to prevent the errors.

E.G. a alter table and creation of a foreign key afterwards did fail
because the secondary server has not created the table successfully.

Hope this helps.

Marcus

-----Original Message-----
From: Madison Pruet [mailto:mpruet@us.ibm.com]
Sent: Monday, June 18, 2007 1:28 AM
To: ids@iiug.org
Subject: Re: DDL with HDR [9387]

In IDS11, we have introduced the RSS node (Remote Standalone Secondary)=
=3D

which is much like the HDR secondary, except it is totally running in a=
=3D n ASYNC mode and uses a fully duplexed TCP interface. This should
speed=

=3D up the process.

As anyone working with networking will tell you - you can push more dat=
=3D a through a fully-duplexed connection than a half-duplexed because
of all=3D of the ACKs which are required before the source can send the
ne= xt message=3D ..

One thing which might be possible would be to convert the HDR connectio=
=3D n into an RSS connection while the upgrade is underway and then
reconvert=3D the RSS secondary into an HDR secondary once the upgrade i=
s complete. To perform the conversion is a couple of onmode commands and
it is doable online (takes just a few seconds.)

=3D

"STACEY VERNER" =3D

<stacey@cjntech.c =3D

o.nz> =3D
To

Sent by: ids@iiug.org =3D

ids-bounces@iiug. =3D
cc

org =3D

Subj=3D
ect

Re: DDL with HDR [9386] =3D

06/17/2007 05:59 =3D

PM =3D

=3D

=3D

Please respond to =3D

ids@iiug.org =3D

=3D

=3D

Yes. It fails on:
- create index
- alter table add constraint

If we increase the timeout then it will probably work, but it will take=
=3D a long time to run. Without HDR an upgrade takes 5-10 minutes
(dependin= g on th=3D e size of the database). With HDR it is getting
about 1/3 of t= he way through a=3D nd taking nearly an hour to get
there, which would thi= s very time consumin=3D g.

DBImport does nothave this problem. It seems to delay the mirroring pro=
=3D cess

until after the whole import completes.

We'll be testing our software on Informix 11 fairly soon so we'll see i=
=3D f it

has been sorted.

Thanks

Stacey

***********************************************************************=
=3D
********

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

=3D

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

***********************************************************************=
********

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

• DDL with HDR
  STACEY VERNER -- Sunday, 17 June 2007, at 5:39 p.m.
  • Re: DDL with HDR
    Madison Pruet -- Sunday, 17 June 2007, at 5:55 p.m.
    • Re: DDL with HDR
      STACEY VERNER -- Sunday, 17 June 2007, at 6:59 p.m.
      • Re: DDL with HDR
        Madison Pruet -- Sunday, 17 June 2007, at 7:28 p.m.
        • RE: Re: DDL with HDR
          Marcus Haarmann -- Monday, 18 June 2007, at 4:04 a.m.
          • RE: Re: DDL with HDR
            Madison Pruet -- Monday, 18 June 2007, at 8:42 a.m.
            • RE: RE: Re: DDL with HDR
              Marcus Haarmann -- Monday, 18 June 2007, at 8:53 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.