Untitled

mail@pastecode.io avatarunknown
plain_text
a month ago
10 kB
1
Indexable
Never
part-a
Count for PPM_PRODUCT_COMPONENT_REF_MAP: 3 ---------------------MASTER-AUDIT------------------
Count for PPM_POLICY_PARAMS: 0 ---------------------MASTER-AUDIT------------------
Count for PPM_POLICY_PARAMS_AUD: 0 ---------------------AUDIT-CHILD------------------
Count for TCARE_PPM_PRODUCT: 29 (master) 11
Count for TCARE_PPM_PRODUCT_COMPONENTS: 11 (master) 21
Count for COMPONENT_DEFINITION: 11 (master) 31
Count for TCARE_PPM_PRODUCT_ATTRIBUTES: 4 (master) 41
Count for TCARE_PPM_PACKAGE: 13 (master) 51
Count for TCARE_PPM_PACKAGE_PRODUCT_MAP: 13 (master) 61
Count for TCARE_PPM_OFFERABILITY_RULE: 5 (master) 71
Count for PPM_OFFERABLE_RULE_PRODUCT_MAP: 0 (master) 81
Count for PPM_CONDITIONAL_RULE_GROUP: 0 (master) 91
Count for PPM_CONDITIONAL_RULE: 0 (master) 101
Count for PPM_RULE_CONDITION: 0 (master) 111
Count for PPM_RULE_ACTION: 0 (master) 121
Count for PPM_PRODUCT_ATTRIBUTE_GROUPS: 2 (master) 131
Count for PPM_ATTRIBUTE_TYPE_REF: 0 (master) 141
Count for TCARE_PPM_ATTRIBUTES: 8 (master) 151
Count for PPM_ATTRIBUTE_GROUPS: 1 (master) 161
Count for PPM_ATTRIBUTE_GROUP_DEFN: 2 (master) 171
Count for PPM_PRD_TYPE_ATTR_GRP_MAP: 0 (master) 181
Count for PPM_PRODUCT_TYPE_ATTR_MAP_REF: 0 (master) 191
Count for UI_SERVICE_TEMPLATE_MASTER: 1 (master) 201
Count for UI_TEMPLATE_ITEM_MAP: 1 (master) 211
Count for UI_ELEMENTS: 2 (master) 221
Count for UI_ITEM_ELEMENT_MAP: 2 (master) 231
Count for PPM_PRODUCT_TEMPLATE_MAP: 2 (master) 241
Count for PPM_PRODUCT_TYPE_TEMPLATE_MAP: 0 (master) 251
Count for PPM_EVENT_MASTER: 4 (master) 261
Count for PPM_EVENT_PARAMS: 5 (master) 271
Count for PPM_ITEM_EVENT_MAP: 4 (master) 281
Count for UI_ELEMENT_DEPENDENCY: 0 (master) 291
Count for TCARE_PPM_PCAT_INFO: 26 (master) 301
Count for PPM_POLICY_MASTER: 2 (master) 311
Count for PPM_POLICY_ASSOC: 2 (master) 321
Count for PPM_COMPOSITE_ATTR_ASSOC: 0 (master) 331
Count for DISCOUNT_DEFINITION: 2 (master) 341
Count for ITEM_DISCOUNT_MAP: 0 (master) 351
Count for PPM_ITEM_EVENT_MAP: 4 (master) 361
Count for PPM_DECISION_MATRIX: 0 (master) 371
Count for PPM_DECISION_MATRIX_DTL: 0 (master) 381
Count for RMS_USAGE_TYPE_MST_AUD: 92 (master) 10012
Count for TCARE_PPM_PRODUCT_AUD: 29 (audit)
Count for PPM_PROD_COMPONENTS_AUD: 11 (audit)
Count for COMPONENT_DEFINITION_AUD: 11 (audit)
Count for PPM_PROD_ATTRIBUTES_AUD: 4 (audit)
Count for TCARE_PPM_PACKAGE_AUD: 13 (audit)
Count for PPM_PACKAGE_PROD_MAP_AUD: 13 (audit)
Count for PPM_OFFERABILITY_AUD: 5 (audit)
Count for OFFER_RULE_PRD_MAP_AUD: 0 (audit)
Count for PPM_COND_RULE_GROUP_AUD: 0 (audit)
Count for PPM_CONDITIONAL_RULE_AUD: 0 (audit)
Count for PPM_RULE_CONDITION_AUD: 0 (audit)
Count for PPM_RULE_ACTION_AUD: 0 (audit)
Count for PPM_PROD_ATTR_GROUPS_AUD: 2 (audit)
Count for PPM_ATTR_TYPE_REF_AUD: 0 (audit)
Count for TCARE_PPM_ATTRIBUTES_AUD: 8 (audit)
Count for PPM_ATTRIBUTE_GROUPS_AUD: 1 (audit)
Count for PPM_ATTR_GROUP_DEFN_AUD: 2 (audit)
Count for PRD_TYP_ATTR_GRP_MAP_AUD: 0 (audit)
Count for PRD_TYP_ATTR_MAP_REF_AUD: 0 (audit)
Count for SRVC_TEMPLATE_MAST_AUD: 1 (audit)
Count for UI_TEMPLATE_ITEM_MAP_AUD: 1 (audit)
Count for UI_ELEMENTS_AUD: 2 (audit)
Count for UI_ITEM_ELEMENT_MAP_AUD: 2 (audit)
Count for PPM_PRD_TEMPLATE_MAP_AUD: 2 (audit)
Count for PRD_TYP_TEMPLATE_MAP_AUD: 0 (audit)
Count for PPM_EVENT_MASTER_AUD: 4 (audit)
Count for PPM_EVENT_PARAMS_AUD: 0 (audit)
Count for PPM_ITEM_EVENT_MAP_AUD: 4 (audit)
Count for UI_ELEMENT_DEPENDENCY_AUD: 0 (audit)
Count for TCARE_PPM_PCAT_INFO_AUD: 26 (audit)
Count for PPM_POLICY_MASTER_AUD: 2 (audit)
Count for PPM_POLICY_ASSOC_AUD: 2 (audit)
Count for PPM_COMPOSITE_ATTR_AUD: 0 (audit)
Count for DISCOUNT_DEFINITION_AUD: 2 (audit)
Count for ITEM_DISCOUNT_MAP_AUD: 0 (audit)
Count for PPM_ITEM_EVENT_MAP_AUD: 4 (audit)
Count for PPM_DECISION_MATRIX_AUD: 0 (audit)
Count for PPM_DEC_MATRIX_DTL_AUD: 0 (audit)
Count for RMS_USAGE_TYPE_MST: 0 (audit)
Count for PPM_RELEASE_MASTER: 1 (release)
Count for PPM_RELEASE_ENTITY_MAP: 69 (release)
Count for RELEASE_ENTITY_INST_MAP: 151 (release)
Count for APAD_MATRIX: 66528 PC_EXT
Count for APAD_MATRIX: 66528PC_EXT for deletion
Count for COBP_PASS_MATRIX: 90566 PC_EXT
Count for COBP_PASS_MATRIX: 90566PC_EXT for deletion
Count for DEVICE_COMBO_SUBSIDY: 1196 PC_EXT
Count for DEVICE_COMBO_SUBSIDY: 1196PC_EXT for deletion
Count for EASYPHONE_MATRIX: 4428 PC_EXT
Count for EASYPHONE_MATRIX: 4428PC_EXT for deletion
Count for EASYPHONE_UPGRADE: 924 PC_EXT
Count for EASYPHONE_UPGRADE: 924PC_EXT for deletion
Count for FEATURE_GROUP_MASTER: 196 PC_EXT
Count for FEATURE_GROUP_MASTER: 196PC_EXT for deletion
Count for PACKAGE_MAPPING: 4824 PC_EXT
Count for PACKAGE_MAPPING: 4824PC_EXT for deletion
Count for PRODUCT_MAPPING: 583 PC_EXT
Count for PRODUCT_MAPPING: 583PC_EXT for deletion
UPDATE tibtcare_ppm.ppm_replication_status SET status='SOURCE', status_message='success', error_description=NULL, updated_by='REP_990_234' , updated_date=NOW() WHERE replication_job_id='REP_990_234' AND release_id='275.2'




part-b
Count for PPM_PRODUCT_COMPONENT_REF_MAP: 3 ---------------------MASTER-AUDIT------------------
Count for PPM_POLICY_PARAMS: 0 ---------------------MASTER-AUDIT------------------
Count for PPM_POLICY_PARAMS_AUD: 0 ---------------------AUDIT-CHILD------------------
Count for TCARE_PPM_PRODUCT: 29 (master) 11
Count for TCARE_PPM_PRODUCT_COMPONENTS: 11 (master) 21
Count for COMPONENT_DEFINITION: 11 (master) 31
Count for TCARE_PPM_PRODUCT_ATTRIBUTES: 4 (master) 41
Count for TCARE_PPM_PACKAGE: 13 (master) 51
Count for TCARE_PPM_PACKAGE_PRODUCT_MAP: 13 (master) 61
Count for TCARE_PPM_OFFERABILITY_RULE: 5 (master) 71
Count for PPM_OFFERABLE_RULE_PRODUCT_MAP: 0 (master) 81
Count for PPM_CONDITIONAL_RULE_GROUP: 0 (master) 91
Count for PPM_CONDITIONAL_RULE: 0 (master) 101
Count for PPM_RULE_CONDITION: 0 (master) 111
Count for PPM_RULE_ACTION: 0 (master) 121
Count for PPM_PRODUCT_ATTRIBUTE_GROUPS: 2 (master) 131
Count for PPM_ATTRIBUTE_TYPE_REF: 0 (master) 141
Count for TCARE_PPM_ATTRIBUTES: 8 (master) 151
Count for PPM_ATTRIBUTE_GROUPS: 1 (master) 161
Count for PPM_ATTRIBUTE_GROUP_DEFN: 2 (master) 171
Count for PPM_PRD_TYPE_ATTR_GRP_MAP: 0 (master) 181
Count for PPM_PRODUCT_TYPE_ATTR_MAP_REF: 0 (master) 191
Count for UI_SERVICE_TEMPLATE_MASTER: 1 (master) 201
Count for UI_TEMPLATE_ITEM_MAP: 1 (master) 211
Count for UI_ELEMENTS: 2 (master) 221
Count for UI_ITEM_ELEMENT_MAP: 2 (master) 231
Count for PPM_PRODUCT_TEMPLATE_MAP: 2 (master) 241
Count for PPM_PRODUCT_TYPE_TEMPLATE_MAP: 0 (master) 251
Count for PPM_EVENT_MASTER: 4 (master) 261
Count for PPM_EVENT_PARAMS: 5 (master) 271
Count for PPM_ITEM_EVENT_MAP: 4 (master) 281
Count for UI_ELEMENT_DEPENDENCY: 0 (master) 291
Count for TCARE_PPM_PCAT_INFO: 26 (master) 301
Count for PPM_POLICY_MASTER: 2 (master) 311
Count for PPM_POLICY_ASSOC: 2 (master) 321
Count for PPM_COMPOSITE_ATTR_ASSOC: 0 (master) 331
Count for DISCOUNT_DEFINITION: 2 (master) 341
Count for ITEM_DISCOUNT_MAP: 0 (master) 351
Count for PPM_ITEM_EVENT_MAP: 4 (master) 361
Count for PPM_DECISION_MATRIX: 0 (master) 371
Count for PPM_DECISION_MATRIX_DTL: 0 (master) 381
Count for RMS_USAGE_TYPE_MST_AUD: 92 (master) 10012
Count for TCARE_PPM_PRODUCT_AUD: 29 (audit)10
Count for PPM_PROD_COMPONENTS_AUD: 11 (audit)20
Count for COMPONENT_DEFINITION_AUD: 11 (audit)30
Count for PPM_PROD_ATTRIBUTES_AUD: 4 (audit)40
Count for TCARE_PPM_PACKAGE_AUD: 13 (audit)50
Count for PPM_PACKAGE_PROD_MAP_AUD: 13 (audit)60
Count for PPM_OFFERABILITY_AUD: 5 (audit)70
Count for OFFER_RULE_PRD_MAP_AUD: 0 (audit)80
Count for PPM_COND_RULE_GROUP_AUD: 0 (audit)90
Count for PPM_CONDITIONAL_RULE_AUD: 0 (audit)100
Count for PPM_RULE_CONDITION_AUD: 0 (audit)110
Count for PPM_RULE_ACTION_AUD: 0 (audit)120
Count for PPM_PROD_ATTR_GROUPS_AUD: 2 (audit)130
Count for PPM_ATTR_TYPE_REF_AUD: 0 (audit)140
Count for TCARE_PPM_ATTRIBUTES_AUD: 8 (audit)150
Count for PPM_ATTRIBUTE_GROUPS_AUD: 1 (audit)160
Count for PPM_ATTR_GROUP_DEFN_AUD: 2 (audit)170
Count for PRD_TYP_ATTR_GRP_MAP_AUD: 0 (audit)180
Count for PRD_TYP_ATTR_MAP_REF_AUD: 0 (audit)190
Count for SRVC_TEMPLATE_MAST_AUD: 1 (audit)200
Count for UI_TEMPLATE_ITEM_MAP_AUD: 1 (audit)210
Count for UI_ELEMENTS_AUD: 2 (audit)220
Count for UI_ITEM_ELEMENT_MAP_AUD: 2 (audit)230
Count for PPM_PRD_TEMPLATE_MAP_AUD: 2 (audit)240
Count for PRD_TYP_TEMPLATE_MAP_AUD: 0 (audit)250
Count for PPM_EVENT_MASTER_AUD: 4 (audit)260
Count for PPM_EVENT_PARAMS_AUD: 0 (audit)270
Count for PPM_ITEM_EVENT_MAP_AUD: 4 (audit)280
Count for UI_ELEMENT_DEPENDENCY_AUD: 0 (audit)290
Count for TCARE_PPM_PCAT_INFO_AUD: 26 (audit)300
Count for PPM_POLICY_MASTER_AUD: 2 (audit)310
Count for PPM_POLICY_ASSOC_AUD: 2 (audit)320
Count for PPM_COMPOSITE_ATTR_AUD: 0 (audit)330
Count for DISCOUNT_DEFINITION_AUD: 2 (audit)340
Count for ITEM_DISCOUNT_MAP_AUD: 0 (audit)350
Count for PPM_ITEM_EVENT_MAP_AUD: 4 (audit)360
Count for PPM_DECISION_MATRIX_AUD: 0 (audit)370
Count for PPM_DEC_MATRIX_DTL_AUD: 0 (audit)380
Count for RMS_USAGE_TYPE_MST: 0 (audit)10011
Count for PPM_RELEASE_MASTER: 1 (release)1
Count for PPM_RELEASE_ENTITY_MAP: 69 (release)2
Count for RELEASE_ENTITY_INST_MAP: 151 (release)3
Count for APAD_MATRIX: 66528 PC_EXT
Count for APAD_MATRIX: 66528PC_EXT for deletion
Count for COBP_PASS_MATRIX: 90566 PC_EXT
Count for COBP_PASS_MATRIX: 90566PC_EXT for deletion
Count for DEVICE_COMBO_SUBSIDY: 1196 PC_EXT
Count for DEVICE_COMBO_SUBSIDY: 1196PC_EXT for deletion
Count for EASYPHONE_MATRIX: 4428 PC_EXT
Count for EASYPHONE_MATRIX: 4428PC_EXT for deletion
Count for EASYPHONE_UPGRADE: 924 PC_EXT
Count for EASYPHONE_UPGRADE: 924PC_EXT for deletion
Count for FEATURE_GROUP_MASTER: 196 PC_EXT
Count for FEATURE_GROUP_MASTER: 196PC_EXT for deletion
Count for PACKAGE_MAPPING: 4824 PC_EXT
Count for PACKAGE_MAPPING: 4824PC_EXT for deletion
Count for PRODUCT_MAPPING: 583 PC_EXT
Count for PRODUCT_MAPPING: 583PC_EXT for deletion
UPDATE tibtcare_ppm.ppm_replication_status SET status='SOURCE', status_message='success', error_description=NULL, updated_by='REP_990_234' , updated_date=NOW() WHERE replication_job_id='REP_990_234' AND release_id='275.2'
  please verify if part a and part b are same or not