Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

Summary of Configuration Steps

Summary of Configuration Steps

To configure PowerExchange to run Microsoft SQL Server bulk load operations, complete the standard procedures for moving SQL Server bulk data:
In addition, perform these specific tasks:
  • Adjust the value of APPBUFSIZE in the DBMOVER configuration file as needed.
  • Set the PWXPC connection attributes for SQL Server bulk loads.
  • Set the Target Load Type session property.
  • Review the PowerCenter session log to confirm that the SQL Server bulk loader is being used.

0 COMMENTS

We’d like to hear from you!