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

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"onmode"--,--"O"--)--;------><
                     '-task--'                              

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

Copyright© 2019 HCL Technologies Limited