DSNX962I csect-name THE Language Environment CEEPIPI SERVICE RETURNED AN UNEXPECTED RETURN CODE rc FOR FUNCTION func SSN= ssn PROC= jclproc ASID= asid WLM_ENV= wlmenv

Explanation

Db2 uses the Language Environment® CEEPIPI service to load and execute user-written stored procedures. The Language Environment return code rc was not expected for the indicated Language Environment function call.
rc
The return code received from CEEPIPI.
func
The function requested by Db2. Possible values are:
add_entry
Add an entry to the Language Environment PIPI table dynamically.
call_main
Run a main program stored procedure using an existing Language Environment run time environment.
call_sub
Run a sub program stored procedure using an existing Language Environment run time environment.
delete_entry
Delete an entry from the Language Environment PIPI table dynamically.
end_seq
End a sequence of calls using CEEPIPI.
identify
Identify the language the module was written in.
init_main
Create Language Environment run time environment.
init_sub_dp
Create Language Environment sub run time environment.
term
Terminate the Language Environment run time environment.
start_seq
Start a sequence of calls using CEEPIPI.
ssn
The name of the Db2 subsystem to which the stored procedures address space was connected.
jclproc
The name of the JCL PROC used to start this stored procedures address space.
asid
The MVS™ ASID of the address space where the CEEPIPI error was encountered.
wlmenv
The name of the WLM application environment where the CEEPIPI error was encountered.

System action

The attempt to run a stored procedure fails. The Db2 stored procedure address space attempts any new stored procedure requests it receives.

System programmer response

The Language Environment return codes from CEEPIPI are documented in Language Environment Programming Guide.

If the values of func and rc are 'ADD_ENTRY' and X'0000000C', the error might be caused by using a compiler that is not Language Environment enabled to create the stored procedure. Db2 stored procedures must be compiled with a compiler that supports Language Environment.

Problem determination

Collect the following diagnostic items:
  • Console output from the system on which the job was run, and a listing of the SYSLOG data set for the period of time that spans the failure.