Hi,

We have noticed that the normal jobs (daily/weekly) we run, have slowed down over the last few days. Also, some reports are taking longer time to process. This phenomenon is happenning for the past 4-5 days. We dont remember doing any thing new on the application/database, in the last few days. We are on BaaN 4c4- SP5 (HP-UX, Informix IDS 7.31). We were thinking to run 'Reorganize Tables' to overcome this problem. Do you think this will solve our problem? Any particular things to be taken care while running 'Reorganise Tables' and what options to choose while running this session. Any other remedies anybody can think of?

Any inputs on the above are welcome. Thanks in advance.

Regards

RA

Reorganize tables can help on tables that have lots of extents. Informix is far more sensitive on this that Oracle. Here some guidelines:

- determine with tables are fragmented.
- change the inf_storage for these files
- reorganize these tables.

In the past (ages ago) I used the script as attached. See if it helps you. As I wrote it that long ago I don't give any support on it ;).

Hope this helps,
Dick

Hi Dikkie,

What is the harm in running the "Reorganise Tables" for all tables of the live company, without taking any of the steps mentioned by you?
Can you give me some details how to
-determine with tables are fragmented.
and how to
- change the inf_storage for these files.

Thanks in advance.

Regards

RA

When reorganising tables without taking care about the content of the inf_storage can cause a very fragmented database or a database that uses much more space than needed.

When you read the script I posted it contains all kind of queries that can be used to see the table fragmentation and how this relates to the inf_storage file.

As I currently don't have access to an Informix database, please try yourself.

Kind regards,
Dick