Dong Shin 02.11.2014

  • found that a query is missing in Post Processing in Reqonciler for updating cognos data relations after new ingest….
    • UPDATE budget_center_contracts LEFT JOIN (SELECT bcc.uid as tuid, c.uid as cuid FROM budget_centers c, budget_center_contracts bcc WHERE c.sub_budget_center_number = bcc.sub_budget_center AND c.req_id = bcc.requisition_id AND ISNULL(bcc.budget_center_id)) t ON budget_center_contracts.uid = t.tuid SET budget_center_contracts.budget_center_id = cuid WHERE NOT ISNULL(t.tuid)
  • alter table syntax….
    • ALTER TABLE t COMMENT '';
  • need to look at these… mine are set to 16777216 – show variables
    • Check the value of max_heap_table_size variable
    • Check the value of tmp_table_size variable