Madison Pruet wrote:
> Pete wrote:
>> We had to "brute force" kill ER tables and rebuild awhile back (per
>> Informix sup****t).
>>
>> I see that there are some "orphan" cdr_deltab_xxxx tables left around
>> that actually "hang" dbschema when it is run on them.
>>
>> My question is... can these tables be manually deleted without
>> cra****ng either the engine or ER?
>
> Yes - if you do it very carefully.....
>
> In the syscdr database, you need to examine the deltabdef table. The
> tabname, owner, and dbname are the names of the table that the delete
> table is a shadow of. The deltabid is the number ****tion of the delete
> tabe id. (the # part of cdr_deltab_######). The orphans can be
> identified by comparing the number part of cdr_del_###### with the
> deltabid within the deltabdef table. If the number is not found in the
> deltabdef column, then it is an orphan and can (or rather should) be
> dropped.
>
> N.B. If you manually delete the syscdr database, then you must manually
> drop the shadow delete tables as well. If this is not done, then you
> can run into a 57 error when trying to add replicates later on.
I should have added. The prferred way to get rid of the syscdr DB is to
run cdr remove (if ER is down) or cdr delete server (if ER is running).
>
>
>>
>> Running version "Informix Dynamic Server 2000 Version 9.21.UC5XF" on
>> AIX 5.2. Yes, I KNOW, old version of Informix, Vendor is in process of
>> upgrading to ver 10.
>>
>> Pete
|
