Theresa
23rd February 2002, 00:11
Hi all!

I have a quick question: When you perform a sequential dump (copy) of a table, it uses a bdb_"command" -- I *think* it's bdb_pre6.1...?

That being said, does that command "lock the table" why the data is being unloaded?

I only ask because the Corp IT Admin kicked off a sequential dump of a sales hist (dpsls050) table which was linked to another table (tdsls041) and after he kicked off this dump, it locked the entire sales dept up (they were entering line items), and they couldn't do anything until his dump completed.

So I'm just curious.

Thanks for any help on this issue!

Theresa

Commandeur
25th February 2002, 16:30
Yes,

Bdbpre locks table, you should use it only when you have no users loged or you can create fatal errors to users and some database corruption. (I've seen it on central invoicing package)