Actions That Do Not Replicate in HDR???
Dan Mueller asked what does not replicate in HDR on IDS 11.70.FC8. Art Kagel listed: BYTE/TEXT in blobspaces, smart blobs in unlogged smartblobspaces, all data in unlogged databases, and RAW tables in logged databases. Asked about alters, he said he could not think of any problem apart from altering to or from an unlogged column type; index builds are logged either way.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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