Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 7.0,7.1,7.2 |
The following error may occur while connecting to DB2 on OS390.
=======================================================
[tibcosoftwareinc][DB2 JDBC Driver]Bind process is not active. Please ensure that the user has permissions to create packages. Packages cannot be created in an XA Connection.
=======================================================
This error means the user that is connecting to DB2 does not have BINDADD privileges on the database.
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.