Changes the
partition file size and the maximum size that you allow for a automatically resizable
Replication Server partition.
Syntax
alter auto partition path <logical_name>
{[auto expand size = <size>]
[max size = <max_size>]}
Parameters
- <logical_name>
-
The name for the logical partition path for an existing automatically
resizable Replication Server partition. The name must conform to the
rules for identifiers. The create auto partition path
and drop auto partition path commands also use
<logical_name> to specify the automatically
resizable partition.
- <size>
-
The size, in megabytes, that you can set for the partition files that
Replication Server can create automatically in the automatically
resizable partition:
- Minimum – 16MB
- Maximum – 1,048,576MB
- <max_size>
-
The limit, in megabytes, that you set for the total size of all
automatically created partition files in the automatically resizable
partition.
- Minimum – 16MB
- Maximum – 2,147,483,647MB
Examples
- Example 1
Increase the size of the partition files to 200MB in the automatically resizable
partition specified in the
auto_uxp logical
partition path
:
alter auto partition path auto_uxp auto expand size = 200
- Example 2
Increase the size of the partition files to 200MB in the automatically resizable
partition specified in the
auto_winp logical
partition path, and increase the limit for the total of all partition
files in
auto_winp to
204,800MB:
alter auto partition path auto_winp auto expand size = 200 max size = 204800
Usage
- You can only use alter auto partition path to change
automatically resizable partitions that you have created with
create auto partition path. You cannot use
alter auto partition path to change partitions
created with any other command.
- alter auto
partition path allows you to expand the size of any new automatically created partition files. This is
useful when Replication Server needs more disk space and there is still
space available in the same disk of the existing logical partition
path.
- If you choose to change auto expand size and max
size, you must specify the values for these parameters as
Replication Server does not provide default values.
Permissions
alter auto partition path requires that the “sybase” user should
own the disk partition or operating system file and must have read and write
permissions on it. Users other than “sybase” should not have write or read
permission on the partition.