Re: Parsing LOGICAL LOG files to fake replication?

From: Keith L Morris <keith.l.morris@wcom.com> > >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? And you don't like the other idea? Man, I was with all the way, until I read this bit. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com