onmode and O arguments: Mark a disabled dbspace as down (SQL administration API)
Use the onmode and O arguments with the admin() or task() function to mark a disabled dbspace as down so that the checkpoint that is being blocked by the disabled dbspace can continue and any blocked threads are released.
Syntax
EXECUTE FUNCTION
{
admin
| task
}
(
"onmode","O"
);
Usage
This function overrides the WAIT mode
of the ONDBSPACEDOWN configuration parameter. Use this command only
in the following circumstances:
- ONDBSPACEDOWN is set to WAIT.
- A disabling I/O error occurs that causes the database server to block all updating threads.
- You cannot or do not want to correct the problem that caused the disabling I/O error.
- You want the database server to mark the disabled dbspace as down and continue processing.
This function is equivalent to the onmode -O command.
Example
The following example marks disabled dbspaces as down:EXECUTE FUNCTION task("onmode","O");