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:
- Navigate to the DB2_installdir/bnd directory.
- 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.