Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Appendix A: Datetime and Numeric Formatting
  24. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

IBM DB2 Native Utilities

IBM DB2 Native Utilities

You can configure Data Archive to use IBM DB2 native utilities for data movement. You may want to use the IBM DB2 native utilities to increase the archive job performance. By default, Data Archive uses JDBC for data movement.
You can use the native IBM DB2 utilities to export data from the source and import data into the target destination. You can use the export utility or the IBM DB2 HPU utility to export data. You can use the load client utility or the import utility to import data.
When you configure Data Archive to use IBM DB2 native utilities, the job log indicates which utility the archive job uses. The job log does not include row count information for the Generate Candidates and Copy to Destination steps. The row count information is not available because the extract and import process is a bulk process. However, the job log includes a confirmation that the rows are successfully inserted.

0 COMMENTS

We’d like to hear from you!