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

Configuring Seamless Access for IBM DB2

Configuring Seamless Access for IBM DB2

Before you configure seamless access for IBM DB2, verify that the combined and archive database schemas are created on the IBM DB2 database.
  1. Run a script in the combined database schema to create the XA_OBJ_TEMP_TABLE table.
    The table is a required temporary table for the Create Seamless Data Access Script standalone job. The table stores temporary results of the job, such as which tables the job processes.
    Run the following script to create the temporary table:
    CREATE TABLE XA_OBJ_TEMP_TABLE (OBJECT_NAME VARCHAR(2000),OBJECT_TYPE VARCHAR(2000), OBJECT_OWNER VARCHAR(2000),DEPENDENCE_LEVEL INTEGER)
  2. Schedule and run the Create Seamless Data Access Script standalone job.
    The job creates a script file that you can provide to the database administrator for review. If you want to create both the combined view and the query view, run the job once for each schema.
  3. The database administrator runs the script in the location specified in the script.
    You specify the location as part of the job parameters.

0 COMMENTS

We’d like to hear from you!