RDBMS providers: DB2

Connects to IBM DB2 databases (version 10 or above).

DB2, JDBC, IBM provider, TCP/IP connection, (jdbc). See information below.
DB2, IBM provider, TCP/IP connection, ODBC native (odbc native).

ODBC providers have been deprecated in Data Management and may not be supported in future versions.

When configuring DB2 via JDBC, you must issue GRANT SELECT ON SYSCAT.DBAUTH to the User ID (Uid) used by the Data Management database connection. This User ID must also have SELECT privileges for the following tables:

SYSIBM.SQLTABLES
SYSIBM.SYSTABLES
SYSIBM.SQLTABLETYPES
SYSIBM.SQLTABLEPRIVILEGES
SYSIBM.SYSCOLUMNS
SYSIBM.SQLSPECIALCOLUMNS
SYSIBM.SQLCOLPRIVILEGES
SYSIBM.SYSDUMMY1
SYSIBM.SQLPRIMARYKEYS
SYSIBM.SQLSTATISTICS
SYSIBM.FOREIGNKEYS
SYSIBM.SYSINDEXES
SYSIBM.SQLPROCEDURES
SYSIBM.SQLPROCEDURECOLS
SYSIBM.SYSROUTINES
SYSIBM.SYSROUTINEPARMS
SYSIBM.SQLTYPEINFO
SYSIBM.SQLUDTS
SYSIBM.SQLSCHEMAS
SYSIBM.SYSRELS
SYSIBM.SYSKEYCOLUSE
SYSIBM.SYSTABCONST
SYSIBM.SYSDATATYPES