Re: Killing process through of a function

Hi Michael,

The software was generated by a CASE tool (genexus) and it's does not
permit any modification.

IBM DB2 have functions that allow the DBA to disconnect some clients.
This is very usefull for database maintenance without giving a shell to him.

VACUUM FULL is other "application" thats needs to run "isolated", and a
function to kill anybody is very usefull.

Thanks for your help.

Alexandre

> Functions written in C, PL/Perl, PL/Tcl, etc., can use whatever
> facilities those languages provide, such as sending signals to
> processes. Whether that's a good idea is another matter.
>
>>Sometimes, the java program that our company uses stay in "idle in
>>transaction" and every day, I need to import a text data to some tables
>>in DB.
>>This import make a TRUNCATE in this tables and I need to kill the
>>remaining process before execute this, to avoid the lock wait.
>
>
> Why does the Java program stay idle while it's in a transaction?
> Are you able to fix the application? If it's not doing anything
> then it should probably COMMIT or ROLLBACK its transactions to
> release any locks they hold.
>