alter plog argument: Change the physical log (SQL administration API)

Use the alter plog argument with the admin() or task() function to change the location and size of the physical log.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->
                     '-task--'      

>--"alter plog"--,--"dbspace"--+--------------------+--)--;----><
                               '-,--"phys_log_size"-'         

Element Description Key Considerations
dbspace The location of the physical log. The space allocated for the physical log must be contiguous.
phys_log_size The size, specified in kilobytes, of the physical log. See admin() and task() Argument Size Specifications.

Usage

To change only the size, specify the current dbspace of the physical log.

This function is equivalent to the onparams -p command.

Example

The following example moves the physical log to a dbspace called phsdbs:

EXECUTE FUNCTION task ("alter plog","physdbs","49 M");

Copyright© 2019 HCL Technologies Limited