Question
--------------C064AA6EE2CF3D83DF1E7337 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello all, We have set-up, and are currently testing, our Informix High-Availabilty Data Replication using two servers (primary and secondary). So far, we have successfully tested creating dbspaces, databases, loading and updating data. However, we cannot seem to replicate BLOBS from our primary to our secondary server. Informix books explain that "modifications to data within blobspaces are not replicated as part of normal high availability data-replication processing. Only TEXT or BYTE data within dbspaces is replicated". We would like to know if there is a work-around to this limitation and if there is none, is there another method to replicate these databases to another server? BTW, we are using Informix version 7.30 and 7.31. -- Regards, -- Arnel Cueto -- acueto@apme-ops.dhl.com --------------C064AA6EE2CF3D83DF1E7337 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <TT>Hello all,</TT><TT></TT> <P><TT> We have set-up, and are currently testing, our Informix High-Availabilty Data Replication using two servers (primary and secondary). So far, we have successfully tested creating dbspaces, databases, loading and updating data. However, we cannot seem to replicate BLOBS from our primary to our secondary server. Informix books explain that "modifications to data within blobspaces are not replicated as part of normal high availability data-replication processing. Only TEXT or BYTE data within dbspaces is replicated". We would like to know if there is a work-around to this limitation and if there is none, is there another method to replicate these databases to another server? BTW, we are using Informix version 7.30 and 7.31.</TT><TT></TT> <P><TT>-- Regards,</TT> <BR><TT>-- Arnel Cueto</TT> <BR><TT>-- acueto@apme-ops.dhl.com</TT></HTML> --------------C064AA6EE2CF3D83DF1E7337--
Arnel CUETO ha scritto nel messaggio <9583jm$pfq$1@news.xmission.com>... > > >--------------C064AA6EE2CF3D83DF1E7337 >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >Hello all, > > We have set-up, and are currently testing, our Informix >High-Availabilty Data Replication using two servers (primary and >secondary). So far, we have successfully tested creating dbspaces, >databases, loading and updating data. However, we cannot seem to >replicate BLOBS from our primary to our secondary server. Informix books >explain that "modifications to data within blobspaces are not replicated >as part of normal high availability data-replication processing. Only >TEXT or BYTE data within dbspaces is replicated". We would like to know >if there is a work-around to this limitation and if there is none, is >there another method to replicate these databases to another server? >BTW, we are using Informix version 7.30 and 7.31. > very STRANGE: AFAIK BLOB datatype (also called "smartblob") is available only in IDS9.21 and, in that case, there seem to be NO WORKAROUND (as written in the release notes) flavio gattari >-- Regards, >-- Arnel Cueto >-- acueto@apme-ops.dhl.com > >--------------C064AA6EE2CF3D83DF1E7337 >Content-Type: text/html; charset=us-ascii >Content-Transfer-Encoding: 7bit > ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> ><HTML> ><TT>Hello all,</TT><TT></TT> ><P><TT> We have set-up, and are currently testing, our >Informix High-Availabilty Data Replication using two servers (primary and >secondary). So far, we have successfully tested creating dbspaces, databases, >loading and updating data. However, we cannot seem to replicate BLOBS from >our primary to our secondary server. Informix books explain that "modifications >to data within blobspaces are not replicated as part of normal high availability >data-replication processing. Only TEXT or BYTE data within dbspaces is >replicated". We would like to know if there is a work-around to this limitation >and if there is none, is there another method to replicate these databases >to another server? BTW, we are using Informix version 7.30 and 7.31.</TT><TT></TT> ><P><TT>-- Regards,</TT> ><BR><TT>-- Arnel Cueto</TT> ><BR><TT>-- acueto@apme-ops.dhl.com</TT></HTML> > >--------------C064AA6EE2CF3D83DF1E7337-- >
The simplest workaround is to move your blob data into a dbspace. Rudy Arnel CUETO <acueto@apme-ops.dhl.com> wrote in message > We have set-up, and are currently testing, our Informix > High-Availabilty Data Replication using two servers (primary and > secondary). So far, we have successfully tested creating dbspaces, > databases, loading and updating data. However, we cannot seem to > replicate BLOBS from our primary to our secondary server. ...