Database Interface Designer settings

When you define a DB2® (z/OS®) database in the Database Interface Designer, in addition to the common settings available for all of the database-specific adapters in the Database Definition dialog, you need to enter information specific to DB2 (z/OS).

DB2 (z/OS) Adapter-specific settings include:
  • DB2 > Plan name

    This is the name used to bind the plan when the IBM® Transformation Extender products were installed.

  • DB2 > Subsystem name

    This is the name used to specify the DB2 subsystem.

  • Have access to DB2 through ODBC

    This check box determines whether you will access your DB2 database through ODBC and Client Access for Windows.

    If you do have ODBC access, the remaining fields must be assigned values.

  • ODBC Definition > Data source

    This is the data source you defined in your development computer that is used by the Database Interface Designer to access the database information for design-time purposes.

  • Security > User ID

    This is the user ID to connect to the DB2 subsystem.

    This field is used by the Database Interface Designer only. It is ignored when the map is run on z/OS.

  • Security > Password

    This is the authorization password to connect to the DB2 subsystem.

    This field is used by the Database Interface Designer only. It is ignored when the map is run on z/OS.