cdr_deltab tables/sync up tables
IDS 9.4 tied to IDS 9.3 All transactions are originating on the 9.4 server and are replicated to the 9.3 server. Each table is defined as a replicant. I'm in the process of changing replicants from conflict resolution setting "Ignore" to conflict resolution "Timestamp". 1)I'm now seeing tables in my database called cdr_deltab_000xxx. I've done a google search and a documentation search in the replication guide and do not see an explanation of these tables. The person I talked to at tech support yesterday did not understand them either. He told me they would remain until I deleted all the replicants. How are these tables formed and what do I need to do to manage them? 2) What kinds of queries are you running to sync up table contents? 3) What kinds of utilities are you using to analyze the contents of the ats and ris files? TIA Dave Thacker
See below.... "Dave Thacker " <dthacker@omnicor porate.com> To Sent by: ids@iiug.org forum.subscriber@ cc iiug.org Subject cdr_deltab tables/sync up tables 10/19/2005 09:28 [5855] AM >IDS 9.4 tied to IDS 9.3 >All transactions are originating on the 9.4 server and are replicated to >the 9.3 server. Each table is defined as a replicant. >I'm in the process of changing replicants from conflict resolution >setting "Ignore" to conflict resolution "Timestamp". >1)I'm now seeing tables in my database called cdr_deltab_000xxx. I've >done a google search and a documentation search in the replication guide >and do not see an explanation of these tables. The person I talked to >at tech support yesterday did not understand them either. He told me >they would remain until I deleted all the replicants. How are these >tables formed and what do I need to do to manage them? They are refered to as delete tables. They contain a copy of the row when it is deleted. This is then used as part of conflict resolution. (i.e. which operation should win - the update or the delete) If we didn't have them, then deleted rows could reappear. You don't need to manage them. They are constantly being pruned to eliminate rows which are no longer needed. >2) What kinds of queries are you running to sync up table contents? > >3) What kinds of utilities are you using to analyze the contents of the >ats and ris files? I'm not going to answer these two because I'd really like to see the answers that folks respond with. I realize that you're not going to be on 10.x, but in 10.x we have added quite a bit of new functionality to perform these types of tasks. TIA Dave Thacker [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic19275.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif]
On Wed, 2005-10-19 at 11:11 -0500, Madison Pruet wrote: <helpful answer snipped.... Thank you> > > > >2) What kinds of queries are you running to sync up table contents? > > > >3) What kinds of utilities are you using to analyze the contents of > the > >ats and ris files? > > I'm not going to answer these two because I'd really like to see the > answers that folks respond with. > > I realize that you're not going to be on 10.x, but in 10.x we have > added quite a bit of new functionality to perform these types of > tasks. > What's the best source of documentation for those new utilities? The V10 replication manual? Are there other sources? I might find some compelling reasons to schedule my upgrade sooner. Thanks for your help. DT -- Dave Thacker, Senior Systems Administrator Omni Hotels Reservation Center V: 402.952.6535 F: 402-334-8013 M: 402-981-4613 (24/7)
Mostly in the v10 documentation. In v10, we have the ability to 1) re-try from the ATS/RIS files. Also, we are planning on enabling some additional functionality in the UC4 interim which should further enhance the ability to check for inconsistant data as well as automatically repair anything found to be inconsistant - so I think that I'll be pushing v10UC4 fairly strong for ER customers. Dave Thacker <dthacker@omnicor porate.com> To Madison Pruet/Dallas/IBM@IBMUS 10/19/2005 12:18 cc PM ids@iiug.org Subject Re: cdr_deltab tables/sync up Please respond to tables [5855] dthacker On Wed, 2005-10-19 at 11:11 -0500, Madison Pruet wrote: <helpful answer snipped.... Thank you> > > > >2) What kinds of queries are you running to sync up table contents? > > > >3) What kinds of utilities are you using to analyze the contents of > the > >ats and ris files? > > I'm not going to answer these two because I'd really like to see the > answers that folks respond with. > > I realize that you're not going to be on 10.x, but in 10.x we have > added quite a bit of new functionality to perform these types of > tasks. > What's the best source of documentation for those new utilities? The V10 replication manual? Are there other sources? I might find some compelling reasons to schedule my upgrade sooner. Thanks for your help. DT -- Dave Thacker, Senior Systems Administrator Omni Hotels Reservation Center V: 402.952.6535 F: 402-334-8013 M: 402-981-4613 (24/7) [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic20229.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif]
If you're going to the IIUG winter session in Atlanta, I'll be discussing this. Dave Thacker <dthacker@omnicor porate.com> To Madison Pruet/Dallas/IBM@IBMUS 10/25/2005 03:49 cc PM forum.subscriber@iiug.org, ids@iiug.org Subject Please respond to Re: cdr_deltab tables/sync up dthacker tables [5855] On Wed, 2005-10-19 at 11:11 -0500, Madison Pruet wrote: > See below.... <question about cdr deltabs answered and snipped...> > > >2) What kinds of queries are you running to sync up table contents? > > > >3) What kinds of utilities are you using to analyze the contents of > the > >ats and ris files? > > I'm not going to answer these two because I'd really like to see the > answers that folks respond with. There weren't many responses. Does anyone have some favorite techniques they'd like to share for handling this problem on 9.4 and below? > > I realize that you're not going to be on 10.x, but in 10.x we have > added quite a bit of new functionality to perform these types of > tasks. It looks good. I should be able to test after the first of the year... TIA Dave Thacker [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic06234.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif]