Amar,
It did get error message, just as following (same as db2 migrate db):
SQL2519N The database was restored but the restored database was not
migrated
to the current release. Error "-440" with tokens "LOCATE FUNCTION" is
returned. LINE NUMBER=1. SQLSTATE=42884
Also I followed IBM DB2 Support idea, that is I should create the same
instance name as the original ( I highly doubt that the db backup
image includes instance information, but I did the test). But
unfortunately I got the same result.
Any help would be greatly appreciated.
he*******@yahoo.com (Amar) wrote in message news:<47**************************@posting.google. com>...
Did you get any error when you restored the database? The restore migrates
the db automatically and it must have failed.
Amar
da***********@yahoo.ca (David) wrote in message news:<87**************************@posting.google. com>... Dear ALL,
I had a problem when I restore a db2 V7 EE Fixpack 5 on AIX 4.3.3 to
db2 V8 ESE Fixpack 3 on AIX 5.1.
Once I restored db2 db (PRD) to V8 and tried to connect to DB, I had
the following problem:
$db2 connect to PRD
SQL5035N The database requires migration to the current release.
$db2 migrate db PRD
SQL0440N No authorized routine named "LOCATE" of type "FUNCTION"
having compatible arguments was found. LINE NUMBER=1. SQLSTATE=42884
How can I get out of here?
TIA