Firstly, log in to operating system using your SID user. Execute command dpmon to the selected profile. Once connected to DPMON, type m for menu.
--> m Dispatcher-Monitor-Menue ------------------------ d - dispatcher queue statistics p - work-process-admin-table l - work-process-admin-table (long) t - trace level/components for wp w - wp_ca blocks a - appc_ca blocks b - dump binary content of shared memory blocks c - comm adm blocks m - mbuf status s - service buffer status v - tm_ad dump z - sys_ad dump q - quit
Type ‘l’ for full header description of work process.
Workprocess Table (long) Wed Mar 30 02:15:10 2011 ======================== No Ty. Pid Status Start Time Program Cl User Action Table ------------------------------------------------------------------------- 0 DIA 9165 Wait yes 0 1 DIA 7121 Run yes 1516 LSDOC 000 SITI Direct REPO 2 DIA 7122 Run yes 1 200 SAP* Commit 3 DIA 7123 Wait yes 0 4 DIA 7124 Wait yes 0 5 DIA 7125 Run yes 1 200 SAP* Insert BSTEP 6 DIA 7126 Wait yes 0 7 DIA 8234 Wait yes 0 8 DIA 7128 Wait yes 0 9 DIA 7129 Wait yes 0 10 UPD 7130 Wait yes 0 11 ENQ 7131 Wait yes 0 12 BTC 7132 Wait yes 0 13 BTC 7133 Wait yes 0 14 BTC 7134 Wait yes 0 15 SPO 7135 Wait yes 0 16 UP2 7136 Wait yes 0 s - stop workprocess k - kill workprocess (with core) r - enable restart flag (only possible in wp-status "ended") q - quit m - menue
From here, you can either stop or kill the work process. Select s to stop the work process
--> s Which workprocess do you want to kill (c to cancel) ? 1 Do you really want to kill workprocess 1 with pid 7121 ? y
Select k to kill the work process (with core)
--> s Which workprocess do you want to kill (c to cancel) ? 1 Do you really want to kill workprocess 1 with pid 7121 ? y
