By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,407 Members | 1,753 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,407 IT Pros & Developers. It's quick & easy.

db2 restore problem

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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


David:
Before you do a migrate, y should check if your current database could be migrated.
Richard.
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

P: n/a
Ahh! Seems like after internally after db migration the creation of
sysfun functions falied with -440, I would suggest that you apply
latest fixpack avilable and issue migration again.

No I don't think db backup has anything to do with instance, you can
restore
db on any other instance on same os. But IBM support might be aware of
some
problems reported earlier which make them to come up with this
suggestion.

Amar.
da***********@yahoo.ca (David) wrote in message news:<87**************************@posting.google. com>...
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

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.