SET LOCK MODE TO WAIT for dbload
Posted in 1997
Hi
I need load a lot of records by dbload with -r option (do not lock
tables
during loading). Purpose:
1) speed,
2) filter records with bad constraints,
3) load to table in use by other users, don't create a buffer table to
load
with lock table.
Sometimes as result:
100 Row(s) loaded so far to table dealing_payments.
200 Row(s) loaded so far to table dealing_payments.
Row number 201 is bad.
14|150501740|...
Could not insert new row into the table.
ISAM error: key value lockedRow number 202 is bad.
14|150501740|...
Could not insert new row into the table.
ISAM error: key value locked
...Row number 250 is bad.
14|150501740|...
Could not insert new row into the table.
ISAM error: key value locked300 Row(s) loaded so far to table dealing_payments.
400 Row(s) loaded so far to table dealing_payments.
Table _name_ had 475 row(s) loaded into it.
Does anybody know how reduce the dbload
"to wait during ONCONFIG.DEADLOCK_TIMEOUT seconds",
is it possible?
Thanks,
--
Julian Zalutsky MIS, JSCB "Belcombank"
julian@martcom.belpak.brest.by Brest, Republic of Belarus