Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 7.0,7.1,7.2 |
To resolve this issue, grant the following privileges to the DB2 owner. 1). BINDADD 2). CREATEIN on the collection specified by the Package Collection option and in NULLID . 3). SYSADM or SYSCTRL 4). SELECT access to following systems tables to use (e.g., mining the DB2 database) the DB2 driver on the mainframe. SYSTABLES SYSCOLUMNS SYSPROCEDURES SYSPARMS SYSCOLAUTH SYSTABAUTH SYSKEYS SYSINDEXES SYSSYNONYMS SYSROUTINES SYSFOREIGNKEYS SYSSCHEMAAUTH Note: These tables are in SYSIBM schema. 5). GRANT EXECUTE on the PUBLIC group for executing the packages. 6). CHANGE authority or higher on the collection where you want to create the package. Now try to create the connection and import the DB2 data source and try running the data viewer on this data object.