Actions That Do Not Replicate in HDR???
Hello Folks, O/S AIX 6.1 IDS 11.70.FC8 I know there is a short ist of things/actions that do not play well with HDR. Does anyone have a list of such things? Thanx, Dan
Short indeed: - Dumb Blobs (BYTE & TEXT) stored in blobspaces (ie not IN TABLE) - Smart Blobs (BLOB & CLOB) stored in unlogged smart blobspaces (they are logged by default) - All data in an unlogged database - Any table in a logged database that is MODE(RAW) 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 Tue, Feb 17, 2015 at 10:00 AM, DAN MUELLER <ddmueller@intercall.com> wrote: > Hello Folks, > > O/S AIX 6.1 > IDS 11.70.FC8 > > I know there is a short ist of things/actions that do not play well with > HDR. > Does anyone have a list of such things? > > Thanx, > Dan > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0158c026705dcb050f4a262f
Thanx Art, Aren't there some alters that will not go across as well? Dan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Tuesday, February 17, 2015 10:14 AM To: ids@iiug.org Subject: Re: Actions That Do Not Replicate in HDR??? [34692] Short indeed: - Dumb Blobs (BYTE & TEXT) stored in blobspaces (ie not IN TABLE) - Smart Blobs (BLOB & CLOB) stored in unlogged smart blobspaces (they are logged by default) - All data in an unlogged database - Any table in a logged database that is MODE(RAW) 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 Tue, Feb 17, 2015 at 10:00 AM, DAN MUELLER <ddmueller@intercall.com> wrote: > Hello Folks, > > O/S AIX 6.1 > IDS 11.70.FC8 > > I know there is a short ist of things/actions that do not play well > with HDR. > Does anyone have a list of such things? > > Thanx, > Dan > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0158c026705dcb050f4a262f ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Except for altering to or from an unlogged column type? I cannot think of any. In-place alters do not affect the secondary immediately except to change a flag on the table's partition header page, but as pages are actually updated to the new schema those changes are logged and soreplicated. There are two ways for a secondary to handle index builds, depending on an ONCONFIG parameter, but both methods are logged. 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 Tue, Feb 17, 2015 at 10:24 AM, Mueller, Daniel D. < ddmueller@intercall.com> wrote: > Thanx Art, > > Aren't there some alters that will not go across as well? > > Dan > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art > Kagel > Sent: Tuesday, February 17, 2015 10:14 AM > To: ids@iiug.org > Subject: Re: Actions That Do Not Replicate in HDR??? [34692] > > Short indeed: > > - Dumb Blobs (BYTE & TEXT) stored in blobspaces (ie not IN TABLE) > > - Smart Blobs (BLOB & CLOB) stored in unlogged smart blobspaces (they > > are logged by default) > > - All data in an unlogged database > > - Any table in a logged database that is MODE(RAW) > > 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 Tue, Feb 17, 2015 at 10:00 AM, DAN MUELLER <ddmueller@intercall.com> > wrote: > > > Hello Folks, > > > > O/S AIX 6.1 > > IDS 11.70.FC8 > > > > I know there is a short ist of things/actions that do not play well > > with HDR. > > Does anyone have a list of such things? > > > > Thanx, > > Dan > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e0158c026705dcb050f4a262f > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01419f68b02203050f4a6c1e