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

IBM DB2 for LUW Configuration Properties

IBM DB2 for LUW Configuration Properties

Update the configuration properties when you create or edit an IBM DB2 for LUW resource.
The following table describes the IBM DB2 for LUW configuration properties:
Property
Description
User name
Name of the user account used to connect to the IBM DB2 for LUW database.
Password
Password for the user account used to connect to the IBM DB2 for LUW database.
JDBC connection URL
JDBC URL used to connect to the IBM DB2 for LUW database. Metadata Manager uses this URL to verify connection information to the IBM DB2 for LUW database.
The JDBC connection URL uses the following syntax:
jdbc:informatica:db2://[host_name]:[port];DatabaseName=[database_name]
Secure JDBC parameters
Secure JDBC parameters that you want to append to the JDBC connection URL. Use this property to specify secure connection parameters such as passwords. Metadata Manager does not display secure parameters or parameter values in the resource configuration properties. Enter the parameters as name=value pairs separated by the delimiter character that the database driver requires. For example:
param1=value1;param2=value2
If secure communication is enabled for the database, enter the secure JDBC parameters in this property.
Connect string
Native connect string used to create a source connection to the database in the PowerCenter repository. The connect string is the name of the IBM DB2 for LUW database.
Encoding
Code page for the IBM DB2 for LUW database.
Only code pages that are compatible with the code page of the Metadata Manager repository are displayed.

0 COMMENTS

We’d like to hear from you!