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.


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


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;

Copyright© 2018 HCL Technologies Limited