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:
Set the number of locks configuration parameter high enough, or
Use the -b batchsize bcp flag to copy smaller batches. If you do not use the -b flag, the entire copy operation is treated as a single batch.
For more information on bcp, see the Utility Programs manual.
