Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Configuring Metadata Manager
  4. Application Resources
  5. Business Glossary Resources
  6. Business Intelligence Resources
  7. Custom Resources
  8. Data Integration Resources
  9. Data Modeling Resources
  10. Database Management Resources
  11. Universal Resources
  12. Managing Resources
  13. Loading and Monitoring Resources
  14. Managing Permissions
  15. Resource Migration
  16. Repository Migration
  17. Appendix A: Metadata Manager Login
  18. Appendix B: Metadata Manager Properties Files
  19. Appendix C: Resource Configuration Files
  20. Appendix D: Glossary

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

Configure PowerExchange

Configure PowerExchange

To access metadata from a DB2 for z/OS subsystem, install PowerExchange on the machine where the Metadata Manager Service runs. You must also install PowerExchange on the z/OS system where DB2 runs.
To configure PowerExchange, complete the following tasks:
  • Configure PowerExchange to connect to z/OS on the machine where the Metadata Manager Service runs.
  • Configure dbmover.cfg on the machine where the Metadata Manager Service runs with a NODE statement that points to the PowerExchange Listener on z/OS.
  • Configure the following security setting in the DBMOVER configuration file on z/OS:
    SECURITY=(2,N)
    Optionally, configure the PowerExchange Listener on z/OS to recognize logins that are known to the operating system.
    The following information shows an example of dbmover.cfg:
    /*********************************************************************/ /* PowerExchange Configuration File /*********************************************************************/ LISTENER=(node1,TCPIP,2480) LISTENER=(BGQALST,TCPIP,30080) LISTENER=(BGQALST_new,TCPIP,448) LISTENER=(DB2zOS_SPEDDUR,TCPIP,448) /***********************************************************************/ NODE=(DB2zOS_SPEDDUR,TCPIP,mhz890-2,3156) NODE=(local,TCPIP,000.0.0.1,2480) NODE=(node1,TCPIP,000.0.0.1,2480) NODE=(BGQALST,TCPIP,mhz890-2,30080)
By default, PowerExchange on z/OS uses the user ID of the PowerExchange Listener for DB2 access. To use a user-specified user ID for DB2 access, configure PowerExchange to use operating system security.

0 COMMENTS

We’d like to hear from you!