Troubleshooting
Problem
This technote identifies a potential resolution to the error, Object or provider is not capable of performing the requested operation, Unable to connect to the database, which might occur when creating or connecting to a IBM® Rational® RequisitePro® project that is hosted on IBM DB2®.
Cause
The full error message is as follows:
Object or provider is not capable of performing the requested operation.
Unable to connect to the database
Ensure that the configuration and account information are valid
This error is known to occur after the application of the DB2 FixPack on the DB2 server.
Once a DB2 FixPack is applied, all packages are unbound in the database which results in RequisitePro not being able to validate the project database.
Resolving The Problem
To resolve this issue, run the following command to bind the packages:
- Log in as the db2admin
- Open a DB2 command prompt
- Changed directories to:
C:\Program Files\IBM\SQLLIB\bnd
- Enter the following commands in the command prompt:
db2 connect to databasename user db2admin using password
db2updv8 -d databasename
db2 bind @db2cli.lst blocking all grant public
db2 bind @db2ubind.lst blocking all grant public
db2 bind db2schema.bnd blocking all grant public
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21257587