alter auto partition path

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.