Table of Contents

Search

  1. Preface
  2. Backing Up and Restoring the Data Vault
  3. Configuring Centera as a Remote Data Vault Store
  4. Configuring Data Archive for a Legacy Source Using Legacy Adapters
  5. Data Archive Seamless Access for PeopleSoft
  6. Data Archive Transaction Restore API
  7. Dropping and Truncating Partitions in Data Archive
  8. High Availability Configuration for the Data Archive and File Archive Service Versions 6.1 to 6.3
  9. 0955-High Availability Configuration for the Data Vault Version 6.4 and Later
  10. How to Create Business Rules to Archive and Purge Transactional Data
  11. How to Uninstall Data Archive 5.1
  12. How to Uninstall Data Archive 5.3
  13. How to Use Scripts to Change Database User Passwords in the ILM Repository
  14. IBM DB2 Database Connectivity and Setup for Data Archive
  15. Installing Data Visualization
  16. Integrating Third-Party Schedulers in ILM Engine
  17. Parallel Processing in Data Archive
  18. Seamless Access Configuration for Siebel Applications
  19. Seamless Access Setup for Oracle E-Business Suite
  20. Using the Data Vault Service JDBC Driver to Connect to the Data Vault
  21. Using Multiple Engines in an ILM Environment
  22. Using PowerExchange ODBC Connections in a Data Archive Retirement Project
  23. Discovering Foreign Key Relationships in Enterprise Data Manager

Data Archive How-To Guide

Data Archive How-To Guide

Step 8: Import z/OS Metadata

Step 8: Import z/OS Metadata

Use the Enterprise Data Manager (EDM) to import metadata for the z/OS data sources. Perform this procedure for each data source.
  1. To start the Enterprise Data Manager, at the Information Lifecycle Management main window, select
    Accelerators > Enterprise Data Manager
    .
  2. To create an application version for the data source, right-click
    Custom Apps Only
    in the navigator pane, select
    New Application Version
    , and enter an application name and description.
  3. To import PowerExchange metadata for the application version that you created, complete the following tasks:
    1. Highlight the object and click
      File > Mine Database
      .
      The
      Connect to Mined Database
      dialog box appears.
    2. If you have already defined a connection, select it, and enter your z/OS user name and password. The remaining connection information is filled in automatically.
      If you are defining a new connection, enter the following information:
      • At
        Database Type
        , select
        CUSTOM_JDBC
        .
      • At
        JDBC URL
        , enter
        jdbc:odbc:
        dsn_name
        , where
        dsn_name
        matches the name in the odbc.ini file.
      • At
        Driver
        , enter
        sun.jdbc.odbc.JdbcOdbcDriver
        .
      • Enter your z/OS user name and password.
    3. In the
      Database Mining
      wizard, select the schema and list of tables for the data source.
    4. At the prompt to mine child tables of the selected tables, click
      No
      .
      Because the PowerExchange NRDB2 access method does not support foreign key relationships, you cannot mine child tables. By clicking
      No
      , you ensure that the PowerExchange Listener on z/OS does not spawn multiple subtasks that would return empty result sets.
      If you enabled the ILMBRIDGE or NOFKEYS Compatibility option for the PowerExchange ODBC connection, the PowerExchange Listener does not spawn multiple empty subtasks, regardless of what you select for this option.
      The EDM begins importing the metadata and displays the percentage complete in the
      Database Mining Progress
      window.
  4. To create and configure an entity object for the application version, complete the following tasks:
    1. Create an entity object and interim table.
    2. Insert tables into the entity.
    3. To avoid validation warnings, mark the first table as the driving table.
    4. Add tables to the interim table.
    5. Add Insert and Delete statements for each table.
      For retirement projects, you typically select a true statement such as
      1=1
      for the Insert statement and a false statement such as
      1=2
      for the Delete statement.
    6. Set default columns information for the interim table. For the From clause, enter the name of the driving table. For the Where clause, enter
      1=1
      .
    7. Delete unneeded entity steps. For retirement projects, you can delete all steps except the Insert into Archive Tables steps.
  5. Click
    Save
    , and close the EDM.
For more information about importing metadata into Data Archive, see the
Data Archive Enterprise Data Manager
guide.