I have just completed archiving and now I am trying to estimate how long it will take to run Reorganize Tables with data and indexes checked. We are single logistic / multi finance which means that most of our data is shared between companies. A few weeks back I executed this for the td package and for 5 companies. The process completed in 4 hours. Then I ran it again for the tc package which also completed in 4 hours.

I monitored both executions and observed that the first thing it did was reload the data for the first company and set the reference counters. When it was done with the first company, it set reference counters for the next company skipping the data load because the data is shared.

What I want to understand is how the program will run if I execute it for all packages and for the same 5 companies. Will it reload the data for all packages and all companies before it proceeds to the reference counters?

The reason that I am asking is when it reloads the data, my system generates informix logs and there are space considerations that need to be monitored while the data is being loaded.

I'm hoping that I can walk away from this process when it starts to reset the reference counters.

Any advice will be appreciated.

Hi Joy,

It reloads the data first, then does the reference counters..

Since you're using a real database (not tbase) you could just use
an informix export/import to acheive the same thing, only faster.

Dave

Does it matter if I use BaaN or Informix to recapture lost disk space after deleting records?

That mostly depends on informix export..
You'll need to export in a way that will compress the data within the table
(i.e., not export blank rows)
I'm mostly familiar with Oracle, in oracle we would do this with
exp compress=y.
I would guess that informix would have something similar.

The upside to using the informix dump, is that the dump itself is faster, and
you don't have to rebuild reference counters after you're finished..

Dave