Informix

Hi Henry,

The following are some of the solutions possible.

A) On the same server, from easier and less dowtime to more complicated and more dowtime

1/ Mirroring - no downtime; if you already have mirroring in place for some of the chunks, you need to reset each individual mirrored chunk first and start mirroring again to the desired cooked file. You have to make sure the instance was intialized to be possibly mirrored (MIRROR=1)

2/ HDR - a slight dowtime ; needs some twicking to be performed because of the names of the chunks. Not as easy as mirroring

3/ Other solutions will have downtime and more complicated to perform ; such as ER, etc.

B) On a different server (virtual or physical), from simple to more complicated and more downtime

1/ HDR- a short downtime to reconnect the users. Easy to setup

2/ Others such as ER, etc

--  Cordialement, Regards,    Khaled Bentebal Directeur G??n??ral - ConsultiX T??l: 33 (0) 1 39 12 18 00 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web:  www.consult-ix.fr

Hi Henry,

The following are some of the solutions possible.

A) On the same server, from easier and less dowtime to more complicated and more dowtime

1/ Mirroring - no downtime; if you already have mirroring in place for some of the chunks, you need to reset each individual mirrored chunk first and start mirroring again to the desired cooked file. You have to make sure the instance was intialized to be possibly mirrored (MIRROR=1)

2/ HDR - a slight dowtime ; needs some twicking to be performed because of the names of the chunks. Not as easy as mirroring

3/ Other solutions will have downtime and more complicated to perform ; such as ER, etc.

B) On a different server (virtual or physical), from simple to more complicated and more downtime

1/ HDR- a short downtime to reconnect the users. Easy to setup

2/ Others such as ER, etc

--  Cordialement, Regards,    Khaled Bentebal Directeur G??n??ral - ConsultiX T??l: 33 (0) 1 39 12 18 00 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web:  www.consult-ix.fr

Art,

That is not completely true. You still had to do it up to version 14.10.xC6. Deprecated from 14.10.xC7 on

The evolution was easy to do since they only initialized the page in the reserved pages that contains the mirror chunks information (onchek -pr will shwo yhou that or a dump in hex of the 12 reserved pages in the rootdbs chunk).

Cordialement, Regards,    Khaled Bentebal Directeur Général - ConsultiX Tél: 33 (0) 1 39 12 18 00 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web:  www.consult-ix.fr

0100018ee19824d4-8688fd5a-c297-4acd-b043-158eb1a893b3-000000@email.amazonses.com">

@Khaled:  FYI, in v14.10 MIRROR is always enabled (cannot be turned off any longer) and the MIRROR parameter in the ONCONFIG file is ignored... -posted to the "Informix" group

Hi Henry,

The following are some of the solutions possible.

A) On the same server, from easier and less dowtime to more complicated and more dowtime

1/ Mirroring - no downtime; if you already have mirroring in place for some of the chunks, you need to reset each individual mirrored chunk first and start mirroring again to the desired cooked file. You have to make sure the instance was intialized to be possibly mirrored (MIRROR=1)

2/ HDR - a slight dowtime ; needs some twicking to be performed because of the names of the chunks. Not as easy as mirroring

3/ Other solutions will have downtime and more complicated to perform ; such as ER, etc.

B) On a different server (virtual or physical), from simple to more complicated and more downtime

1/ HDR- a short downtime to reconnect the users. Easy to setup

2/ Others such as ER, etc

--  Cordialement, Regards,    Khaled Bentebal Directeur G??n??ral - ConsultiX T??l: 33 (0) 1 39 12 18 00 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web:  www.consult-ix.fr