Using Tuxedo for Replication
Does anybody use Tuxedo for data replication. We tried to use informix replication but it created to many logical logs (20-30 gig worth in 1 days processing). My CIO had heard about Tuxedo as a possible solution. We need to replicatate 8 tables (about 4 gig worth) for a HA solution. We are running 4gl and spl programs to update the tables. Stephen
--0__=09BBE57DDFF4425E8f9e8a93df938690918c09BBE57DDFF4425E Content-type: multipart/alternative; Boundary="1__=09BBE57DDFF4425E8f9e8a93df938690918c09BBE57DDFF4425E" --1__=09BBE57DDFF4425E8f9e8a93df938690918c09BBE57DDFF4425E Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Stephen, 20-30 gig of log space per day for only 8 tables totaling 4 GB seems wa= y out of line. The only way that I can even begin to imagine how it woul= d be possible to see that much log usage would be either a massivly misconfigured system or extreamly hot rows. Did you open a case on this by any chance? If so, is there a case numb= er? Thanks M.P. = "STEPHEN SCOTT" = <dba.lumber@gmail = .com> = To Sent by: ids@iiug.org = forum.subscriber@ = cc iiug.org = Subj= ect Using Tuxedo for Replication = 04/25/2005 11:34 [4799] = AM = = = = = = Does anybody use Tuxedo for data replication. We tried to use informix= replication but it created to many logical logs (20-30 gig worth in 1 d= ays processing). My CIO had heard about Tuxedo as a possible solution. We need to replicatate 8 tables (about 4 gig worth) for a HA solution. We are running 4gl and spl programs to update the tables. Stephen = --1__=09BBE57DDFF4425E8f9e8a93df938690918c09BBE57DDFF4425E Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>Stephen,<br> <br> 20-30 gig of log space per day for only 8 tables totaling 4 GB seems wa= y out of line. The only way that I can even begin to imagine how it wo= uld be possible to see that much log usage would be either a massivly m= isconfigured system or extreamly hot rows. <br> <br> Did you open a case on this by any chance? If so, is there a case numb= er?<br> <br> Thanks<br> M.P. <br> <img src=3D"cid:10__=3D09BBE57DDFF4425E8f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "STEPHEN SCOTT= " <dba.lumber@gmail.com>">"STEPHEN SCOTT" <dba.= lumber@gmail.com><br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D09BBE57= DDFF4425E8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">"STEPHEN SCOTT" <dba.lumber@gmail.= com></font></b><font size=3D"2"> </font><br> <font size=3D"2">Sent by: forum.subscriber@iiug.org</font> <p><font size=3D"2">04/25/2005 11:34 AM</font></ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D09BBE57DDFF4425E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D09BBE57DDFF4425E8f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">ids@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D09BBE57DDFF4425E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D09BBE57DDFF4425E8f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D09BBE57DDFF4425E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D09BBE57DDFF4425E8f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">Using Tuxedo for Replication [4799]</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D09BBE57DDFF4= 425E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D09BBE57DDFF4425E8f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>Does anybody use Tuxedo for data replication. We tried to use= informix replication but it created to many logical logs (20-30 gig wo= rth in 1 days processing).<br> <br> My CIO had heard about Tuxedo as a possible solution. We need to = replicatate 8 tables (about 4 gig worth) for a HA solution.<br> <br> We are running 4gl and spl programs to update the tables.<br> <br> Stephen<br> <br> </tt><br> </body></html>= --1__=09BBE57DDFF4425E8f9e8a93df938690918c09BBE57DDFF4425E-- --0__=09BBE57DDFF4425E8f9e8a93df938690918c09BBE57DDFF4425E Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=09BBE57DDFF4425E8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=09BBE57DDFF4425E8f9e8a93df938690918c09BBE57DDFF4425E Content-type: image/gif; name="pic06676.gif" Content-Disposition: inline; filename="pic06676.gif" Content-ID: <20__=09BBE57DDFF4425E8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR M00oQAqNIstqI6qKHUsWRAE
STEPHEN SCOTT said: > Does anybody use Tuxedo for data replication. We tried to use informix > replication but it created to many logical logs (20-30 gig worth in 1 days > processing). > > My CIO had heard about Tuxedo as a possible solution. We need to > replicatate 8 tables (about 4 gig worth) for a HA solution. > > We are running 4gl and spl programs to update the tables. Yeah, sure, get your CIO to cut the code since he knows so much. <rolls eyes> -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco Travel broadens a person. You look as if you have been all over the world. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://i2.photobucket.com/albums/y41/Obnoxio/thinkIfoundtheproblem.jpg