Environment: Teradata, Informatica , Unix. I aborted a workflow in Informatica that used a mload connection. I also killed the Mload process running on unix box. Now I want to clean up the DB by releasing the mload on the table & also removing the ET, UV, WT, ML tables. Though the "release mload" command says "Mload not active on this table", I'm unable to drop the ET, UV, WT, ML tables. Please suggest on how to get this lock released.
Thanks Farid for your help on this. Actually there was a lock pending on the table from database side (Not really sure why this was still there). My DBA helped me get that released. Now the load is running fine.