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.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
