IDS Forum

RE: Schema Changes on HDR Secondary in 9.4

Posted By: Simmons, Keith
Date: Thursday, 9 March 2006, at 2:40 p.m.

In Response To: Re: Schema Changes on HDR Secondary in 9.4 (CHRISTOPHER COLEMAN)

Christopher

It really all depends on what schema changes you need. Alter table to
add or remove columns now happens immediately (if you can get 2 seconds
exclusive access) and many column type changes can happen immediately.
However connected programs will terminate if they encounter a changed
table!
Index builds under 10 no longer require exclusive access, they can
happen on-line.

Keith

-----Original Message-----
From: CHRISTOPHER.... [mailto:christopher.coleman@mediware.com]
Sent: Wednesday, March 08, 2006 11:38 PM
To: ids@iiug.org
Subject: Re: Schema Changes on HDR Secondary in 9.4 [6484]

Here is information we received from IBM. Remember my disclaimer?

I did some additional research and it turns out that HDR will not

work for what we discussed. ER in IDS 10.0 with the Schema Evolution

feature is a possibility, however I need to have a deeper

conversation with R&D about it. I'll dig in a bit deeper for you

over the next few days.

It turns out that I was confusing the Schema Evolution feature of ER

with HDR, so I do apologize. Schema Evolution replicates schema

changes, but the thing I need to research is whether or not you can

break the replication to perform the upgrades, then resync. There

are a couple of questions I have such as whether or not Schema

Evolution is required for your situation. It may be that the regular

ER in IDS 9.40 would work fine, but as I said I need to dig a little

deeper.

So, this is why we check, even when we hear something from the vendor.

Anyone know a good way to alter schemas with 0 downtime?

Sincerely,

Christopher Coleman

Steering Committee President
Kansas City Informix Users Group
www.iiug.org/kciug

Database Analyst
Pharmacy Division
Mediware Information Systems, Inc.

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

**********************************************************************************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
**********************************************************************************

Messages In This Thread

• Schema Changes on HDR Secondary in 9.4
  Christopher Coleman -- Monday, 6 March 2006, at 6:12 p.m.
  • Re: Schema Changes on HDR Secondary in 9.4
    Tim Kelley -- Wednesday, 8 March 2006, at 10:30 a.m.
  • Re: Schema Changes on HDR Secondary in 9.4
    Marco Greco -- Wednesday, 8 March 2006, at 10:46 a.m.
    • Re: Schema Changes on HDR Secondary in 9.4
      CHRISTOPHER COLEMAN -- Wednesday, 8 March 2006, at 10:59 a.m.
      • Re: Schema Changes on HDR Secondary in 9.4
        CHRISTOPHER COLEMAN -- Wednesday, 8 March 2006, at 6:37 p.m.
        • RE: Schema Changes on HDR Secondary in 9.4
          Simmons, Keith -- Thursday, 9 March 2006, at 2:40 p.m.
  • Re: Schema Changes on HDR Secondary in 9.4
    Karl Ostner -- Thursday, 9 March 2006, at 3:21 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.