create partition

Syntax

create partition logical_name
on 'physical_name' with size size
[starting at vstart]

Parameters

logical_name – A name for the partition. The name must conform to the rules for identifiers. The name is also used in the drop partition and alter partition commands.
physical_name – The full specification of the partition. This name must be enclosed in single quotation marks.
size – The size, in megabytes, of the partition. Maximum size possible is 1TB.
starting at vstart – Specifies the number of megabytes (vstart) to offset from the beginning of the partition.

Examples

Example 1 – Adds a 20MB partition named P1 on the device named /dev/rsd0a:
```
create partition P1 on '/dev/rsd0a' with size 20
```
Example 2 – Adds a 20MB partition named P1 on the device named /dev/rsd0a. Since an offset of 1MB is specified, however, the total usable partition space available to Replication Server is 19MB:
```
create partition P1 on '/dev/rsd0a' with size 20
 starting at 1
```

Usage

Replication Server uses partitions for stable message queues. The message queues hold data until it is sent to its destination.
Increasing the available disk space in partitions allows Replication Server to support more routes and database connections and to continue to queue messages during longer failures.
The maximum size for a partition is 1TB, which is approximately 1,000,000MB.
Disk partitions must not be mounted for use by the operating system and should not be used for any other purpose, such as for swap space or an Adaptive Server disk device.
Allocate the entire partition to Replication Server. If you allocate part of a partition for Replication Server, you cannot use the remainder for any other purpose. If you use the starting at vstart clause, the partition space available to Replication Server is what is left after you subtract the offset size from the total partition size.
The starting at vstart clause makes space available at the beginning of the partition for disk mirroring information.
You can use operating system files for partitions. However, the operating system buffers file I/O, so you may not be able to recover stable queues completely following a failure. To avoid this potential failure, when you use operating system files for partitions, set the sqm_write_flush to on or dio in the configure replication server command.

Note: In Microsoft Windows operating systems, do not use a raw device to create a partition.
If the Replication Server disk partition is a raw device, the disk partition must exist before you can complete the Disk Partition Information window in rs_init. If you did not define the partition previously, follow the instructions in Creating a Disk Partition in the Replication Server Configuration Guide. However, if the disk partition is an operating system file, Replication Server automatically creates the disk partition if the partition does not already exist.
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.

Permissions

create partition requires “sa” permission.