467,118 Members | 996 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,118 developers. It's quick & easy.

Problem with procedure ...

Hi!

We have two (nearly) identical systems, one is a production system, the
second is a quality system.

Becaus of any events, I get an error in the quality system:
SQL0444N Routine "*INTOUSER" (specific name "SQL030826105315132") is
implemented with code in library or path
"...sqlproc/ROLPROD/REAS/P0531516",
function "pgsjmp" which cannot be accessed. Reason code: "4".
SQLSTATE=42724

Fact is, that the procedure did run a while ago and nobody knows, what
was changed in the quality system.

DB2-8.1 Fixpack 4 on z/Linux.

Thanks for any hint.

Dirk
Nov 12 '05 #1
  • viewed: 2277
Share:
7 Replies
Dirk Deimeke wrote:
Hi!

We have two (nearly) identical systems, one is a production system, the
second is a quality system.

Becaus of any events, I get an error in the quality system:
SQL0444N Routine "*INTOUSER" (specific name "SQL030826105315132") is
implemented with code in library or path
"...sqlproc/ROLPROD/REAS/P0531516",
function "pgsjmp" which cannot be accessed. Reason code: "4".
SQLSTATE=42724

Fact is, that the procedure did run a while ago and nobody knows, what
was changed in the quality system.


Have you verified that the library named "P0531516" actually exists in the
directory under sqllib/function?

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2
Knut Stolze:
Have you verified that the library named "P0531516" actually exists in the
directory under sqllib/function?


Yes, it does exist in a subdirectory.

Thanks.

Dirk
Nov 12 '05 #3
I recently set up a new instance to develop stored procs and I too was
getting SQL0444 error referenceing "pgsjmp" errors. I was getting a
different reason code though. My problem was resolved by chnaging the
compile string. Have you checked the compile string, and tried
building the procedure?


Dirk Deimeke <de*****@gmx.de> wrote in message news:<10*************@deimeke.newsoffice.de>...
Knut Stolze:
Have you verified that the library named "P0531516" actually exists in the
directory under sqllib/function?


Yes, it does exist in a subdirectory.

Thanks.

Dirk

Nov 12 '05 #4
Private Pyle:
I recently set up a new instance to develop stored procs and I too was
getting SQL0444 error referenceing "pgsjmp" errors. I was getting a
different reason code though. My problem was resolved by chnaging the
compile string. Have you checked the compile string, and tried
building the procedure?


I have a SQL-procedure with "create procedure ...".

How do i set the compile string?

Greetings

Dirk
Nov 12 '05 #5
Dirk Deimeke <de*****@gmx.de> wrote in message news:<21****************@dirk.deimeke.net>...
Private Pyle:
I recently set up a new instance to develop stored procs and I too was
getting SQL0444 error referenceing "pgsjmp" errors. I was getting a
different reason code though. My problem was resolved by chnaging the
compile string. Have you checked the compile string, and tried
building the procedure?
I have a SQL-procedure with "create procedure ...".

How do i set the compile string?

Greetings


Do you have these two variables set?

DB2_SQLROUTINE_COMPILE_COMMAND
DB2_SQLROUTINE_COMPILER_PATH

Check it out using db2set -all, if not you need to set the path to the
compiler and also set the compile string in the
DB2_SQLROUTINE_COMPILE_COMMAND variable.

Dirk

Nov 12 '05 #6
Private Pyle:
Do you have these two variables set? DB2_SQLROUTINE_COMPILE_COMMAND
DB2_SQLROUTINE_COMPILER_PATH
No.
Check it out using db2set -all, if not you need to set the path to the
compiler and also set the compile string in the
DB2_SQLROUTINE_COMPILE_COMMAND variable.


The same setting (without the variables) works for our production
machine.

I think it is a restore problem.

We restored our production system into a different database on our
quality system. Some references seem to be broken.

Do I have to drop all procedures and then create them again?

Regards

Dirk
Nov 12 '05 #7
How did you resolve this. I have exactly the same problem.

Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Kent Lewandowski | last post: by
4 posts views Thread by Jeff User | last post: by
8 posts views Thread by billmiami2@netscape.net | last post: by
4 posts views Thread by nishi57@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.