Re: Parsing LOGICAL LOG files to fake replication?

From: "Art S. Kagel" <kagel@bloomberg.net> > > > > 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.) > >Another alternative is create a UDF/UDR that can be called from triggers >that will copy the transaction details to the replication server. In fact, IIRC, someone within Informix has written something called Discrete Transaction Replication that does this for you. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com