Report jobs for maintaining old object versions
IBM® Product Master provides two reports for maintaining old object versions.
- IBM MDMPIM Estimate Old Versions Report – This report provides a row count of old object versions in Product Master database table that is based on the criteria that are mentioned in the lookup table.
- IBM MDMPIM Delete Old Versions Report – This report deletes old object versions in Product Master based on the criteria that are mentioned in the lookup table.
These two reports have the following dependent Product Masterobjects:
| Product Master Object Name | Product Master Object Type | Usage |
|---|---|---|
| IBM MDMPIM Estimate Old Versions Script | Script file in docstore directory /scripts/reports/ | Script file that is used by IBM MDMPIM Estimate Old Versions Report |
| IBM MDMPIM Delete Old Versions Script | Script file in docstore directory /scripts/reports/ | Script file that is used by IBM MDMPIM Delete Old Versions Report |
| DB_Queries | Script file in docstore directory /scripts/IBM MDMPIM Data Maintenance/ | Script file that is used by the report jobs |
| IBM MDMPIM Data Maintenance Lookup | Lookup Table | Input parameters that are used by the report jobs |
| IBM MDMPIM Data Maintenance Lookup Spec | Lookup Table Spec | Lookup Table Spec for IBM MDMPIM Data Maintenance Lookup table |
| IBM MDMPIM Data Maintenance Distribution | Distribution | A dummy email distribution that is used by the reports. Modify the distribution with appropriate distribution method. |
Default value of “Days_to_keep” attribute in IBM MDMPIM Data Maintenance lookup table is 0. Hence the default action for IBM MDMPIM Delete Old Versions Report is to delete all old object versions.
Modify the lookup table values per your requirement before you run the IBM MDMPIM Delete Old Versions Report job.
Sample Report:
Estimate Old Versions for Company: ibm
Job run date: 2010-08-09 17:59:39
Old Version data between dates: 2010-04-01 17:55:00 & 2010-04-28
00:56:58
Estimate Old Versions completed
| Database Table Name | Old Version Rows |
|---|---|
TCTG_ICM_ITEM_CATEGORY_MAP |
74844 |
TCTG_ITA_ITEM_ATTRIBUTES |
412500 |
TCTG_ITD_ITEM_DETAIL |
37500 |
TCTG_ITM_ITEM |
37500 |
TCTG_VER_VERSION |
48 |
TAUD_SHI_SIMPLE_HIERARCHY |
0 |
TAUD_SMP_SIMPLE_OBJECT |
0 |
TAUD_SSM_SIMPLE_SIMPLE_MAP |
0 |
TCNT_CNA_CONTAINER_ATTRIBUTES |
0 |
TCNT_EEM_ENTRY_ENTRY_MAP |
0 |
TCNT_EFP_ENTRY_FULL_PATHS |
0 |
TCNT_EHI_ENTRY_HIERARCHY |
0 |
TCNT_ENT_ENTRY |
0 |
TCNT_ESA_ENTRY_SYS_ATTR |
0 |
TCNT_ESM_ENTRY_SPEC_MAP |
0 |
TCNT_ETA_ENTRY_ATTRIBUTES |
0 |
TCTG_AGD_ATTR_GROUP_DYN_NODE |
0 |
TCTG_AGL_ATTR_GROUP_LOCALE |
0 |
TCTG_AGN_ATTR_GROUP_NODE |
0 |
TCTG_CAA_CATALOG_ATTRIBUTES |
0 |
TCTG_CAB_CATEGORY_ATTRIBUTES |
0 |
TCTG_CAD_CATEGORY_DETAIL |
0 |
TCTG_CAT_CATEGORY |
0 |
TCTG_CCM_CATEGORY_CATEGORY_MAP |
0 |
TCTG_CFP_CAT_FULL_PATHS |
0 |
TCTG_CGM_CATALOG_CATALOG_MAP |
0 |
TCTG_CHI_CATEGORY_HIERARCHY |
0 |
TCTG_CSA_CAT_SYS_ATTR |
0 |
TCTG_CSM_CATEGORY_SPEC_MAP |
0 |
TCTG_CTA_CATEG_TREE_ATTRIBUTE |
0 |
TCTG_NOA_NODE_ATTRIBUTES |
0 |
TCTG_NOD_NODE |
0 |
TCTG_NOH_NODE_HIERARCHY |
0 |
TCTG_NOM_NODE_MAPPING |
0 |
TCTG_OBM_OBJECT_MAP |
0 |
TCTG_ODD_ORD_DETAIL |
0 |
TCTG_OMD_OBJECT_MAP_DETAIL |
0 |
TCTG_OMS_OBJECT_MAP_SCRIPTS |
0 |
TCTG_REA_RELATION_ATTRIBUTES |
0 |
TCTG_RGM_RUL_GROUP_MAP |
0 |
TCTG_RUL_INHERITANCE_RULE |
0 |
TCTG_SPA_SPEC_ATTRIBUTES |
0 |
TCTG_TMT_TEST_MULTI_ROW |
0 |