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");