Troubleshooting: Error when restoring database

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


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
> name "TABLES") has returned an error SQLSTATE with diagnostic
> "SYSIBM:CLI:-805". SQLSTATE=38553"


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.