create auto partition path

Syntax

create auto partition path logical_name 
on 'physical_path'
with auto expand size = size
max size = max_size

Parameters

logical_name – The name for the logical partition path for the automatically resizable Replication Server partition. Replication Server automatically creates partition files according to usage and assigns the files to the logical partition path. The name must conform to the rules for identifiers. The drop auto partition path and alter auto partition path commands also use logical_name to specify the automatically resizable partition.
physical_path – The physical location for the partition files that Replication Server automatically creates. You must provide a valid physical path and you must enclose physical_path in single quotation marks.
size – The size, in megabytes, that you can set for a partition file 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 – Create the auto_uxp logical partition path on the /usr/user1 path, with a partition file size of 100MB, and automatically add a new 100MB partition file to auto_uxp every time the partition file reaches 80% usage, and limit the total for all automatically created partition files to102,400MB :
```
create auto partition path  auto_uxp on '/usr/user1' 
with auto expand size=100 max size=102400
```
Example 2 – Create the auto_winp logical partition path on the c:\repserver\partitions\auto Windows directory, with a partition file size of 100MB, and automatically add a new 100MB partition file to auto_uxp every time the partition file reaches 80% usage, and limit the total for all automatically created partition files to102,400MB :
```
create auto partition path  auto_winp on 'c:\repserver\partitions\auto' 
with auto expand size=100 max size=102400
```

Usage

Replication Server uses partitions for stable message queues. The message queues hold data until Replication Server sends the data to the relevant destination.
You cannot create a automatically resizable partition on a raw device.
You can only create an automatically resizable partition file on an operating system file.
You must specify the values for auto expand size and max size as Replication Server does not provide a default value for these parameters.
Replication Server automatically creates a new partition file every time partition usage reaches 80%.
Replication Server automatically conserves disk space if consumption of the partition drops, by removing the last partition file that was added in a automatically resizable partition, if the file becomes empty. To improve response time and replication performance in case there are rapid fluctuations in disk consumption, Replication Server delays the shrinking of the partition until the total partition usage without the last partition file is lower than 50%.

Replication Server removes the dropped partition file but does not drop the physical partition file from the file system. To recycle the disk space, you must drop the physical file manually.
Replication Server names the partition files that it automatically creates according to the "logical_name"_"partition_number" format, where partition number is a ten-digit number that Replication Server generates automatically and increases sequentially from 0000000001 to 2147483647 with each file that Replication Server adds. Replication Server can automatically grow or shrink partitions only with partition files named using this format. All other partitions must be manually managed by Replication Server administrators.
Warning! Do not manually delete files in the partition physical location with names that follow the logical name_partition number format as the partition files may contain data, unless the partition file has not been used by Replication Server. You can use admin disk_space to check if Replication Server is using the partition file. Consult the system administrator or technical support.
You can create multiple automatically resizable partitions but each partition must have a unique physical path or logical name, and sufficient disk space.
You cannot use the logical name or physical path of an existing automatically resizable partition when you create a new partition with create partition.
Ensure that you have sufficient disk space before you create partitions as create auto partition path does not check for available disk space
You cannot use the disk_affinity parameter to select automatically resizable partitions for partition affinity. See Select Disk Partitions for Stable Queues in the Replication Server Administration Guide Volume 2.

Permissions

create 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..