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. Storage Classifications
  24. Appendix A: Datetime and Numeric Formatting
  25. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Utilities for Data Import

Utilities for Data Import

You can use the load client utility or import utility to import data. The utilities for data import are platform-dependent. The utility that you use for the import depends on the platform that hosts the IBM DB2 database.
You can use the following utilities to import data:
Load Client Utility
For IBM DB2 on AIX, Linux, UNIX, or Windows, Data Archive uses the IBM DB2 load client utility to import all tables that do not contain LOB datatypes to the target. You must configure a temporary LOB directory if you want Data Archive to use the load client utility to import tables with LOB datatypes.
Import Utility
For IBM DB2 on AIX, Linux, UNIX, or Windows, Data Archive uses the IBM DB2 import utility to import tables with LOB datatypes if you do not configure a temporary LOB directory. Note that the import utility may decrease the import performance because the utility generates logs on the IBM DB2 database to undo the import.
For IBM DB2 on AS/400 and z/OS, Data Archive uses the import utility to import all tables.

0 COMMENTS

We’d like to hear from you!