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 |