After all the trouble I went through getting bdbreconfig6.1 to work on my test server, I then forgot to sent my logical logs to /dev/null before I attempted the reorg - and thus screwed myself.

The rebuild died, I copied the R file and attempted the rebuild again (after disabling logs/recycling informix) using the following command:

bdbreconfig6.1 -Ntdsls051100+ 2>sls051.log

But I still got the following Informix error:

Drop Original Table error 1134
Can't create original table (error 506).

So now I am getting ready to go through an Informix restore (on the test server -- thank God), and I just want to make sure that there's not anything "Baan related" that I have to do?

I'll just put in my Informix L-0 backup tape and type in: ontape -r ?? -- And Baan will be happy when that completes?

Thanks for any/all assistance;
Theresa

Theresa,

I don't see why the rebuild does not work. The R. file is a valid backup of that table and you should be able to re-create the table with it. I would check first what the error 1134 means, I am assuming this is an Informix error. Possibly the problem can be fixed and you could avoid having to do a restore.

Hi Pat;

Thanks for the insight into the situation...after looking over some of the switches available to bdbreconfig6.1, I noticed '-m -n' to ignore ref. integrity and domain constraints. As I didn't have anything to lose, I attempted the reorg again adding those 2 switches, and it worked! -- I got the data back in.

I need to run the reorg again, but I'm trying to figure out if the bdbreconfig6.1 command checks & correct the data/indicies, ref integrity, and validity of references by default.

Also, the extents on this table did calculate in KB. :)

Here's the command I used to get tdsls051 back into Baan:

bdbreconfig6.1 -m -n -Ntdsls051100+ 2>sls051.log

Thanks (yet) again for helping me out...