Parallel copy and locks

Starting many current parallel bcp sessions may cause Adaptive Server to run out of locks.

When you copy in to a table, bcp acquires an exclusive intent lock on the table, and either page or row locks, depending on the locking scheme. If you are copying in very large tables, and especially if you are performing simultaneous copies into a partitioned table, this can require a very large number of locks.

To avoid running out of locks:

For more information on bcp, see the Utility Programs manual.