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


1  EXECUTE FUNCTION
1 admin
1 task
2  (
2  "onmode" , "l"
2  ) ;

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;