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
| task
}
(
"onmode","l"
);
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 OneDB™ 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;