ILM Database Administrator’s Tasks

For a database administrator, there are two key phases involved with managing your data using ILM.

• Preparation Phase - This phase covers the database level configuration that needs to be done before the ILM solution runs in a production environment.

• On-going Maintenance Phase - This phase covers the ongoing maintenance tasks.

Preparation Phase

Note: In order to successfully implement ILM as described here, the following DB Version and Patch are pre-requisites: database version 19.3.0.0 or newer.

The steps needed to enable ILM functionality differ depending on whether ILM is enabled as part of the initial implementation of the product or enabled ILM on an existing implementation where data already exists in the respective tables.

• Initial Install: For an initial installation, the section Module Specific ILM Implementation Details outlines the additional steps to be performed on base delivered ILM Enabled Tables to conform to ILM requirements. In addition, Sample SQL for Enabling ILM in SGG (Initial Installation)provides sample reference DDLs using two maintenance objects as examples.

• Transform NON-ILM implementation to ILM Enabled Implementation: The following steps provide a high level overview of steps that must be performed to implement ILM on enabled MOs for an existing implementation. Please refer to the Sample SQL for Enabling ILM in SGG (Existing Installation) section for detailed information using To Do Entry as an example. Also refer to or detailed information using D1_INIT_MSRMT_DATA as an example.

1. Rename the existing tables (Parent table followed by child table), and primary key index associated with ILM enabled MOs by renaming the tables.

2. Save the DDLs for the secondary indexes as you will need to recreate them later.

3. Drop secondary indexes on the renamed tables.

4. Create Partitioned table with no secondary indexes for ILM enabled MOs using a CTAS operation (Create Table as Select), which will also load the data into the partitioned table structure.

Functional Note: ILM enabled MOs should have the ILM date (ILM_DT) populated when data is moved into the new partitioned table. Please refer to the Module Specific ILM Implementation Details section below for initial load details on which date column to use as the basis for populating the ILM date. Often it is based on Create Date (CRE_DTTM). ILM_ARCH_SW should initially be set to ‘N’.

Note: Certain ILM enabled MOs, specifically IMD, Device Event, and Activity, support more than one retention period also known as sub retention periods. For these MOs the table will be sub-partitioned based on the retention period. Furthermore, a more detailed approach will be required to set both the ILM date (ILM_DT) and the retention period (<field name>). If your implementation does not wish to leverage the ability to define multiple retention periods for these MOs, this note can be ignored and the general guidelines for ILM enablement can be followed. If your implementation wishes to leverage the multiple retention period capability then please refer to the section Module Specific ILM Implementation Details For Sub Retention below.

5. Enable logging option.

6. Create Primary Key index.

7. Create Primary Key Constraint of parent table.

8. Create secondary indexes for the newly-created partitioned tables. This includes creating an index used specifically to benefit the ILM Crawler batch. The recommendation for this index name is to prefix it with "ILM".

Note: This can be created specifying parallel index create; remember to turn off parallelism after the index is created.

9. Follow a similar operation for all child tables for this MO, such as rename child table, and primary key index, generate DDL for secondary index, drop secondary index etc. Sample DDL for child tables their partitioning and indexes can be found in . If sub retention is supported, sample DDL for child tables can be found in . Please note that child table should be partitioned using reference partitioning of the parent table’s partitioning key.

10. Drop the original, renamed tables after verifying the newly created partitioned tables.

11. If sub-retention is not supported, create the ILM specific indexes from section Module Specific ILM Implementation Details.

Table Name	Index Name
CI_TD_ENTRY	CM_ILM_XT039S8
D1_ACTIVITY	CM_ILM_D1T319S1
D1_COMM_IN	CM_ILM_D1T386S1
D1_COMM_OUT	CM_ILM_D1T380S1
D1_COMPL_EVT	CM_ILM_D1T340S1
D1_DVC_EVT	CM_ILM_D1T400S4
D1_INIT_MSRMT_DATA	CM_ILM_D1T304S4
D1_INIT_MSRMT_SNAP	CM_ILM_D1T622L0
D1_MDSI	CM_ILM_D1T565L0
D1_MDSS	CM_ILM_D1T594L0
D1_USAGE	CM_ILM_D1T281S2
D1_USAGE_EXCP	CM_ILM_D1T443S1
D1_VEE_EXCP	CM_ILM_D1T308S2
D1_SP_SNAP_DL	CM_ILM_D1T434S1
D1_SP_UNR_USG_SNAP_DL	CM_ILM_D1T438S1
D1_SP_USG_SNAP_DL	CM_ILM_D1T436S1
D1_SP_VEE_EXCP_SNAP_DL	CM_ILM_D1T440S1
F1_BUS_FLG	CM_ILM_F1T681S2
F1_ERASURE_SCHED	CM_ILM_F1T756S1
F1_MKTMSG_IN	CM_ILM_F1T759L0
F1_MKTMSG_OUT	CM_ILM_F1T782L0
F1_MKTPROC	CM_ILM_F1T768L0
F1_MKTPROC_EVT	CM_ILM_F1T776L0
F1_OBJ_REV	CM_ILM_FT035S6
F1_OUTMSG	CM_ILM_FT010S2
F1_PROC_STORE	CM_ILM_F1T747S1
F1_REMOTE_MSG	CM_ILM_F1T735S7
F1_STATS_SNPSHT	CM_ILM_F1C706S2
F1_SVC_TASK	CM_ILM_F1C474S3
F1_SYNC_REQ	CM_ILM_F1T014S4
F1_SYNC_REQ_IN	CM_ILM_F1T191S3

12. If sub-retention is supported, create the following ILM specific indexes from the Module Specific ILM Implementation Details section:

Table Name	Index Name
CI_TD_ENTRY	CM_ILM_XT039S8
D1_COMM_IN	CM_ILM_D1T386S1
D1_COMM_OUT	CM_ILM_D1T380S1
D1_COMPL_EVT	CM_ILM_D1T340S1
D1_INIT_MSRMT_SNAP	CM_ILM_D1T622L0
D1_MDSI	CM_ILM_D1T565L0
D1_MDSS	CM_ILM_D1T594L0
D1_USAGE	CM_ILM_D1T281S2
D1_USAGE_EXCP	CM_ILM_D1T443S1
D1_VEE_EXCP	CM_ILM_D1T308S2
D1_SP_SNAP_DL	CM_ILM_D1T434S1
D1_SP_UNR_USG_SNAP_DL	CM_ILM_D1T438S1
D1_SP_USG_SNAP_DL	CM_ILM_D1T436S1
D1_SP_VEE_EXCP_SNAP_DL	CM_ILM_D1T440S1
F1_BUS_FLG	CM_ILM_F1T681S2
F1_ERASURE_SCHED	CM_ILM_F1T756S1
F1_MKTMSG_IN	CM_ILM_F1T759L0
F1_MKTMSG_OUT	CM_ILM_F1T782L0
F1_MKTPROC	CM_ILM_F1T768L0
F1_MKTPROC_EVT	CM_ILM_F1T776L0
F1_OBJ_REV	CM_ILM_FT035S6
F1_OUTMSG	CM_ILM_FT010S2
F1_PROC_STORE	CM_ILM_F1T747S1
F1_REMOTE_MSG	CM_ILM_F1T735S7
F1_STATS_SNPSHT	CM_ILM_F1C706S2
F1_SVC_TASK	CM_ILM_F1C474S3
F1_SYNC_REQ	CM_ILM_F1T014S4
F1_SYNC_REQ_IN	CM_ILM_F1T191S3

and the ILM subretention specific indexes from the Module Specific ILM Implementation Details For Sub Retention section:

Table Name	Index Name
D1_ACTIVITY	CM_ILM_D1T319S1
D1_DVC_EVT	CM_ILM_D1T400S4
D1_INIT_MSRMT_DATA	CM_ILM_D1T304S4

Module Specific ILM Implementation Details

This section outlines each maintenance object that has been configured to support ILM. The parent table is noted. Other tables are child tables of the parent unless otherwise noted. In each case, the partitioning strategy is indicated.

All indexes are listed with a recommendation whether the index should be global or local and whether the index should be partitioned. In addition to the base delivered indexes, each parent table includes a recommended ILM specific local index to build with the ILM_DT, ILM_ARCH_SW and the primary key of the table. The recommended column that should be used to populate the ILM_DT is also shown.

This section details the following maintenance objects:

• To Do Entry

• Sync Request (Outbound)

• Inbound Sync Request

• Outbound Message

• Service Task

• Object Revision

• Object Erasure

• Process Flow

• Inbound Market Message

• Outbound Market Message

• Market Process

• Market Process Event

• Business Flag

• Mobile Remote Message

• Statistics Snapshot

• Activity

• Communication In

• Communication Out

• Device Event

• Completion Event

• Initial Measurement Data

• Usage Transaction

• Usage Transaction Exception

• VEE Exception

• Snapshot Tables

• Initial Measurement Snapshot

• Measurement Data Snapshot Interval

• Measurement Data Snapshot Scalar

To Do Entry

This table describes the To Do Entry maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_TD_ENTRY (Parent)	RANGE (ILM_DT, TD_ENTRY_ ID)					CI_TD_ENTRY. CRE_DTTM
		XT039P0	TD_ENTRY_ID	Global Partitioned	RANGE (TD_ENTRY_ID)
		XT039S2	ASSIGNED_TO, TD_ENTRY_ID	Global
		XT039S3	ENTRY_STATUS_FLG, ASSIGNED_TO	Global
		XT039S4	ROLE_ID, TD_TYPE_CD, ENTRY_STATUS_FLG, TD_PRIORITY_FLG, ASSIGNED_TO, CRE_DTTM	Global
		XT039S5	BATCH_CD, BATCH_NBR, ENTRY_STATUS_FLG	Global
		XT039S6	TD_ENTRY_ID, ASSIGNED_TO, ENTRY_STATUS_FLG	Global
		XT039S7	COMPLETE_USER_ID, COMPLETE_DTTM, TD_ENTRY_ID	Global
		XT039S8	ENTRY_STATUS_FLG, TD_TYPE_CD, MESSAGE_CAT_NBR, MESSAGE_NBR	Global
		CM_ILM_XT039S8	ILM_DT, ILM_ARCH_SW, TD_ENTRY_ID	Local Partitioned
CI_TD_ENTRY_CHA	Reference Partitioning	XT701P0	TD_ENTRY_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		XT701S1	SRCH_CHAR_VAL, CHAR_TYPE_CD, TD_ENTRY_ID	Global
		XT701S2	CHAR_VAL_FK1	Global
CI_TD_DRLKEY	Reference Partitioning	XT037P0	TD_ENTRY_ID, SEQ_NUM	Global Partitioned
		XT037S1	KEY_VALUE, TD_ENTRY_ID	Global
CI_TD_LOG	Reference Partitioning	XT721P0	TD_ENTRY_ID, SEQ_NUM	Global Partitioned
		XT721S1	LOG_DTTM,USER_ID, LOG_TYPE_FLG, TD_ENTRY_ID	Global
CI_TD_MSG_ PARM	Reference Partitioning	XT040P0	TD_ENTRY_ID, SEQ_NUM	Global Partitioned
CI_TD_SRTKEY	Reference Partitioning	XT041P0	TD_ENTRY_ID, SEQ_NUM	Global Partitioned
		XT041S1	KEY_VALUE, TD_ENTRY_ID	Global

Sync Request (Outbound)

This table describes the Sync Request (Outbound) maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_SYNC_REQ (Parent)	RANGE (ILM_DT, F1_SYNC_REQ_ ID)				RANGE (F1_SYNC_REQ_ID)	F1_SYNC_REQ. CRE_DTTM
		F1T014P0	F1_SYNC_REQ_ID	Global Partitioned
		F1T014S1	BO_STATUS_CD, BUS_OBJ_CD, F1_SYNC_REQ_ID	Global
		F1T014S2	BO_STATUS_ REASON_CD	Global
		F1T014S3	MAINT_OBJ_CD, PK_VALUE1, PK_VALUE2, F1_SYNC_REQ_ID	Global
		CM_ILM_ F1T014S4	ILM_DT, ILM_ARC_SW, F1_SYNC_REQ_ID	Local Partitioned
F1_SYNC_REQ_CHAR	Reference Partitioning	F1T017P0	F1_SYNC_REQ_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1T017S1	SRCH_CHAR_VAL	Global
F1_SYNC_REQ_EXTRACT	Reference Partitioning	F1T019P0	F1_SYNC_REQ_ID, SEQ_NUM	Global Partitioned
F1_SYNC_REQ_LOG	Reference Partitioning	F1T015P0	F1_SYNC_REQ_ID, SEQNO	Global Partitioned
		F1T015S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		F1T015S2	CHAR_TYPE_CD, CHAR_VAL	Global
		F1T015S3	BO_STATUS_ REASON_CD	Global
F1_SYNC_REQ_LOG_PARM	Reference Partitioning	F1T016P0	F1_SYNC_REQ_ID, SEQNO, PARM_SEQ	Global Partitioned

Note: It is recommended that data retention policies and rules for this object match the policies and rules implemented for the Inbound Sync Request on the target system to avoid data inconsistencies when auditing.

Inbound Sync Request

This table describes the Inbound Sync Request maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_SYNC_REQ_IN (Parent)	RANGE(ILM_DT, F1_SYNC_REQ_IN_ID)				RANGE (F1_SYNC_REQ_IN_ID)	F1_SYNC_REQ_IN.CRE_DTTM
		F1T191P0	F1_SYNC_REQ_ IN_ID	Global Partitioned
		F1T191S1	BO_STATUS_CD, BUS_OBJ_CD, F1_SYNC_REQ_ IN_ID	Global
		F1T191S2	MAINT_OBJ_CD, EXT_PK_VALUE1, NT_XID_CD, PK_VALUE1	Global
		CM_ILM_F1T191S3	ILM_DT, ILM_ARCH_SW, F1_SYNC_REQ_IN_ID	Local Partitioned
F1_SYNC_REQ_ IN_CHAR	Reference Partitioning	F1T193P0	F1_SYNC_REQ_IN_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1T193S1	SRCH_CHAR_VAL	Global
F1_SYNC_REQ_ IN_EXCP	Reference Partitioning	F1T197P0	F1_SYNC_REQ_IN_ID, SEQNO	Global Partitioned
F1_SYNC_REQ_ IN_EXCP_ PARM	Reference Partitioning	F1T198P0	F1_SYNC_REQ_IN_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_SYNC_REQ_ IN_LOG	Reference Partitioning	F1T194P0	F1_SYNC_REQ_IN_ID, SEQNO	Global Partitioned
		F1T194S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		F1T194S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_SYNC_REQ_IN_LOG_PARM	Reference Partitioning	F1T195P0	F1_SYNC_REQ_IN_ ID, SEQNO, PARM_SEQ	Global Partitioned
F1_SYNC_REQ_IN_REL_OBJ	Reference Partitioning	F1T192P0	F1_SYNC_REQ_IN_ID, MAINT_OBJ_CD, REL_OBJ_TYPE_ FLG	Global Partitioned
		F1T192S1	PK_VALUE1	Global

Note: It is recommended that data retention policies and rules for this object match the policies and rules implemented for the Outbound Sync Request on the source system to avoid data inconsistencies when auditing.

Outbound Message

This table describes the Outbound Message maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_OUTMSG (Parent)	RANGE (ILM_DT, OUTMSG_ID)				RANGE (OUMSG_ID)	F1_OUTMSG. CRE_DTTM
		FT010P0	OUTMSG_ID	Global Partitioned
		FT010S1	OUTMSG_STATUS_FLG, OUTMSG_TYPE_CD	Global
		CM_ILM_ FT010S2	ILM_DT, ILM_ARC_SW, OUTMSG_ID	Local Partitioned
F1_OUTMSG_ ERRPARM	Reference Partitioning	FT011P0	OUTMSG_ID, PARM_SEQ	Global Partitioned

Service Task

This table describes the Service Task maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_SVC_TASK (Parent)	RANGE (ILM_DT, F1_SVC_TASK_ ID)				RANGE (F1_SVC_TASK_ ID_)	F1_SVC_TASK. CRE_DTTM
		F1C474P0	F1_SVC_TASK_ID	Global Partitioned
		F1C474S1	F1_STASK_TYPE_CD	Global
		F1C474S2	BUS_OBJ_CD	Global
		CM_ILM_ F1C474S2	ILM_DT, ILM_ARC_SW, F1_SVC_TASK_ID	Local Partitioned
F1_SVC_TASK_ CHAR	Reference Partitioning	F1C476P0	F1_SVC_TASK_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1C476S1	SRCH_CHAR_ VAL	Global
F1_SVC_TASK_ LOG	Reference Partitioning	F1C477P0	F1_SVC_TASK_ ID, SEQNO	Global Partitioned
		F1C477S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		F1C477S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_SVC_TASK_ LOG_PARM	Reference Partitioning	F1C478P0	F1_SVC_TASK_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_SVC_TASK_ REL_OBJ	Reference Partitioning	F1C479P0	F1_SVC_TASK_ ID, MAINT_OBJ_CD, SEQ_NUM	Global Partitioned
		F1C479S1	MAINT_OBJ_CD, PK_VALUE1, PK_VALUE2, PK_VALUE3, PK_VALUE4, PK_VALUE5	Global

Object Revision

This table describes the Object Revision maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_OBJ_REV (Parent)	RANGE (ILM_DT, REV_ID)				RANGE (REV_ID)	F1_OBJ_REV. STATUS_UPD_DTTM
		FT035P0	REV_ID	Global Partitioned
		FT035S1	BO_STATUS_CD, BUS_OBJ_CD, REV_ID	Global
		FT035S2	MAINT_OBJ_CD, PK_VALUE1	Global
		FT035S3	EXT_REFERENCE_ID, MAINT_OBJ_CD	Global
		FT035S4	USER_ID, MAINT_OBJ_CD	Global
		FT035S5	PK_VALUE1	Global
		CM_ILM_ FT035S6	ILM_DT, ILM_ARC_SW, REV_ID	Local Partitioned
F1_OBJ_REV_ CHAR	Reference Partitioning	FT037P0	REV_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		FT037S1	SRCH_CHAR_VAL	Global
F1_OBJ_REV_ LOG	Reference Partitioning	FT039P0	REV_ID, SEQNO	Global Partitioned
F1_OBJ_REV_ LOG_PARM	Reference Partitioning	FT040P0	REV_ID, SEQNO, PARM_SEQ	Global Partitioned

Note: This maintenance object is enabled for ILM, however it is not used in a production environment. It is typically used in a development or configuration environment. Your implementation should review its use of this functionality and consider whether or not it is a candidate for ILM and in which region.

Object Erasure

This table describes the Object Erasure maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_ERASURE_ SCHED (Parent)	RANGE (ILM_DT, ERASURE_SCHED_ID)					F1_ERASURE_ SCHED.STATUS_UPD_DTTM
		F1T756P0	ERASURE_SCHED_ID	GLOBAL Partitioned	RANGE (ERASURE_ SCHED_ID)
		CM_ILM_F1T756S1	ILM_DT, ILM_ARCH_SW, ERASURE_SCHED_ID	LOCAL
F1_ERASURE_ SCHED_LOG	Reference partitioning	F1T757P0	ERASURE_SCHED_ID, SEQNO	GLOBAL Partitioned
F1_ERASURE_ SCHED_LOG_ PARM	Reference partitioning	F1T758P0	ERASURE_SCHED_ID, SEQNO, PARM_SEQ	GLOBAL Partitioned

Process Flow

This table describes the Process Flow maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_PROC_ STORE(Parent)						F1_PROC_STORE.STATUS_UPD_DTTM
		F1T747P0	PROC_STORE_ID	GLOBAL Partitioned	RANGE (PROC_STORE_ ID)
		CM_ILM_ F1T747S1	ILM_DT, ILM_ARCH_SW, PROC_STORE_ID	LOCAL
F1_PROC_ STORE_DTL_ ELEMENTS	Reference partitioning	F1T748P0	PROC_STORE_ID, CHAR_TYPE_CD, SEQ_NUM	GLOBAL Partitioned
F1_PROC_ STORE_LOG	Reference partitioning	F1T749P0	PROC_STORE_ID, SEQNO	GLOBAL Partitioned
F1_PROC_STORE_LOG_PARM	Reference partitioning	F1T750P0	PROC_STORE_ID, SEQNO, PARM_SEQ	GLOBAL Partitioned

Inbound Market Message

This table describes the Inbound Market Message maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_MKTMSG_IN (Parent)	RANGE(ILM_DT, MKTMSG_ID)	F1T759P0	MKTMSG_ID	Global Partitioned	Range(MKTMSG_ID)	F1_MKTMSG_IN.CRE_DTTM
		F1T759S1	BO_STATUS_CD, BUS_OBJ_CD, MKTMSG_ID	Global
		CM_ILM_ F1T759L0	ILM_DT, ILM_ARCH_SW, MKTMSG_ID	Local Partitioned
F1_MKTMSG_IN_CHAR	Reference Partitioning	F1T760P0	MKTMSG_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1T760S1	SRCH_CHAR_VAL	Global
F1_MKTMSG_IN_DATA	Reference Partitioning	F1T761P0	MKTMSG_ID, MKT_DATA_TYPE_FLG	Global Partitioned
F1_MKTMSG_IN_EXT_REF	Reference Partitioning	F1T762P0	MKTMSG_ID, MKT_REF_TYPE_FLG, SEQNO	Global Partitioned
F1_MKTMSG_IN_ID	Reference Partitioning	F1T763P0	MKTMSG_ID, MKT_ID_TYPE_ FLG	Global Partitioned
F1_MKTMSG_IN_LOG	Reference Partitioning	F1T765P0	MKTMSG_ID, SEQNO	Global Partitioned
		F1T765S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		F1T765S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_MKTMSG_IN_LOG_PARM	Reference Partitioning	F1T766P0	MKTMSG_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_MKTMSG_IN_REL_OBJ	Reference Partitioning	F1T767P0	MKTMSG_ID, MKT_REL_OBJ_ TYPE_FLG, SEQNO	Global Partitioned

Outbound Market Message

This table describes the Outbound Market Message maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_MKTMSG_OUT (Parent)	RANGE(ILM_DT,MKTMSG_ ID)	F1T782P0	MKTMSG_ID	Global Partitioned	Range(MKTMSG_ID)	F1_MKTMSG_OUT.CRE_ DTTM
		F1T782S1	BO_STATUS_ CD, BUS_OBJ_CD, MKTMSG_ID	Global
		CM_ILM_F1T782L0	ILM_DT, ILM_ARCH_SW, MKTMSG_ID	Local Partitioned
F1_MKTMSG_OUT_CHAR	Reference Partitioning	F1T783P0	MKTMSG_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		F1T783S1	SRCH_CHAR_ VAL	Global
F1_MKTMSG_OUT_DATA	Reference Partitioning	F1T784P0	MKTMSG_ID, MKT_DATA_ TYPE_FLG	Global Partitioned
F1_MKTMSG_OUT_EXT_REF	Reference Partitioning	F1T785P0	MKTMSG_ID, MKT_REF_TYPE_FLG, SEQNO	Global Partitioned
F1_MKTMSG_OUT_ID	Reference Partitioning	F1T786P0	MKTMSG_ID, MKT_ID_TYPE_FLG	Global Partitioned
F1_MKTMSG_OUT_LOG	Reference Partitioning	F1T788P0	MKTMSG_ID, SEQNO	Global Partitioned
		F1T788S1	CHAR_TYPE_ CD, CHAR_VAL_ FK1	Global
		F1T788S2	CHAR_TYPE_ CD, CHAR_VAL	Global
F1_MKTMSG_OUT_LOG_PARM	Reference Partitioning	F1T789P0	MKTMSG_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_MKTMSG_OUT_REL_OBJ	Reference Partitioning	F1T790P0	MKTMSG_ID, MKT_REL_OBJ_TYPE_FLG, SEQNO	Global Partitioned

Market Process

This table describes the Market Process maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_ MKTPROC (Parent)	Range(ILM_DT, MKT_PROC_ ID)	F1T768P0	MKTPROC_ID	Global Partitioned	Range (MKTPROC_ID)	F1_MKTPROC. CRE_DTTM
		F1T768S1	BO_STATUS_ CD, BUS_OBJ_CD, MKTPROC_ID	Global
		CM_ILM_ F1T768L0	ILM_DT, ILM_ARCH_SW, MKTPROC_ID	Local Partitioned
F1_MKTPROC_CHAR	Reference Partitioning	F1T769P0	MKTPROC_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		F1T769S1	SRCH_CHAR_ VAL	Global
F1_MKTPROC_ID	Reference Partitioning	F1T770P0	MKTPROC_ID, MKT_ID_TYPE_FLG	Global Partitioned
F1_MKTPROC_LOG	Reference Partitioning	F1T772P0	MKTPROC_ID, SEQNO	Global Partitioned
		F1T772S1	CHAR_TYPE_ CD, CHAR_VAL_ FK1	Global
		F1T772S2	CHAR_TYPE_ CD, CHAR_VAL	Global
F1_MKTPROC_LOG_ PARM	Reference Partitioning	F1T773P0	MKTPROC_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_MKTPROC_REL_OBJ	Reference Partitioning	F1T775P0	MKTPROC_ID, MKT_REL_OBJ_TYPE_FLG, SEQNO	Global Partitioned
F1_MKTPROC_REL_ PROC	Reference Partitioning	F1T774P0	MKTPROC_ID, MKTPROC_ REL_ID, MKTPROC_ REL_TYPE_ FLG	Global Partitioned

Market Process Event

This table describes the Market Process Event maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_ MKTPROC_ EVT (Parent)	Range(ILM_DT,MKTPROC_ EVT_ID)	F1T776P0	MKTPROC_ EVT_ID	Global Partitioned	Range(MKTPROC_EVT_ ID)	F1_MKTPROC_EVT.CRE_DTTM
		F1T776S1	MKTPROC_ID	Global
		F1T776S2	MKT_REG_ NBR, BUS_OBJ_CD, BO_STATUS_ CD	Global
		F1T776S3	BO_STATUS_ CD, BUS_OBJ_CD, MKTPROC_ EVT_ID	Global
		CM_ILM_F1T776L0	ILM_DT, ILM_ARCH_ SW, MKTPROC_ EVT_ID	Local Partitioned
F1_MKTPROC_EVT_ CHAR	Reference Partitioning	F1T777P0	MKTPROC_ EVT_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		F1T777S1	SRCH_CHAR_ VAL	Global
F1_MKTPROC_EVT_LOG	Reference Partitioning	F1T779P0	MKTPROC_ EVT_ID, SEQNO	Global Partitioned
		F1T779S1	CHAR_TYPE_ CD, CHAR_VAL_ FK1	Global
		F1T779S2	CHAR_TYPE_CD, CHAR_ VAL	Global
F1_MKTPROC_EVT_LOG_PARM	Reference Partitioning	F1T780P0	MKTPROC_ EVT_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_ MKTPROC_ EVT_REL_ OBJ	Reference Partitioning	F1T781P0	MKTPROC_ EVT_ID, MKT_REL_OBJ_TYPE_FLG, SEQNO	Global Partitioned

Business Flag

This table describes the Business Flag maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_BUS_FLG (Parent)	RANGE (ILM_DT,BUS_FLG_ID)				RANGE(BUS_FLG_ID)	F1_BUS_FLG. CRE_DTTM
		F1T681P0	BUS_FLG_ID	Global Partitioned
		F1T681S1	BUS_OBJ_CD, BO_STATUS_CD, BUS_FLG_ID	Global
		CM_ILM_ F1T681S2	ILM_DT, ILM_ARCH_SW, BUS_FLG_ID	Local Partitioned
F1_BUS_FLG_ CHAR	Reference Partitioning	F1T684P0	BUS_FLG_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1T684S0	SRCH_CHAR_VAL	Global
F1_BUS_FLG_ LOG	Reference Partitioning	F1T685P0	BUS_FLG_ID, SEQNO	Global Partitioned
		F1T685S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		F1T685S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_BUS_FLG_ LOG_PARM	Reference Partitioning	F1T686P0	BUS_FLG_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_BUS_FLG_ REL	Reference Partitioning	F1T682P0	BUS_FLG_ID, BUS_FLG_REL_ TYPE_FLG, SEQ_NUM	Global Partitioned
F1_BUS_FLG_ REL_OBJ	Reference Partitioning	F1T683P0	BUS_FLG_ID, BUS_FLG_REL_ OBJ_TYPE_FLG, SEQ_NUM	Global Partitioned

Mobile Remote Message

This table describes the Mobile Remote Message maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_REMOTE_ MSG (Parent)	RANGE (ILM_DT,F1_REMOTE_MSG_ID)				RANGE(F1_REMOTE_MSG_ID)	F1_REMOTE_MSG.CRE_DTTM
		F1T735P0	F1_REMOTE_MSG _ID	Global Partitioned
		F1T735S1	CRE_DTTM	Global
		F1T735S2	F1_MDT_ID	Global
		F1T735S3	MAINT_OBJ_CD	Global
		F1T735S4	PK_VALUE1	Global
		F1T735S5	F1_DEVICE_MSG_ID	Global
		F1T735S6	F1_MDT_ID, F1_MSG_CLASS_ FLG, F1_DELIVERY_ STATE_FLG	Global
		CM_ILM_ F1T735S7	ILM_DT, ILM_ARCH_SW, F1_REMOTE_MSG_ID	Local Partitioned
F1_REMOTE_MSG_CHAR	Reference Partitioning	F1T736P0	F1_REMOTE_MSG_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1T736S1	SRCH_CHAR_VAL	Global
F1_REMOTE_ MSG_LOG	Reference Partitioning	F1T737P0	F1_REMOTE_MSG_ID, SEQNO	Global Partitioned
		F1T737S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		F1T737S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_REMOTE_ MSG_LOG_ PARM	Reference Partitioning	F1T738P0	F1_REMOTE_MSG_ID, SEQNO, PARM_SEQ	Global Partitioned