We are running Baan IVc3 on HPUX using Informix. We need to compress data base for company 000.

It is my understanding that this must be done at the command line. Does anyone know the command?

Joy,

Either you use Baan or Informix tools:

Informix:

dumping the company 000 and uploading them again. Don't remember how to do that though. Ask an Informix guy :)

Baan:

use either bdbreconfig or bdbpre+bdbpost.

Joy,

Typically, 000 does not get so large in a Baan environment that it requires an Informix reorg. What symptoms are you seeing that warrant this?

If you are not familiar with the Informix HPL scripts or database unload I would recommend using Baan's bdbpre/bdbpost from the command line to do the export/import of 000.

-- Jim

I agree that normally this company does not take up much space. When my db administrator set up informix, he said that there was plenty of available space in company 000. This was a few years back. Now, there is not much available space. We have two choices. Either expand the db space or compress what is there.

In the process of developing, records are created and deleted. Rebuilding the data will recover lost disk space from deleted records. So we have been considereing this option first before we expand the db space.

Because this reorg is being executed on company 000, I believe that it must be done at the operating system command line rather than executing session ttaad4225m000.

My question is "What is the command"? What parameters are required for the bdbreconfig6.1 command to rebuild the data and check referential integrity?

You have to bdbpre and bdbpost them, the reconfig is more used to process changes in the table definitions, at least that the way I do it.

You can find the options in the tools online help, but I will post them as well as attachment.

Rgrds,

bdbpre options

After dump with ttaad4226 you can load the data like:
#bdbpost6.1 -f -k -n -e /tempo/erreurs/err000n -c 000 </data/dump/dumpc4.000 2>>/tempo/erreurs/err000 # (-k = delete)
bdbpost6.1 -f -A -n -e /tempo/erreurs/err000n -c 000 </data/dump/dumpc4.000 2>>/tempo/erreurs/err000 #(-A = append)
-f stands for create data before index (fast)