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