Problem while using PUT Routine.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WantedToBeDBA - 31 Dec 2004 05:07 GMT

Hi,
I have used the command

"GET ROUTINE INTO c:\Thiru\Dec31\locktrack.sar FROM PROCEDURE
xxxx.locktrack"

It worked well. When i try to move the same to another server with
the different schema name with the command

"PUT ROUTINE FROM c:\Thiru\Dec31\locktrack.sar"
The error is as follows

SQL0443N Routine "SYSFUN.PUT_ROUTINE_SAR" (specific name
"PUT_SAR1PARM") has
returned an error SQLSTATE with diagnostic text "-20135, 55046, 2".
SQLSTATE=38000

Can any one guess what is the problem? I also need to move some stored
procedures from windows db server to AIX db server? Will the same
problem continue there too?

Need a quick solution.
WantedToBeDBA.
Thiru

Reply to this Message

Jan M. Nelken - 31 Dec 2004 05:35 GMT

> Hi,
> I have used the command
[quoted text clipped - 20 lines]
> WantedToBeDBA.
> Thiru

What happens if you issue DB2 ? SQL20135 from the command line?
What does it say for reason 2?
Do you see where I found both SQLCODE -20135 and Reason Code 2?

Jan M. Nelken

Reply to this Message

dotyet - 31 Dec 2004 15:10 GMT

i don't think the windows db routines will work on aix db as the
architectures are different. you may have to run the source code on
the aix db or you may have to "get" them from on an aix db and then
"put" them on your aix db.

regards,
dotyet

Reply to this Message