14
Only User processes can be KILLed or SYB_TERMINATED.
A process is a task that is being carried out by Adaptive Server. Processes can be initiated by a user giving a command, or by Adaptive Server itself. You can see information about processes by running the system procedure sp_who.
Error 6107 is raised following an improper attempt to kill an Adaptive Server process; for example, it may be raised if you try to kill a background process. The error is raised with the following states:
State |
Meaning |
|---|---|
1 |
Attempted to kill a process that is not a user process (versions earlier than 12.0). |
2 |
Attempted to kill a process that is not a user process or an agent process for quiesce database (version 12.0 and later). |
3 |
Attempted to kill an agent process for quiesce database, but the spid requesting the kill is not the parent process of the agent (version 12.0 and later). |
Use sp_who to check the currently running processes and identify the process in question. Refer to “Killing Processes” in the System Administration Guide: Volume 1 for a description of process status values and the effect of the kill command. If the error was raised when you attempted to clear a “killable” user process, take the following steps:
Perform a checkpoint in each database:
1> use <database_name> 2> go 1> checkpoint 2> go
Shut down the server using the nowait option:
1> shutdown with nowait 2> go
Restart the server.
If you need to terminate a batch program or other application which logs in to Adaptive Server, always terminate the server process first using the kill command before attempting to terminate the batch at the operating system level.
All versions
