Troubleshoot and support > Migrate > Database tier migration issues


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


+

Search Tips   |   Advanced Search