onmode and l arguments: Switch to the next logical log (SQL administration API)

Use the onmode and l arguments with the admin() or task() function to switch the current logical-log file to the next logical-log file.

Syntax

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

Usage

This function is equivalent to the onmode -l command.

For information on switching to the next logical-log file, see the section on managing logical-log files in the HCL Informix® Administrator's Guide.

Example

The following example moves the logical log out of the root chunk
SELECT task("onmode", "l") FROM sysmaster:syslogfil
   WHERE chunk = 1 AND sysmaster:bitval(flags,"0x02")>0;

Copyright© 2019 HCL Technologies Limited