In the datawarehouse, an update process is running. It's taking too long, so I want to kill it. Does anyone know how to do this? What happens if it is demoted to development while it is running? Thanks.

db2 list applications show detail
db2 force application(xx)
this will do
Best Regards, Guy Przytula

Thanks a lot. How about demoting a process while it is running?

No no, do not do that , if you are runing an update process and you kill the process with force command , your process will go to rollback process and you will be in trouble, you should kill the process (as a root) by unix command

kill -9 .....
sometime even this command does not work and you should use db2_kill command
at the worst case you should reboot the system.

Thanks a bunch M RAS. I appreciate the help.