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 Source Databases

IBM DB2 Source Databases

IBM DB2 databases store character data as binary data. If you want to retire data on an IBM DB2 source database, you must specify a code page in the source connection parameters and create mappings for certain data types.
When you create the IBM DB2 source connection, specify the code page CharsetFor65535=CP950 in the connection parameters. Then create mappings for the VARCHAR() for bit data and LONG VARCHAR for bit data types. If you do not specify the code page in the parameters and create mappings, the file archive loader job retrieves the binary source data as hexadecimal data and the job fails to load data.
You do not need to create a mapping for the CHAR() for bit data type.

0 COMMENTS

We’d like to hear from you!