Hi all,

I have a Cobol-DB2-Cics program that Invokes a DB2 Stored procedure in cobol in another DB2 subsytem. I am getting a sqlcode - 471 on the SQL CALL SP statement.

-471 INVOCATION OF FUNCTION OR PROCEDURE name FAILED DUE TO REASON rc

Can anyone please throw some light on this issue ? This has become a show stopper for my present activity.

Thanks in anticipation

You need to get the Reason Code and look in the Messages and Codes manual.

[Thxs for the reply.

I tracked the return code. It is 00E7900C.
"The WLM application environment name specified for the
user-written routine is not defined or is currently not available for DB2
use in the active WLM policy."

Here it is mentioning that the WLM is defined or active. But we are executing in SPAS environment.

Thats what really confusing. I have no clue..

Pls suggest.

Thxs

[Thxs for the reply.

I tracked the return code. It is 00E7900C.
"The WLM application environment name specified for the
user-written routine is not defined or is currently not available for DB2
use in the active WLM policy."

Here it is mentioning that the WLM is defined or active. But we are executing in SPAS environment.

Thats what really confusing. I have no clue..

Pls suggest.

Thxs

Look in your Create Procedure statements.
It will either have a statement

NO WLM ENVIRONMENT

or

WLM ENVIRONMENT <Name of WLM>