473,324 Members | 2,268 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

db2 restore problem

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
4 5989
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Dave | last post by:
When I am trying to use backup or restore from the EM, a dialog box never pops up, and the EM interface locks up. Has anyone else had problems like this? Looks like all other functions from EM...
3
by: butatista | last post by:
Please help SQL Server 2000 Standard I am trying to restore databases on my server and am unable to get them to restore using the database option. For example, the location of my backup...
2
by: Moti.Ba | last post by:
Hello, I need to restore the Master DB in my SQL 2k server (with sp3). The problem is that i don't have SQL backups of this file I only have general backup of the entire c:\ drive i made using...
4
by: ScottH | last post by:
I am running 7.2 with fixpack 10a under W2K. I got a backup from someone else in an attempt to debug a data issue. The other person created the database with UTF-8 (codepage 1208), so I created a...
3
by: Vikrant | last post by:
Friends, Due an application (old) install program problem, Under AIX I could only create DB2 instance, I could also catalog it. Its complex application and I am not expert in creating full...
4
by: Hardy | last post by:
hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces of the db should be redesigned then I plan to use redirected restore. but...
9
by: GL | last post by:
I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following “SQL2059W A device full warning was...
13
by: Andy K | last post by:
Hi , I'm wondering what's going on with a restore I'm trying to do . My DB2 version is a 7.2 on a Linux RH ES 2.1 . I've copy a recent backup that was on NAS for a test on my machine . I...
11
by: Chris | last post by:
I have searched this group for answers and tried the responses. I am trying to Use an full online backup from our production server and apply it to our test server. The Tablespaces in the...
2
by: modeler | last post by:
Hello, I am trying to restore a DB2 9.1 fp2 backup to another DB2 9.1 fp2 machine, both are on Windows. C:\Program Files\IBM\SQLLIB\BIN>db2 -tvf C:\db2_data\test.db2 UPDATE COMMAND OPTIONS...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.