Skip to main content

Targeting an IBM DB2 database

For each DB2 database, add a target system (Manage the system > Resources > Target systems):

  • Type is DB2 Database.

  • Address uses:

    Server DB2 system DSN.

    See Installing client software to learn how to find the ODBC system DSN.

    (key: server)

    Table view type, default syscat Optional.

    If the table view type is omitted, the default view is syscat. Specify the sysibm table view for DB2 targets with z/OS backend.

    (key: view)

  • Administrator ID and Password are the login ID and password for the target system administrator you configured earlier .

The full list of target system parameters is explained in Target system options .