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


>>-EXECUTE FUNCTION--+-admin-+--(--"onmode"--,--"l"--)--;------><
                     '-task--'

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 IBM® Informix® Administrator's Guide.

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;