Show TOC

create auto partition pathLocate this document in the navigation structure

Creates a partition that automatically resizes according to usage.

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

Related Information