Sybase Interview Question:

How Do I Take Advantage of Table Partitioning with bcp in Sybase?

Submitted by: Administrator

You can take advantage of table partitioning with bcp in by following these guidelines:

1. Break up the data file into multiple files and simultaneously run each of these files as a separate bcp job against one table.

Running simultaneous jobs increases throughput.
2. Choose a number of partitions greater than the number of bcp jobs.
Having more partitions than processes (jobs) decreases the probability of page lock contention.
3. Use the batch option of bcp in. For example, after every 100 rows, force a commit. Here is the syntax of this command:
bcp table_name in filename -b100
Each time a transaction commits, ASE randomly assigns a new partition for the next insert. This, in turn, reduces the probability of page lock contention
Submitted by: Administrator