Naming Convention
The naming convention for tablespace, partitions & subpartition is standardized as follows:
• Each name consists of some or all of the following parts.
• The parts of the name are organized hierarchically.
• Each part of the Name is separated with an underscore.
• The maximum name length must not exceed 30 Characters.
• For an MO, the parent table and child table share the same tablespace for the corresponding partition (or sub partition as appropriate).
• Square brackets [ ] indicate that this part of the name should be omitted if not required.
OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME[_SUBPARTITIONNAME][_ARCHIVEFLAG][_COMPRESSFLAG]
For details on the convention, please refer to the table below:
Convention
Description
OWNERFLAG
Owner flag for the relevant application for example “D1” for MDM
TABLE
IDENTIFIER
The Index Name of the Primary Key index without the “P0” suffix. For example, if the PK index name is XT039P0, the table identifier would be “XT039”.
PARTITION
NAME
The Partition name should be prefixed with a P followed by a name which conforms to one of the following standards:
• 4 digit year and 3 letter month abbreviation PYYYYMON corresponding to the ILM date e.g. P2011JAN
• PMAX if it is the Max Value partition
SUBPARTITION
NAME
If subpartitions are used, name should be prefixed with S followed by a name of not more than 5 characters which conforms to the following requirements:
• SMAX if this is the Max Value sub partition
• If the sub partition holds data for a sub retention period use a number equal to that period e.g S91 if the sub retention period < 91 days.
• For a range based SubPartition on Primary Key, use an integral number increasing by +1. For example, if there are 8 sub partitions use S01 through S08
ARCHIVEFLAG
This flag is used as a suffix to the table and tablespace name for the staging tables created for the archiving operation.
• ARC
COMPRESS
FLAG
This flag is used as a suffix to the tablespace name for the staging tables created when compressing a partition.
• C
For compression related tasks, this is used as suffix to the tablespace name.
 
• Partition Tablespace Name: It is formed by OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME

For example:
CM_D1T304_PMAX
CM_D1T304_P2011JAN
• SubPartition Tablespace Name: It is formed by OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME_SUBPARTITIONNAME

For example:
CM_D1T304_PMAX_SMAX
CM_D1T304_P2011JAN_SMAX
CM_D1T304_PMAX_S001
CM_D1T304_P2011JAN_S181
• Archive Staging Table And Its Tablespace Name (When archiving partition): It is formed by OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME_ ARCHIVEFLAG.

For example:
CM_D1T304_P2011JAN_ARC
• Archive Staging Table And Its Tablespace Name (When archiving subpartition): It is formed by OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME_SUBPARTITIONNAME_ ARCHIVEFLAG.

For example:
CM_D1T304_P2011JAN_S181_ARC
• Compressed Tablespace name (When compressing partition):
For example:
CM_D1T304_P2011JAN_ C