RE: cdr_deltab_000%

It is true that the rows inside the cdr_deltab_* tables get pruned. However, if you have a table that has several thousand deletes a day, the extents on these tables can make them very large even when they are empty. I have a list of tables that I know that have a lot of deletes and I routinely drop the replicate definitions, during a scheduled outage of course, to reclaim the space that those tables hold. When you re-define the replicate definition it will create a new cdr_deltab_* table for the table being replicated. -Dana Dana Carney III | Sr. Database Administrator/Team Lead | Intraware | 925-253-6554 Manage Complex Entitlements, Enhance Customer Visibility, Accelerate Profits Any transaction terms in or attached to this message are proposals and are subject to the parties' signature of a definitive written agreement. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Madison Pruet Sent: Tuesday, November 15, 2005 7:54 AM To: informix-list@iiug.org Subject: Re: cdr_deltab_000% These are the deleted row tables used by ER conflict resolution. They are automatically created when a replicate is created which is using conflict resolution, and are dropped when the last replicate on that table using conflict resolution is dropped. We constantly prune the deleteed row tables, so generally they are fairly small. "rotor" <rotor@navigator.lv> wrote in message news:dlch7l$6mr$1@news.xmission.com... > > Hi all! > > There are a lot of tables named like 'cdr_deltab_000%' in one > database. Can anybody explain, what this tables is, when and how they > are used, is it possible to drop them? > > -- > Aeqok`rm{i onwrnb{i yhj opednqr`bkem http://pasts.delfi.lv > sending to informix-list sending to informix-list