Troubleshoot: Error when restoring database

During database migration errors are encountered when upgrading to a higher DB2 version.

 

Problem

When restoring the old DB2 database to the DB2 version 8.2.3 or higher database, you see the following error:

    > "[IBM][CLI Driver][DB2/NT] SQL0443N Routine
"SYSIBM.SQLTABLES" (specific
> name "TABLES") has returned an error SQLSTATE with diagnostic
text
> "SYSIBM:CLI:-805". SQLSTATE=38553"

 

Solution

You must rebind the db2schema.bnd file. Complete the following steps:

1. Navigate to the DB2_installdir/bnd directory.

2. Run the following commands

   db2 bind @db2ubind.lst 
   db2 bind @db2cli.lst blocking all grant public
   db2 bind db2schema.bnd blocking all grant public
   

For information on restoring your database, refer to the WebSphere Commerce Migration Guide, or your database documentation.

Related Concepts

Migrate from a previous version of WebSphere Commerce

Related tasks

Migrate the WebSphere Commerce database

Migrate the development environment database

Migrate the WebSphere Commerce database using the migration script