Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

Getting Source DBD Information from the IMS Catalog

Getting Source DBD Information from the IMS Catalog

PowerExchange requires access to IMS database definitions (DBDs) in source format for creating data maps in the PowerExchange Navigator. PowerExchange also requires DBD information in DBGEN format for creating capture registrations in the PowerExchange Navigator and for performing IMS unload processing. You can configure PowerExchange to access DBD information directly from the IMS catalog instead from the DBDLIB library.
When properly configured, PowerExchange can transparently get DBD information for IMS source objects from the IMS catalog by using the following IMS tools:
  • IMS catalog API
    . This API consists of the DFS3CATQ assembly program in the IMS
    xxx
    .SDFSRESL.RESLIB library and the DFS3CATQ macro in the IMS
    xxx
    .SDFSMAC library. The API gets DBD information in DBGEN format from the IMS catalog when you create capture registrations for IMS log-based or synchronous CDC sources in the PowerExchange Navigator or perform IMS unload processing. PowerExchange requires the high-level qualifier of the bootstrap data set if the IMS control region is not running or if you are using an IMS version earlier than IMS 15.
  • IMS Catalog Library Builder Utility, DFS3LU00
    . The utility gets DBD information in source format from the IMS catalog and writes this DBD information to a PDSE that you pre-allocated. When you create data maps in the PowerExchange Navigator, PowerExchange retrieves the source metadata from the PDSE. After the metadata is imported to the Navigator machine for data map creation, PowerExchange deletes the information from the PDSE so that no PDSE maintenance is required.
Use of the IMS catalog is optional in PowerExchange and IMS. However, certain IMS functionality, such as database versioning and the management of run-time application control blocks requires the IMS catalog. For more information see the IBM IMS documentation.
For PowerExchange to use the IMS catalog API to get metadata for IMS sources, provide the high-level qualifier of the bootstrap data set in the IMSBSDS statement in the DBMOVER configuration file.
For PowerExchange to use the IMS Catalog Library Builder Utility, DFS3LU00, to retrieve DBD information from the IMS catalog, perform the following configuration tasks:
  1. Allocate a partitioned data set extended (PDSE) to hold output from the IMS Catalog Library Builder Utility, DFS3LU00.
  2. Customize the PowerExchange Listener JCL or PROC to specify the DD statements required for IMS catalog use.
  3. In the DBMOVER configuration member on the PowerExchange Listener machine, define the following statements:
    • IMSID. You must specify an
      ims_ssid
      value that matches the
      ims_ssid
      in the IMSBSDS statement.
    • IMSBSDS. Make sure the
      ims_ssid
      in this statement matches the
      ims_ssid
      in the IMSID statement.
    • LU00FILE. Enter the name of the PDSE that you created to store DBD output from the IMS Catalog Library Builder Utility, DFS3LU00.
  4. When you add data maps for IMS source objects in the PowerExchange Navigator, be sure to configure the following fields:
    • On the
      Name
      page, select
      Import Record Definitions
      .
    • On the
      DL/1 Batch Access Method
      page, enter an IMS SSID value that matches the
      ims_ssid
      value that you specified in the IMSBSDS statement in the DBMOVER configuration file.
    • On the
      Import Copybook - Source Details
      page, select
      Remote
      under
      Source
      and select
      DBD
      in the
      Type
      field.
    • On the
      Import Copybook - Remote DBD Details
      page, in the
      File Name
      field, enter the name of a PDS along with the DBD member name that you want to look for in the IMS catalog.
For more information, see the "IMS Bulk Data Movement" chapter in the
PowerExchange Bulk Data Movement Guide
and the "IMS Log-Based Change Data Capture" chapter in the
PowerExchange CDC Guide for z/OS
.

0 COMMENTS

We’d like to hear from you!