Re: waiting for SEM

In article <34DEA548.A5927A4C@hp.com>, Deepa Sankaranarayan <deepa_sankaranarayan@hp.com> writes >Hi > >I am running oncheck -cD and cI on my sap dbs and they take ages to >complete. Its a 2 cpu box and I've configured Informix for 2 cpus. >(NUMCPUVPS, MULTIPROCESSOR). glanceplus shows that the process is >waiting for SEM. What needs to be changed? > >TIA > Proably not much as oncheck is VERY disk intensive. Try running oncheck on several tables in parallel. Using oncheck -pe to make sure that the tables are on different disks first... >Deepa > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care