I have MLOAD failure as below
CHECK WORKLOAD FOR BEGIN MLOAD PM_EDW_MSTR_D.d_SERV_INTRCTN;
**** 06:00:44 UTY0817 MultiLoad submitting the following request:
CHECK WORKLOAD END;
**** 06:00:45 UTY0812 MLOAD session(s) requested: 12.
**** 06:00:45 UTY0815 MLOAD session(s) connected: 12.
**** 06:00:45 UTY0817 MultiLoad submitting the following request:
BEGIN MLOAD PM_EDW_MSTR_D.d_SERV_INTRCTN WITH INTERVAL;
**** 06:00:45 UTY0805 RDBMS failure, 2635: Error tables are invalid OR
d_SERV_INTRCTN is in an invalid state for Load - Target Table is not
fallback and an AMP is down.
By analysing I found that there is an error related to MLOAD log file table. Now when I am trying to select the table showing table is moved to another MAP. When I tried to Drop the table its showing data corruption detected in DBC.TVFIELDS table.
On the same note: we had couple of Node failure last week. We are facing the issue after the DIMMs replacement.
Can you please suggest how can I drop this Table?