Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL error during migration from offline db backup V7.2 to V8.2

Status
Not open for further replies.
Surfeur

Surfeur

Technical User
Oct 12, 2001
14
CZ
Hi, folks.
Please, I've following trouble:

I have try to restore offline backup of database - version 7.2 into the db V8.2. The restore is okay, but when I start migration, i recived following SQL error:
----------------------------------------------------
SQL0440N No authorized routine named "LOCATE" of type "FUNCTION" having
compatible arguments was found. LINE NUMBER=1. SQLSTATE=42884
----------------------------------------------------
The user, groups, directory structures is the same like previous. It is on the platforma AIX 5.2 ML4 and db2 V8.1 FP7a = 8.2

Please, do you have any idea?

Greetings
Vlad
 
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
AS400 Compile Error
Replies
8
Views
383
chuckw0325
C
C
  • Locked
  • Question
STRDBG not bringing up options to set breakpoints
Replies
10
Views
271
chuckw0325
C
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
305
tekpr00
tekpr00
P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
393
prashant_0701
P
MichaelDe
  • Locked
  • Question
SQL Update with File Join
Replies
10
Views
1K
MichaelDe
MichaelDe

Part and Inventory Search

Sponsor

Back
Top