sql0444
Question posted by: subaga
(Guest)
on
November 12th, 2005 06:04 AM
Hi,
I restored a database from AIX machine to a sun machine. The restore
was fine. But, when i try executing stored procedures through my CLI
application, I am getting error sql0444 reason code 4. I tried
rebinding all the routines, but it does not help.
[IBM][CLI Driver][DB2/SUN] SQL0444N Routine "*DCLASSIC" (specific
name "SQL031118125458221") is implemented with code in library or path
".../DB2PERFA/LF_ZDBMAPS/P2545826", function "pgsjmp" which cannot be
accessed. Reason code: "4". SQLSTATE=42724
Does anyone know how to solve this?
db2 udbv8.1 fp3
Thanks,
subash.
1
Answer Posted
Stored procedures are not moved via backup/restore. To move the
libraries to a different os probably your best bet is to re-issue the
ddl used to create them.
subaga wrote:
[color=blue]
> Hi,
>
> I restored a database from AIX machine to a sun machine. The restore
> was fine. But, when i try executing stored procedures through my CLI
> application, I am getting error sql0444 reason code 4. I tried
> rebinding all the routines, but it does not help.
>
> [IBM][CLI Driver][DB2/SUN] SQL0444N Routine "*DCLASSIC" (specific
> name "SQL031118125458221") is implemented with code in library or path
> ".../DB2PERFA/LF_ZDBMAPS/P2545826", function "pgsjmp" which cannot be
> accessed. Reason code: "4". SQLSTATE=42724
>
> Does anyone know how to solve this?
>
> db2 udbv8.1 fp3
>
>
> Thanks,
> subash.[/color]
|
|
|
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 196,829 network members.
Top Community Contributors
|
