Improve loading into SQL server

[RikDeclercq]

Bulk load can be enabled in the DSN in all versions 8.1 or greater. Go to the .odbc.ini file and add this to the DSN

Code: Select all

EnableBulkLoad=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadOptions=0

Change the odbc driver from the classic driver:

Code: Select all

Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss24.so
Description=DataDirect SQL Server Wire Protocol driver

To the Native Driver:

Code: Select all

Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMsqls24.so
Description=DataDirect 6.0 SQL Server Native Wire Protocol

In version 8.7 the library would be VMmsss25.so and VMsqls25.so.

That will speed the load - however you will find that the server job itself is a bottleneck. If you need more speed, switch over to parallel

Thank you very much for this information. This helps us al lot !