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
| 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");