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, see 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. Example: If 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. Example: 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. Example: S91 if the sub retention period < 91 days.
• For a range based SubPartition on Primary Key, use an integral number increasing by +1. 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

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

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.

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

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