Troubleshooting
Problem
Administrator launches 'Controller Configuration' and selects a database connection. Administrator clicks the green 'Play' button, to launch 'Database Conversion'. Administrator clicks 'Connect'. An error appears.
Symptom
** ERROR: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-443, SQLSTATE=38553, SQLERRMC=SYSIBM.SQLPRIMARYKEYS;PRIMARYKEYS;SYSIBM:CLI:-727, DRIVER=3.67.27
Cause
There are several known causes for similar errors.
- TIP: See separate IBM Technote #1283338 for more examples.
This Technote specifically relates to the scenario where the database was recently restored from a backup file that came from a different DB2 server.
- In some environments, this means that the db2schema.bnd file needs to be re-bound to the database server.
Environment
Controller configured to use a DB2 database has been recently restored onto a new DB2 server (different from the original/source DB2 server).
Resolving The Problem
Re-bind the db2schema.bnd file (on the DB2 database server).
Steps:
The following steps are based on using Windows as the platform for DB2 server.
1. Logon to the DB2 server as a DB2 administrator (for example 'DB2ADMIN')
2. From the Start Menu, launch the DB2 program "Command Window - Administrator"
3. Navigate to the BND folder
4. Type the following commands (replace <databasename> with the name of your database):
5. Test.
Steps:
The following steps are based on using Windows as the platform for DB2 server.
- Modify the steps accordingly, if necessary.
1. Logon to the DB2 server as a DB2 administrator (for example 'DB2ADMIN')
2. From the Start Menu, launch the DB2 program "Command Window - Administrator"
3. Navigate to the BND folder
- TIP: Assuming that DB2 has been installed in the default location, use the following command:
cd C:\Program Files\IBM\SQLLIB\bnd
4. Type the following commands (replace <databasename> with the name of your database):
db2 connect to <databasename>
db2 bind db2schema.bnd blocking all grant public sqlerror continue
db2 terminate
db2 bind db2schema.bnd blocking all grant public sqlerror continue
db2 terminate
5. Test.
Related Information
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
09 September 2020
UID
swg21962585