DB2

Troubleshooting: 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, see the WebSphere Commerce Migration Guide, or your database documentation.