Adding partitions

Adding a partition adds a partition to an individual table or a group of tables.

About this task

Partitions are generally added to allow backloading of data into a table or if specific data was being added to a particular table.

Adding partitions outside of the retention period pins them into the database.

Procedure

The syntax to add partitions option is as follows:

part_admin -add [-type] [-subtype] [-tabtype] [-filter] -sdate -edate

Example

The following example adds partitions to all traffic tables in the Neutral GSM Core technology packs from the 1st January 2007 to the 10th January 2007:

part_admin -add -type TECHPACK -subtype "Neutral GSM Core" -tabtype "traffic" 
-sdate 2007010100 -edate 2007011000

The following example adds partitions to the table ERI_BSC_TBF_GSL_TAB from the 1st January 2007 to the 10th January 2007:

part_admin -add -filter "ERI_BSC_TBF_GSL_TAB" -sdate 2007010100 -edate 2007011000