db2 restore problem

[David]

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

[richardshen@canada.com]

Re: db2 restore problem

daviddeng2008@y ahoo.ca (David) wrote in message news:<877a8358. 0406270455.4de2 3daf@posting.go ogle.com>...[color=blue]
> 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[/color]

David:
Before you do a migrate, y should check if your current database could be migrated.
Richard.

[Amar]

Re: db2 restore problem

Did you get any error when you restored the database? The restore migrates
the db automatically and it must have failed.

Amar

daviddeng2008@y ahoo.ca (David) wrote in message news:<877a8358. 0406270455.4de2 3daf@posting.go ogle.com>...[color=blue]
> 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[/color]

[David]

Re: db2 restore problem

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.


heyhi_999@yahoo .com (Amar) wrote in message news:<476fd0ca. 0406291608.1394 20ca@posting.go ogle.com>...[color=blue]
> Did you get any error when you restored the database? The restore migrates
> the db automatically and it must have failed.
>
> Amar
>
> daviddeng2008@y ahoo.ca (David) wrote in message news:<877a8358. 0406270455.4de2 3daf@posting.go ogle.com>...[color=green]
> > 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[/color][/color]

[Amar]

Re: db2 restore problem

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.


daviddeng2008@y ahoo.ca (David) wrote in message news:<877a8358. 0406300556.35a9 eb3b@posting.go ogle.com>...[color=blue]
> 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.
>
>
> heyhi_999@yahoo .com (Amar) wrote in message news:<476fd0ca. 0406291608.1394 20ca@posting.go ogle.com>...[color=green]
> > Did you get any error when you restored the database? The restore migrates
> > the db automatically and it must have failed.
> >
> > Amar
> >
> > daviddeng2008@y ahoo.ca (David) wrote in message news:<877a8358. 0406270455.4de2 3daf@posting.go ogle.com>...[color=darkred]
> > > 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[/color][/color][/color]