Help in Stored Procedure

Ramakrishnan

Help in Stored Procedure
Hi All,
my problem:

I am telnetting to a Linux box (Redhat 7.1) with DB2 Ver 7.1.

I created, compiled and registered a stored procedure (written in C).
I test this SP with the IBM SP Builder.

Then, I CALL this SP from my client program (again in C). It executes without any
error. Now, after repeated CALLS to this SP, at some point the SP fails...:-(

Upon dropping the SP and re-registering it again works fine for the first few times and then again fails.

Can anyone help me with this?

Regards,
CP

Peter J Krawetzky

Re: Help in Stored Procedure
(in response to Ramakrishnan)
What error messages are you getting?


Peter J. Krawetzky, DBA
IBM Certified Solutions Expert
DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2


-----Original Message-----
From: Ramakrishnan [mailto:[login to unmask email]
Sent: Tuesday, January 08, 2002 12:32 PM
To: [login to unmask email]
Subject: Help in Stored Procedure



Hi All,
my problem:

I am telnetting to a Linux box (Redhat 7.1) with DB2 Ver 7.1.

I created, compiled and registered a stored procedure (written in C).
I test this SP with the IBM SP Builder.

Then, I CALL this SP from my client program (again in C). It executes
without any
error. Now, after repeated CALLS to this SP, at some point the SP
fails...:-(

Upon dropping the SP and re-registering it again works fine for the first
few times and then again fails.

Can anyone help me with this?

Regards,
CP


Ramakrishnan

Re: Help in Stored Procedure
(in response to Peter J Krawetzky)
I am not getting any error message as such. However, when i run it from the IBM SP Builder (after failure), it displays "No results returned from the stored procedure"

One more thing, from the archives i got this information:

"There is a DSNZPARM parameter (STORMAX) which controls the number of
allowable abends before the stored procedure is put in STOPABN status"

and.....

"I did find a zparm parameter (stormxab) which you can
set from 0 to 255 to indicate how many abends you can have before a stored
procedure is put out of service"

Can anyone tell me how to set this ???......i'm quite new to this....;)

Regards,
CP
----- Original Message -----
From: Krawetzky, Peter J
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Tuesday, January 08, 2002 11:53 PM
Subject: Re: Help in Stored Procedure


What error messages are you getting?

Peter J. Krawetzky, DBA
IBM Certified Solutions Expert
DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2


-----Original Message-----
From: Ramakrishnan [mailto:[login to unmask email]
Sent: Tuesday, January 08, 2002 12:32 PM
To: [login to unmask email]
Subject: Help in Stored Procedure



Hi All,
my problem:

I am telnetting to a Linux box (Redhat 7.1) with DB2 Ver 7.1.

I created, compiled and registered a stored procedure (written in C).
I test this SP with the IBM SP Builder.

Then, I CALL this SP from my client program (again in C). It executes without any
error. Now, after repeated CALLS to this SP, at some point the SP fails...:-(

Upon dropping the SP and re-registering it again works fine for the first few times and then again fails.

Can anyone help me with this?

Regards,
CP