You can use OSWM to monitor and terminate processes connected to Adaptive Servers within an OpenSwitch environment.
Select the OpenSwitch server you want to monitor.
Select the Processes folder to all processes connected to the OpenSwitch server. You can view the Adaptive Servers and pools the processes are connected to.
Select a process.
Select File | Properties:
Select the General tab to view these properties:
Process ID.
Type.
Application type – the application name such as, isql.
Login – the user name used by the application to log in to Adaptive Server.
State – the current status of the process.
Select the Parameters tab to view these parameters:
Remote Adaptive Server ID – the process ID (spid) of the process.
Action – pending actions that an administrator initiated or pending actions that arise internally such as Adaptive Server failure: DEADLOCK, NORETRY, SERVER, STIME, STOP, or SWITCH. See Table 7-16 for descriptions of each type of action.
Host Name – OpenSwitch server host name.
Database – the name of the database that the process is connected to.
Current Adaptive Server – the Adaptive Server that the process is currently connected to.
Next Adaptive Server – the Adaptive Server that the process can switch to.
Pool – the pool that contains the Adaptive Servers that the process connects to currently.
Select the OpenSwitch server on which you want to terminate a process.
Select the Processes folder then select a process.
Select Edit | Delete.
Select Yes to confirm and terminate the process.
Monitoring processes