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