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 |
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 |
Table Name | Index Name |
---|---|
D1_ACTIVITY | CM_ILM_D1T319S1 |
D1_DVC_EVT | CM_ILM_D1T400S4 |
D1_INIT_MSRMT_DATA | CM_ILM_D1T304S4 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |