Re: Parsing LOGICAL LOG files to fake replication?

I couldn't decide if you were being goosed repeatedly while typing this or if the words in all caps were supposed to be KEYWORDS. --- Keith L Morris <keith.l.morris@wcom.com> > wrote: >I am currently working on a large data warehouse project that introduced >it's own "replication" several years ago. (Before Enterprise >Replication became available.) > >I'd LIKE to replace this with Enterprise Replication. > >We currently run 9.20uc3x4 (?) here. HOWEVER, after some benchmarking >on some new E10000 (SunOS) that we are buying, it was determined that >Enterprise Replication will not work for this project. (There >apparently IS a problem with Enterprise Replication that Informix, as >usual, has promised that the NEXT release will fix.) > >I can't wait. I CAN try to make an intermediate step that will get us >halfway there. > >CURRENTLY when the client application does an insert/update/delete it >sends data to a central "Replication" program that will then QUERY the >database and put the new or changed record into a flat file for >transmission to other groups that may have different architectures >and/or databases. (The central Replication server is used so the >ORDER in the file will be correct.) > >I DON"T LIKE THIS. There are TWO transactions for EVERY "real" >transaction. (The middle man queries the database to get the data.... >it is NOT sent from the client... only the key is sent.) > >===================================== >BUT I HAVE A NEW IDEA AND A QUESTION: >===================================== > >CAN I GRAB THE LOGICAL LOG FILES AND RUN THEM THROUGH A >PROPRIETARY PARSER, EXTRACTING THE CHANGES TO THE TABLES THAT I NEED? > >I don't see any reason that I SHOULDN'T be able to do this..... but I >thought I'd ask the question here... somebody else may have done this >before and maybe I can get some ideas. > >(This method would allow me to cut out all of the code from the client >applications that is in place for this "Replicatin" method. Then IF and >when Enterprise Replication gets to working correctly.... we can use >that.) > > >Thanks for any ideas, >---klm == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net