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

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

book

Article ID: KB0083963

calendar_today

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.

 

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.