ha set ipl argument: Log index builds on the primary server (SQL administration API)

Use the ha set ipl argument with the admin() or task() function to control whether to log index builds on the primary server.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--+-"ha set ipl off"-+--)--;--><
                     '-task--'     '-"ha set ipl on"--'         

Usage

Run this function on an established primary server to enable or disable the logging of index builds. This function resets the value of the LOG_INDEX_BUILDS configuration parameter in the ONCONFIG file.

You can run this function on any type of primary server.

This function is equivalent to the onmode -wf LOG_INDEX_BUILDS command.

Example

The following example enables the logging of index builds:
EXECUTE FUNCTION task("ha set ipl on");

Copyright© 2019 HCL Technologies Limited