How to resolve "Bind process is not active. Please ensure that the user has permissions to create packages. Packages cannot be created" issue, while connecting to DB2 database on OS390
Article ID: KB0083963
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 7.0,7.1,7.2 |
Description
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.
=======================================================
[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.
Issue/Introduction
How to resolve "Bind process is not active. Please ensure that the user has permissions to create packages. Packages cannot be created" issue, while connecting to DB2 database on OS390.
Environment
TIBCO ActiveMatrix Adapter for Database
All Supported Platforms
Resolution
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.
Feedback
Yes
No
Powered by
