Killing a long running tuxedo service or a query.
Before you kill any service you need to identify the service to be killed. Find out from the database which pid is stuck or go to /psappsrv and run the psadmin to take a look at the server status to see which query is not idle
Go to /psappsrv location
type psadmin and hit enter
select your domain and choose “TUXEDO command line”
at the command line issue the following command
>psr (This will show you the services running)
then type the following at command prompt and hit enter.
>v (This will turn on the verbose option)(v again will turn it off)
then type the following command to kill the long running proceess id.
>shutdown -i 25 -w 30 (-i = server id, -w = delay before forcing the server down (in seconds))
NOTE: Server id should match with your pid in the database query. you need to use the -w option as the service will wait for the clients to finish their transactions