Due to the recent acquisition by IBM, the Adabas & Natural Ideas Portal does not contain ideas from products ApplinX and EntireX any longer. Please refer to the IBM Ideas Portal for these products from now on (IBMid required). Existing content will be migrated during the next few weeks.
Add a new idea Subscribe
Status Under Review
Workspace Adabas for z/OS
Categories Event Replicator Target Adapter (ART)
Created by Hermann Pfeiffer
Created on Aug 26, 2021

RELATED IDEAS

Better Options For MS SQL Server Loader (bcp)

This is in the context of replicating data from a mainframe Adabas to a MS SQL Server under Windows.

For a huge amount of data in source files Initial State processing can get done with ADARIS and a loader, bcp (Bulk Copy Program) as a MS SQL Server tool. The bcp call with options is generated by ART.

We've noticed, for the bcp call the option -hCHECK_CONSTRAINTS is mandatory, i.e. generated and used by ART no matter what. According to bcp documentation, this is not a good idea regarding performance. Couldn't this option be dropped or made optional?

Also, the bcp option -hORDER(ISN ASC) might improve performance. So, shouldn't that get generated automatically, instead?

The Adabas & Natural by Software AG Ideas Portal is hosted by Aha! Labs Inc.. Therefore, personally identifiable information are processed by Aha! Labs Inc., a company based in the United States of America. By using this Ideas Portal you agree to the Terms of Service of Aha! Labs Inc.. For further information about Aha’s handling of your personally identifiable information, please go to: https://www.aha.io/legal/security/gdpr.