Hello,

BaanIVc4 SP15
Portingset 6.1c.07.02
Informix 9.40 - using Level2 drivers
running on Solaris 9
*
We have implemented most of Baan performance recommendations for Informix with level 2 drivers; kernel tuning, db_resource settings, onconfig etc
*
... until we got to the bit regarding update statistics
*
For level1 drivers it simply says "run update statistics low" which is fine, but for level2 it says that update statistics is vital for performance before stating a confusing combination of recommendations regarding some 'high', some 'low' and some 'medium'.* Can anyone recommend a general setting we can apply to all tables?

Cheers
Neal Matthews
Intier Automotive - IT Support Analyst

For more in depth suggestions from Informix, you should read the performance tuning guide at: http://www-306.ibm.com/software/data/informix/pubs/library/

I think in general you are safe running Medium on the table and indexes.

I use a script called 'dostats'. It is part of a collection of scripts called 'utils2_ak' and can be found at: http://www.iiug.org/software/index_DBA.html. This script creates the sql for the statistics commands according to Informix recommendations for all tables in a database.

I am running 7.31 with level 1, but I have put indexes on certain tables to help with reporting. An example of statistics sql from dostats for table tdpltc006150 with an index on t_mcno, t_dtof, t_tmof

UPDATE STATISTICS MEDIUM FOR TABLE tdpltc006150 DISTRIBUTIONS ONLY;
UPDATE STATISTICS HIGH FOR TABLE tdpltc006150 (t_mcno) DISTRIBUTIONS ONLY;
UPDATE STATISTICS LOW FOR TABLE tdpltc006150 (t_mcno, t_dtof, t_tmof);

On a side note, how is 9.40? How is level 2 on 9.40? We are looking at moving in the next year.

Thanks,
Andy

We are planning to migrate

FROM IVC4-SP7 /Informix 7.30(level 1) TO IVC4-SP15/Informix 9.40(level 1).

We are also planning to move database to new server along with upgradation. Do you suggest any faster way for data migration apart from Baan bdbpre->Ftp->bdbpost ?

Thank you in advance,

Hello,

Thanks for the replies. I will update this thread on a regular basis as we progress.

We are currently running the table reorg for our new company which is extremely time consuming. The import also consumed more disk space than we were expecting so we obviously need to do some investigation into why this occured.

On the issue of the quickest way of transfering data we are using the Baan bdbpre->Ftp->bdbpost technique.

Regards
Neal

I would definitely suggest using Informix tools for the migration. During our last upgrade (IVb2 -> IVc4 and new boxes), we were able to move and load 120G of data in under 6hrs. This was a mix of high performance loader, dbload and some heavy scripting. You can also use dbexport and dbimport which will unload and load the whole database.

If you are not as familiar with the Informix tools, I would suggest visiting www.iiug.org (Informix User Group) and browsing the software available, especially myexport.

Andy

Thank you very much. Appreciate your quick response and very useful information.

Thanks again,

Manish

Why don't you use the script that is automatically generated with the informix server admin web interface for every database ?