The lovely Terri Gerber, who has for the last year been leading the Informix Channel Sales team has been promoted to lead a newly formed Informix Worldwide sales team. Barbara Benis will be in charge of Direct Sales within this team and the excellent Gary Proctor will be taking over the Channel Sales.

While I'll be sorry to see Gary crossing over to the Dark Side (sales), at least we'll continue to work in the same team.

Everyone in the Informix team in IBM sees this as a great development and a sign of IBM's ever-growing support for Informix.

I'm delighted to offer my congratulations to them all and to point out that beers are on them next time we meet!

Davorin wrote:

OK Spokey,

you asked for it! :)

We have 3 tables of significant size, whatever that might mean, let's just assume it takes some time to build FK's and underlying indexes.

tab1: col11 (PK)
tab2: col21, col22
tab3: col31, col32, col33

Initially we only have primary key on tab1.col11.
At one point in time we want to add two foreign keys, one on tab2.col21 and another on tab3.col31, both referencing tab1.col11. Let's also assume no apps are connected to the instance/database we work with.
Now, to save time we want to build FK's in parallel so we kick of two separate scripts, one to build a FK on tab2 and another one to build it on tab3.

IBM has recently released a new RedBook, called "Informix Dynamic Server 11: Extending Availability and Replication"

It looks to be a comprehensive review, covering:

Preparing the technical infrastructure
High availability data replication
HDR: Advanced use scenarios
Remote Standalone Secondary servers
Shared Disk Secondary servers
Updatable Secondary servers
Connection management in an IDS cluster environment
Enterprise Replication
Instantiating Enterprise Replication
Making changes in Enterprise Replication