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 MDM (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 MDM (Existing Installation) section for detailed information using To Do Entry as an example. Also refer to Sample SQL for Enabling ILM with Sub Retention in MDM (Existing Installation) 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 Sample SQL for Enabling ILM in MDM (Existing Installation). If sub retention is supported, sample DDL for child tables can be found in Sample SQL for Enabling ILM with Sub Retention in MDM (Existing Installation). 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
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)
 
 
 
RANGE(TD_ENTRY_ID)
CI_TD_ENTRY.CRE_DTTM
 
Reference Partitioning
XT039P0
TD_ENTRY_ID
Global
Partitioned
 
 
 
 
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_XT039L0
ILM_DT,ILM_ARCH_SW,TD_ENTRY_ID
Local
 
 
CI_TD_DRLKEY
Reference Partitioning
XT037P0
TD_ENTRY_ID,SEQ_NUM
Global Partitioned
 
 
 
 
XT037S1
KEY_VALUE,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
 
 
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_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
 
 
 
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
 
Reference Partitioning
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_F1T014L0
ILM_DT,ILM_ARCH_SW,F1_SYNC_REQ_ID
Local
 
 
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_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
 
Global
 
 
F1_SYNC_REQ_LOG_
PARM
Reference Partitioning
F1T016P0
 
Global Partitioned
 
 
F1_SYNC_REQ_EXTRACT
Reference Partitioning
F1T019P0
 
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
 
Reference Partitioning
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
 
 
 
 
F1T191S3
EXT_REFERENCE_ID
Global
 
 
 
 
CM_ILM_F1T191L0
ILM_DT,ILM_ARCH_SW,F1_SYNC_REQ_IN_ID
Local
 
 
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(OUTMSG_ID)
F1_OUTMSG.CRE_DTTM
 
Reference Partitioning
FT010P0
OUTMSG_ID
Global Partitioned
 
 
 
 
FT010S1
OUTMSG_STATUS_FLG,OUTMSG_TYPE_CD
Global
 
 
 
 
FT010S2
NT_XID_CD,CRE_DTTM,OUTMSG_STATUS_FLG
Global
 
 
 
 
CM_ILM_FT010L0
ILM_DT,ILM_ARCH_SW,OUTMSG_ID
Local
 
 
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
 
Reference Partitioning
F1C474P0
F1_SVC_TASK_ID
Global Partitioned
 
 
 
 
F1C474S1
F1_STASK_TYPE_CD
Global
 
 
 
 
F1C474S2
BUS_OBJ_CD
Global
 
 
 
 
F1C474S3
BO_STATUS_CD,BUS_OBJ_CD,F1_SVC_TASK_ID
Global
 
 
 
 
CM_ILM_F1C474L0
ILM_DT,ILM_ARCH_SW,F1_SVC_TASK_ID
Local
 
 
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
 
Reference Partitioning
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_FT035L0
ILM_DT,ILM_ARCH_SW,REV_ID
Local
 
 
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)
 
 
 
RANGE(ERASURE_SCHED_ID)
F1_ERASURE_SCHED.STATUS_UPD_DTTM
 
Reference Partitioning
F1T756P0
ERASURE_SCHED_ID
Global Partitioned
 
 
 
 
F1T756S1
BO_STATUS_CD,BUS_OBJ_CD,ERASURE_SCHED_ID
Global
 
 
 
 
CM_ILM_F1T756L0
ILM_DT,ILM_ARCH_SW,ERASURE_SCHED_ID
Local
 
 
F1_ERASURE_SCHED_LOG_PARM
Reference Partitioning
F1T758P0
ERASURE_SCHED_ID,SEQNO,PARM_SEQ
Global Partitioned
 
 
F1_ERASURE_SCHED_LOG
Reference Partitioning
F1T757P0
ERASURE_SCHED_ID,SEQNO
Global Partitioned
 
 
 
 
F1T757S1
CHAR_TYPE_CD,CHAR_VAL_FK1
Global
 
 
 
 
F1T757S2
CHAR_TYPE_CD,CHAR_VAL
Global
 
 
 
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)
RANGE(ILM_DT,PROC_STORE_ID)
 
 
 
RANGE(PROC_STORE_ID)
F1_PROC_STORE.STATUS_UPD_DTTM
 
Reference Partitioning
F1T747P0
PROC_STORE_ID
Global Partitioned
 
 
 
 
F1T747S1
BO_STATUS_CD,BUS_OBJ_CD,PROC_STORE_ID
Global
 
 
 
 
CM_ILM_F1T747L0
ILM_DT,ILM_ARCH_SW
Local
 
 
F1_PROC_STORE_LOG_PARM
Reference Partitioning
F1T750P0
PROC_STORE_ID,SEQNO,PARM_SEQ
Global Partitioned
 
 
F1_PROC_STORE_DTL_ELEMENTS
Reference Partitioning
F1T748P0
PROC_STORE_ID,CHAR_TYPE_CD,SEQ_NUM
Global Partitioned
 
 
 
 
F1T748S1
SRCH_CHAR_VAL
Global
 
 
F1_PROC_STORE_LOG
Reference Partitioning
F1T749P0
PROC_STORE_ID,SEQNO
Global Partitioned
 
 
 
 
F1T749S1
CHAR_TYPE_CD,CHAR_VAL_FK1
Global
 
 
 
 
F1T749S2
CHAR_TYPE_CD,CHAR_VAL
Global
 
 
 
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)
 
 
 
RANGE(MKTMSG_ID)
F1_MKTMSG_IN.CRE_DTTM
 
Reference Partitioning
F1T759P0
MKTMSG_ID
Global Partitioned
 
 
 
 
F1T759S1
BO_STATUS_CD,BUS_OBJ_CD,MKTMSG_ID
Global
 
 
 
 
F1T759S2
CRE_DTTM,F1_MKTMSG_TYPE_CD,MKT_PARTCPT
Global
 
 
 
 
F1T759S3
MKT_REG_NBR
Global
 
 
 
 
CM_ILM_F1T759L0
ILM_DT,ILM_ARCH_SW,MKTMSG_ID
Local
 
 
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_CHAR
Reference Partitioning
F1T760P0
MKTMSG_ID,CHAR_TYPE_CD,SEQ_NUM
Global Partitioned
 
 
 
 
F1T760S1
SRCH_CHAR_VAL
Global
 
 
F1_MKTMSG_IN_REL_OBJ
Reference Partitioning
F1T767P0
MKTMSG_ID,MKT_REL_OBJ_TYPE_FLG,SEQNO
Global Partitioned
 
 
 
 
F1T767S1
MAINT_OBJ_CD,MKT_REL_OBJ_TYPE_FLG,PK_VALUE1
Global
 
 
F1_MKTMSG_IN_DATA
Reference Partitioning
F1T761P0
MKTMSG_ID,MKT_DATA_TYPE_FLG
Global Partitioned
 
 
F1_MKTMSG_IN_ID
Reference Partitioning
F1T763P0
MKTMSG_ID,MKT_ID_TYPE_FLG
Global Partitioned
 
 
 
 
F1T763S1
MKT_ID_TYPE_FLG,MKT_ID_VALUE
Global
 
 
F1_MKTMSG_IN_LOG_PARM
Reference Partitioning
F1T766P0
MKTMSG_ID,SEQNO,PARM_SEQ
Global Partitioned
 
 
F1_MKTMSG_IN_EXT_REF
Reference Partitioning
F1T762P0
MKTMSG_ID,MKT_REF_TYPE_FLG,SEQNO
Global Partitioned
 
 
 
 
F1T762S1
MKT_REF_TYPE_FLG,EXT_REF_VAL
Global
 
 
 
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)
 
 
 
RANGE(MKTMSG_ID)
F1_MKTMSG_OUT.CRE_DTTM
 
Reference Partitioning
F1T782P0
MKTMSG_ID
Global Partitioned
 
 
 
 
F1T782S1
BO_STATUS_CD,BUS_OBJ_CD,MKTMSG_ID
Global
 
 
 
 
F1T782S2
MKT_PARTCPT,F1_MKTMSG_TYPE_CD,CRE_DTTM
Global
 
 
 
 
F1T782S3
OUTMSG_ID
Global
 
 
 
 
F1T782S4
MKTPROC_ID
Global
 
 
 
 
F1T782S5
MKT_REG_NBR
Global
 
 
 
 
CM_ILM_F1T782L0
ILM_DT,ILM_ARCH_SW,MKTMSG_ID
Local
 
 
F1_MKTMSG_OUT_LOG_PARM
Reference Partitioning
F1T789P0
MKTMSG_ID,SEQNO,PARM_SEQ
Global 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_REL_OBJ
Reference Partitioning
F1T790P0
MKTMSG_ID,MKT_REL_OBJ_TYPE_FLG,SEQNO
Global Partitioned
 
 
 
 
F1T790S1
MAINT_OBJ_CD,MKT_REL_OBJ_TYPE_FLG,PK_VALUE1
Global
 
 
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_EXT_REF
Reference Partitioning
F1T785P0
MKTMSG_ID,MKT_REF_TYPE_FLG,SEQNO
Global Partitioned
 
 
 
 
F1T785S1
MKT_REF_TYPE_FLG,EXT_REF_VAL
Global
 
 
F1_MKTMSG_OUT_DATA
Reference Partitioning
F1T784P0
MKTMSG_ID,MKT_DATA_TYPE_FLG
Global Partitioned
 
 
F1_MKTMSG_OUT_ID
Reference Partitioning
F1T786P0
MKTMSG_ID,MKT_ID_TYPE_FLG
Global Partitioned
 
 
 
 
F1T786S1
MKT_ID_TYPE_FLG,MKT_ID_VALUE
Global
 
 
 
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,MKTPROC_ID)
 
 
 
RANGE(MKTPROC_ID)
F1_MKTPROC.CRE_DTTM
 
Reference Partitioning
F1T768P0
MKTPROC_ID
Global Partitioned
 
 
 
 
F1T768S1
BO_STATUS_CD,BUS_OBJ_CD,MKTPROC_ID
Global
 
 
 
 
F1T768S2
MKTPROC_TYPE_CD,CRE_DTTM
Global
 
 
 
 
CM_ILM_F1T768L0
ILM_DT,ILM_ARCH_SW,MKTPROC_ID
Local
 
 
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_ID
Reference Partitioning
F1T770P0
MKTPROC_ID,MKT_ID_TYPE_FLG
Global Partitioned
 
 
 
 
F1T770S1
MKT_ID_TYPE_FLG,MKT_ID_VALUE
Global
 
 
F1_MKTPROC_CHAR
Reference Partitioning
F1T769P0
MKTPROC_ID,CHAR_TYPE_CD,SEQ_NUM
Global Partitioned
 
 
 
 
F1T769S1
SRCH_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)
 
 
 
RANGE(MKTPROC_EVT_ID)
F1_MKTPROC_EVT.CRE_DTTM
 
Reference Partitioning
F1T776P0
MKTPROC_EVT_ID
Global Partitioned
 
 
 
 
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
 
 
F1_MKTPROC_EVT_REL_OBJ
Reference Partitioning
F1T781P0
MKTPROC_EVT_ID,MKT_REL_OBJ_TYPE_FLG,SEQNO
Global Partitioned
 
 
 
 
F1T781S1
MAINT_OBJ_CD,PK_VALUE1,PK_VALUE2,PK_VALUE3,PK_VALUE4,PK_VALUE5
Global
 
 
 
 
F1T781S2
MAINT_OBJ_CD,MKT_REL_OBJ_TYPE_FLG,PK_VALUE1
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_CHAR
Reference Partitioning
F1T777P0
MKTPROC_EVT_ID,CHAR_TYPE_CD,SEQ_NUM
Global Partitioned
 
 
 
 
F1T777S1
SRCH_CHAR_VAL
Global
 
 
 
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
 
Reference Partitioning
F1T681P0
BUS_FLG_ID
Global Partitioned
 
 
 
 
F1T681S1
BO_STATUS_CD,BUS_OBJ_CD,BUS_FLG_ID
Global
 
 
 
 
CM_ILM_F1T681L0
ILM_DT,ILM_ARCH_SW
Local
 
 
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