Symptom
BCP utility is not respecting the batch size (-b). Examples: -b90000 or 70000 or 80000. See:
======
% bcp dbtbcp..tbcp in bcp01 -c -b75000 -Uusername -Ppassword -Steste
Starting copy...
Batch successfully bulk-copied to the server.
131072 rows sent to the server.
196608 rows sent to the server.
Batch successfully bulk-copied to the server.
262144 rows sent to the server.
327680 rows sent to the server.
.....
.....
1500000 rows sent to the server.
1500000 rows copied.
Clock Time (ms.): total = 71677 Avg = 0 (20927.22 rows per sec.)
======
We can see it starts with 131072 and start to increasing by 65536.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
- Open Client Client-Library
- bcp
Product
Keywords
BCP batchsize maximum batch size -b 65536 CR#818917, #818917, CR#818918, #818918, CR#818919, #818919, CR#818920, #818920 , KBA , BC-SYB-SDK , SDK , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.