1

We have an utility which retrieves some data from DB2 (v 10.5 for AIX) database. After we had applied Fix Pack 8 to database (client and JDBC driver had been also updated) this utility didn’t work. There was the following error in log:

13:09:48,270 [INFO ] SMU {SCSExecute.Execute.java} 13:09:48,258 [ERROR ] org.apache.jackrabbit.core.fs.db.DatabaseFileSystem failed to initialize file system 13:09:48,277 [INFO ] SMU {SCSExecute.Execute.java} com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-443, SQLSTATE=38553, SQLERRMC=SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-514, DRIVER=3.69.66

As recommended here (http://www-01.ibm.com/support/docview.wss?uid=swg21369762) for similar cases we executed the following commands in DB2:

db2 connect to <databasename> db2 bind db2schema.bnd blocking all grant public sqlerror continue db2 terminate

But it didn’t solve the issues.

What could we forget to do?
How could we check that bind command executed properly?
How could we try to solve the issue or reveal its root?

Improve this question

3 Answers 3

Reset to default
1

What could we forget to do?

As documented in the DB2 fixpack readme, after you install on the server, db2schema.bnd needs to be bound to existing databases.

How could we check that bind command executed properly?

If you installed the fix pack on DB2 database products that have existing databases, perform the following commands once for each database:

db2 terminate db2 CONNECT TO dbname user USERID using PASSWORD db2 BIND path\db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE db2 BIND path\@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD db2 BIND path\@db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD db2 terminate

where dbname represents the name of a database to which the files should be bound, and where path is the full path name of the directory where the bind files are located, such as INSTHOME\sqllib\bnd where INSTHOME represents the home directory of the DB2 instance. db2ubind.lst and db2cli.lst contain lists of required bind files used by DB2 database products.

How could we try to solve the issue or reveal its root?

may be the installation of the DB2 fixpack was incomplete.

For further your ref:- DB2 SQL Error occurs after DB2 patch install

Improve this answer
2
  • Thanks for reply. But as I wrote in my message we executed these commands with no results. So, how could we check that db2schema.bnd was actually bound to database? Commented Feb 12, 2017 at 10:56
  • @PierreVanStulov, Binding bind files after installing fix packs ibm.com/support/knowledgecenter/SSEPGG_9.7.0/… Commented Feb 12, 2017 at 10:58
0

Make sure you have successfully completed post-installation tasks as described in the manual, specifically, run db2updv105 and rebind all bind files anew. The error message indicates that the CLI package causes the problem, so you need to at least bind all files in db2cli.lst:

db2 BIND <path>/@db2cli.lst BLOCKING ALL GRANT PUBLIC
Improve this answer
1
  • Thanks for usefull instruction to see manual! Step 4 solved our issues :) Commented Feb 27, 2017 at 15:28
0

Sorry for not having replied! We have solved the problem by execution of the following actions:

1) Execute commands in DB2:

db2 terminate db2 CONNECT TO dbname user USERID using PASSWORD db2 BIND path\db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE db2 BIND path\@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD db2 BIND path\@db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD db2 terminate

2) (VERY IMPORTANT!!!) Restart DB instance.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.