SQL error code as -471(DB2 subroutine cannot be called)

chitra_chaturvedi · New User Joined: 24 Jul 2007 Posts: 18 Location: india

Hi,

I have a main program A (Batch DB2) which calls a stored procedure B. while calling B from A , I get SQL error code as -471(DB2 subroutine cannot be called properly).
I also have another stored proc D which is successfully called by another batch DB2 program C.

Both A and B were complied in similar way as C and D via changeman.
But I was getting -471 for A and B only.
I even copied the same code from C and D in A and B respectively (just to make sure that this was not because of any coding issue) but still I t was giving same error.

I guess it has something to do with the changeman only. Any pointers??????????

This might look like a simple problem but I spen whole day resolving this. Please excuse me if there is some simple solution to this problem which I am not able to think.

Thanks in advance.

Big C

Thanks for help in advance.

dick scherrer · Posted: Sat May 29, 2010 12:43 am

Hello,

Is there some reason you did not post the reason code?

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnmcj10/2.1.6.194

chitra_chaturvedi · New User Joined: 24 Jul 2007 Posts: 18 Location: india

Thanks Dick,

I am not able to see any reason code.

Also I am feeling that somehow some entry has not been made in some table for the stored procedure.

Could you please let me know in what all places a DB2 stored procedure is registered?

Thanks

Pradip kumar Mohanty · New User Joined: 16 Sep 2007 Posts: 33 Location: India

Chitra,

Information about stored procedures is stored in SYSIBM.SYSROUTINES catalog table and all the parameters should be be in SYSIBM.SYSPARMS.

I would advise you to revisit the preparation steps. Is it link-edited with either DSNALI or DSNRLI ( per the attachment facility you want to use).

Regards,
Pradip Mohanty
TSYS International.

ashimer · Posted: Sat May 29, 2010 7:49 pm

First check whether your routine is in stop state from DB2 command line. If its stopped, start it.
Secondly check whether the SP has been defined correctly to run in the required WLM env.

dbzTHEdinosauer · Posted: Sat May 29, 2010 7:55 pm

if the TS would bother to look at the sqlca msgs provided at receipt of sql code -471,
he would have the reason code available,
and thus not have to check everything under the sun.

that is why reason codes are provided.

considering the level of skill of the TS,
having him check on the status of anything is probably above his level.

teach him how to find the reason code,
and in the future the TS may have more developed debugging skills.

dineshsam · New User Joined: 30 Aug 2007 Posts: 1 Location: Chennai

Hi,

I guess the following link will help you..

publib.boulder.ibm.com/infocenter/pdthelp/v1r1/index.jsp?topic=/com.ibm.debugtool.doc_6.1/eqa6ug02420.htm

Thanks,
Dinesh