Re: [Q] dbimport locking mode

Leonid Belov wrote: > > Hello Informixers, > > Is there any way to change locking mode used by "dbimport"? > > Dbimport locks table rows, and when it tries to alter big table > - for example, to add foreign key constraint - operation fails with message > "No more locks available". So I need "Lock Table ..." before altering table > and "Unlock ..." after > > One method to make it - edit file <export_dir>/<database>.exp/<database>.sql > by hands. Another - write advanced awk script to perform such editions. > Can I set dbimport behaviour by command-line options or by some settings > - but _once_ and forewer? > > Increasing number of locks in "onconfig" is not a solution because table > always can contain more rows than this number. > > Any help would be appreciated > > Leonid > > Hello, What you can do is that when you dbimport you can change your locking mode of the tables to page by writing small sql script. And you do your dbexport, when you import it back it will use only page level locks whick will be substancially less. After import is complete change the locking mode to row level . Hope things helps !!! Cheers -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ M.R.Muthukumar Consultant at Litlenet Email:m_muthukumar@litle.net Voice Mail:508-937-1245 X 2043 Strong believer in making things work !!!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~