IBM Db2 connector (DataStage)

Prerequisites

To use the IBM Db2 connector, you need to do the following prerequisite steps.

• Create the connection. For instructions, see Connecting to a data source in DataStage and the IBM Db2 connection.
• Ensure that the username that the connector uses to connect to the Db2 database is granted SELECT access to the following tables:
  • SYSCAT.COLUMNS
  • SYSCAT.INDEXCOLUSE
  • SYSCAT.INDEXES
  • SYSCAT.KEYCOLUSE
  • SYSCAT.REFERENCES
  • SYSIBM.SYSDBAUTH
  • SYSCAT.TABCONST
  • SYSCAT.TABLES