SAP Knowledge Base Article - Preview

2775367 - Batch size on BCP doesn't respect a value greater than 65536 - SDK for SAP ASE

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

SAP Adaptive Server Enterprise 16.0 ; Sybase SDK all versions

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.