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.
>
> 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
|
