End chunk mirror on two serves doing er

Hello: Which one is the best way to end chunk mirroring on two database servers? Maybe, end chunk mirror for root space on slave server and them on master server? And end chunk mirror for other space as final stage. Thank you. --001a113ecbee87c9c5052616cb37

I assume you are talking about an HDR or RSS secondary and its primary? You just have to drop the mirrors on the primary. The secondary will follow along. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Fri, Dec 4, 2015 at 1:37 PM, Juan Francisco González Navarro < jfrancisco.navarro@gmail.com> wrote: > Hello: > > Which one is the best way to end chunk mirroring on two database servers? > > Maybe, end chunk mirror for root space on slave server and them on master > server? > > And end chunk mirror for other space as final stage. > > Thank you. > > --001a113ecbee87c9c5052616cb37 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bd75710fc8666052616f876

Just drop (using onspaces for example) the mirror chunk on the primary, the system will do the rest for you. The actual file or raw device remains on disk of course. If you run onstat -d after dropping the mirror, you will not see the mirror chunkdisplayed any longer. It is up to you to remove the actual file/raw device (on both servers: primary and secondary. Do not forget that mirroring is per dbspace and not per chunk. If you want to remove a mirror chunk, you have to do it for all of the chunks of a dbspace. You cannot have a mirrored chunk and a not mirrored chunk within a single dbspace. However, you can have a mirrored dbspace (all of its chunks) and a not mirrored dbspace (all of its chunks). *Note*: there is a difference between diabling a mirror chunk and removing a mirror chunk. Diabling a mirror chunk is just changing a flag so that there is no writing to it (interesting in certain situations if you want to do a big load or a big UPDATE/DELETE) so your task is not penalized performance-wise. When you change the flag (chunk status) again, the system resynchronizes things for you online. You can have a DOWN chunk (chunk exists but not active) and a ONLINE chunk in a single dbspace. Removing a mirror chunk removes the chunk from the list of chunks that the informix instance sees. If you want to put it back, you have to add mirroring from scratch to that dbspace that contains one or more chunks. Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 04/12/15 19:37, a écrit : > Hello: > > Which one is the best way to end chunk mirroring on two database servers? > > Maybe, end chunk mirror for root space on slave server and them on master > server? > > And end chunk mirror for other space as final stage. > > Thank you. > > --001a113ecbee87c9c5052616cb37 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

This is If you are are using HDR of course. If you are using ER, the 2 instances are different since you are only replicating part of the database (some or part of some tables only). Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 04/12/15 20:17, Khaled Bentebal a écrit : > Just drop (using onspaces for example) the mirror chunk on the primary, > the system will do the rest for you. > The actual file or raw device remains on disk of course. If you run > onstat -d after dropping the mirror, you will not see the mirror chunk> displayed any longer. It is up to you to remove the actual file/raw > device (on both servers: primary and secondary. > > Do not forget that mirroring is per dbspace and not per chunk. If you > want to remove a mirror chunk, you have to do it for all of the chunks > of a dbspace. You cannot have a mirrored chunk and a not mirrored chunk > within a single dbspace. However, you can have a mirrored dbspace (all > of its chunks) and a not mirrored dbspace (all of its chunks). > > *Note*: there is a difference between diabling a mirror chunk and > removing a mirror chunk. > Diabling a mirror chunk is just changing a flag so that there is no > writing to it (interesting in certain situations if you want to do a > big load or a big UPDATE/DELETE) so your task is not penalized > performance-wise. When you change the flag (chunk status) again, the > system resynchronizes things for you online. You can have a DOWN chunk > (chunk exists but not active) and a ONLINE chunk in a single dbspace. > Removing a mirror chunk removes the chunk from the list of chunks that > the informix instance sees. If you want to put it back, you have to add > mirroring from scratch to that dbspace that contains one or more chunks. > > Cordialement, Regards, > > Khaled Bentebal > Directeur Général - ConsultiX > Tél: 33 (0) 1 39 12 18 00 > Fax: 33 (0) 1 39 12 18 18 > Mobile: 33 (0) 6 07 78 41 97 > Email: khaled.bentebal@consult-ix.fr > Site Web: www.consult-ix.fr > > Le 04/12/15 19:37, a écrit : >> Hello: >> >> Which one is the best way to end chunk mirroring on two database servers? >> >> Maybe, end chunk mirror for root space on slave server and them on master >> server? >> >> And end chunk mirror for other space as final stage. >> >> Thank you. >> >> --001a113ecbee87c9c5052616cb37 >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

I'm using er so may I remove mirror chunks in both servers? On 4 Dec 2015 7:50 pm, "Art Kagel" <art.kagel@gmail.com> wrote: > I assume you are talking about an HDR or RSS secondary and its primary? > You just have to drop the mirrors on the primary. The secondary will follow > along. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. 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 Fri, Dec 4, 2015 at 1:37 PM, Juan Francisco González Navarro < > jfrancisco.navarro@gmail.com> wrote: > > > Hello: > > > > Which one is the best way to end chunk mirroring on two database servers? > > > > Maybe, end chunk mirror for root space on slave server and them on master > > server? > > > > And end chunk mirror for other space as final stage. > > > > Thank you. > > > > --001a113ecbee87c9c5052616cb37 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --047d7bd75710fc8666052616f876 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --94eb2c06f0aa36c5d90526189f95

I'm using er. Regards On 4 Dec 2015 8:34 pm, "Khaled Bentebal" <khaled.bentebal@consult-ix.fr> wrote: > This is If you are are using HDR of course. > > If you are using ER, the 2 instances are different since you are only > replicating part of the database (some or part of some tables only). > > Cordialement, Regards, > > Khaled Bentebal > Directeur Général - ConsultiX > Tél: 33 (0) 1 39 12 18 00 > Fax: 33 (0) 1 39 12 18 18 > Mobile: 33 (0) 6 07 78 41 97 > Email: khaled.bentebal@consult-ix.fr > Site Web: www.consult-ix.fr > > Le 04/12/15 20:17, Khaled Bentebal a écrit : > > Just drop (using onspaces for example) the mirror chunk on the primary, > > the system will do the rest for you. > > The actual file or raw device remains on disk of course. If you run > > onstat -d after dropping the mirror, you will not see the mirror chunk> > displayed any longer. It is up to you to remove the actual file/raw > > device (on both servers: primary and secondary. > > > > Do not forget that mirroring is per dbspace and not per chunk. If you > > want to remove a mirror chunk, you have to do it for all of the chunks > > of a dbspace. You cannot have a mirrored chunk and a not mirrored chunk > > within a single dbspace. However, you can have a mirrored dbspace (all > > of its chunks) and a not mirrored dbspace (all of its chunks). > > > > *Note*: there is a difference between diabling a mirror chunk and > > removing a mirror chunk. > > Diabling a mirror chunk is just changing a flag so that there is no > > writing to it (interesting in certain situations if you want to do a > > big load or a big UPDATE/DELETE) so your task is not penalized > > performance-wise. When you change the flag (chunk status) again, the > > system resynchronizes things for you online. You can have a DOWN chunk > > (chunk exists but not active) and a ONLINE chunk in a single dbspace. > > Removing a mirror chunk removes the chunk from the list of chunks that > > the informix instance sees. If you want to put it back, you have to add > > mirroring from scratch to that dbspace that contains one or more chunks. > > > > Cordialement, Regards, > > > > Khaled Bentebal > > Directeur Général - ConsultiX > > Tél: 33 (0) 1 39 12 18 00 > > Fax: 33 (0) 1 39 12 18 18 > > Mobile: 33 (0) 6 07 78 41 97 > > Email: khaled.bentebal@consult-ix.fr > > Site Web: www.consult-ix.fr > > > > Le 04/12/15 19:37, a écrit : > >> Hello: > >> > >> Which one is the best way to end chunk mirroring on two database > servers? > >> > >> Maybe, end chunk mirror for root space on slave server and them on > master > >> server? > >> > >> And end chunk mirror for other space as final stage. > >> > >> Thank you. > >> > >> --001a113ecbee87c9c5052616cb37 > >> > >> > >> > > > > ******************************************************************************* > >> 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. > > --001a113ecbeecabe8c052618a08c

Yes. Art On Dec 4, 2015 3:48 PM, "Juan Francisco González Navarro" < jfrancisco.navarro@gmail.com> wrote: > I'm using er so may I remove mirror chunks in both servers? > On 4 Dec 2015 7:50 pm, "Art Kagel" <art.kagel@gmail.com> wrote: > > > I assume you are talking about an HDR or RSS secondary and its primary? > > You just have to drop the mirrors on the primary. The secondary will > follow > > along. > > > > Art > > > > Art S. Kagel, President and Principal Consultant > > ASK Database Management > > www.askdbmgt.com > > > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on the IIUG, nor any other organization with which I > am > > associated either explicitly, implicitly, or by inference. 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 Fri, Dec 4, 2015 at 1:37 PM, Juan Francisco González Navarro < > > jfrancisco.navarro@gmail.com> wrote: > > > > > Hello: > > > > > > Which one is the best way to end chunk mirroring on two database > servers? > > > > > > Maybe, end chunk mirror for root space on slave server and them on > master > > > server? > > > > > > And end chunk mirror for other space as final stage. > > > > > > Thank you. > > > > > > --001a113ecbee87c9c5052616cb37 > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --047d7bd75710fc8666052616f876 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --94eb2c06f0aa36c5d90526189f95 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0116075696aec9052618eb2d