Oncheck Question

I need to run oncheck -cDI dbs:tab1 on a table ( The table has 15 million, rowsize of 376, has many triggers and indexes). Is there any way I can speed up this process by setting any environment variables. Any other Suggestions? We use IDS 7.30 UC7, SunOS 5.6 Thank you very much in advance.. Ganesh..

> I need to run oncheck -cDI dbs:tab1 on a table ( The table has 15 million, > rowsize of 376, has many triggers and indexes). > Is there any way I can speed up this process by setting any environment > variables. Any other Suggestions? > We use IDS 7.30 UC7, SunOS 5.6 RUN_FASTER = YES !!!!!! I believe there are no variables to speed up this process. -- ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285

Setting the PSORT parameters (PSORT_NPROCS & PSORT_DBTEMP) will help somewhat as there is SOME sorting being done to verify the rowids but this is a small part of the run so it will not be a BIG help, sorry. Art S. Kagel Ganesh_Sankar@providian.com wrote: > > I need to run oncheck -cDI dbs:tab1 on a table ( The table has 15 million, > rowsize of 376, has many triggers and indexes). > Is there any way I can speed up this process by setting any environment > variables. Any other Suggestions? > We use IDS 7.30 UC7, SunOS 5.6 > Thank you very much in advance.. > > Ganesh..