Re: Dbimport error
Posted in 1996
In article <31C0BC0D.617E@systems.dhl.com>, Vikram
<vlulla@systems.dhl.com> writes
>I am trying to do a dbimport of a database and get the following error
>message mid-way :
>
>*** execute sqlobj
>244 - Could not do a physical-order read to fetch next row.
>134 - ISAM error: no more locks
>
>This has started to happen suddenly ( I have done this same operation a
>couple of times earlier )
>
>Have I missed setting any parameter ?? Please advice
>
>Thanks in advance
Under Standard Engine increase the number of locks within the UNIX
kernel - flocks or something similar.
Under OnLine login as informix and run use onmonitor ( OnLine
version6/7) or tbmonitor (OnLine below version 5) and chose
Paramaters-> Shared Memory as increase the locks paramater.
General under OnLine I increase teh Informix locks by ~20000
and try again.
Cheers,
--
David Williams