Re: Problem with SQL UDF

From: "Dr.UgoGagliardelli" <do.not.spam.me.please@xxxxxxxxxx>
Date: Wed, 30 Jan 2008 16:31:25 +0100

il 30/01/2008 16.03, Scrive CRPence 40654864:

I have not had a chance to debug this further [somehow I managed to get my process in a deadlock; which I did not yet start to debug], but I can confirm the same results on v5r3 & v5r4. I had assigned RLIB and RVAR to have non-blank defaults, for a quick review before further debug. The RVAR is reset to blanks sometime after the call to the API and before the source statement immediately following; not back to it yet.

Thus for /Why?/, it would seem reasonable to just report this as a defect.

I observed the same behaviour from V5R2 through V5R4 me too (with all DB PTF available).
I will try the support. Thank you.

--
Dr.Ugo Gagliardelli,Modena,ItalyCertifiedUindoscrasherAñejoAlcoolInside
Spaccamaroni andate a cagare/Spammers not welcome/Spammers vão à merda
Spamers iros a la mierda/Spamers allez vous faire foutre/Spammers loop
schijten/Spammers macht Euch vom Acker/Spamerzy wypierdalac'
.

Follow-Ups:
- Re: Problem with SQL UDF
  - From: CRPence

References:
- Problem with SQL UDF
  - From: Dr.UgoGagliardelli
- Re: Problem with SQL UDF
  - From: CRPence

Prev by Date: Re: API QwpzHostPrintTransform failed : CPF3CF2 hptopt = 30
Next by Date: Re: API QwpzHostPrintTransform failed : CPF3CF2 hptopt = 30
Previous by thread: Re: Problem with SQL UDF
Next by thread: Re: Problem with SQL UDF
Index(es):
- Date
- Thread

Relevant Pages

Re: Am I using ThreadPool the right way?
... It is possible to debug deadlocks and other threading issues in the Express version, but it's not something I'd recommend for someone unfamiliar with the general techniques of dealing with thread issues in the first place, since Express doesn't provide any direct way to get at the individual threads in the debugger. ... You'll be looking for threads that are stopped on a statement that waits for some resource, to identify which threads are involved in the deadlock and why they are waiting. ...
(microsoft.public.dotnet.languages.csharp)
Re: [BUG] journal handler reference count breaked and fs deadlocked
... Alex Lyashkov wrote: ... > after recompile kernel with debug jbd and set debug level to 100 i log kernel ... > after deadlock - i see in log ...
(Linux-Kernel)
Re: Problem with SQL UDF
... I have not had a chance to debug this further, but I can confirm the same results on v5r3 & v5r4. ... The RVAR is reset to blanks sometime after the call to the API and before the source statement immediately following; ... DECLARE RLIB VARCHAR; ... If the file is not found the function ends in error, due to the missing API error structure (with a CPF9812 in the joblog as expected), running under debug I can see in the joblog that QUSROBJD was called successfully, if I change the proc name with something that doesn't match a program or service-program name, I can see in the joblog that the program was not found in *LIBL, so I'm pretty sure that the call takes place. ...
(comp.sys.ibm.as400.misc)
Strange behaviour on windows
... programming. ... But if i debug this code in step mode, ... Also my program does eavy usage of malloc and free calls, ... there is a deadlock happening in the MSVCRT library. ...
(microsoft.public.win32.programmer.kernel)
Re: Debugging endless loops
... Let us further assume that it happens in production and you don't know how to reproduce it anywhere else. ... How would you debug this? ... You may think your problem is a deadlock or infinite loop, but your actual problem may be a needed thread has quietly died. ...
(comp.lang.ruby)