Is it possible to capture FLOAD lock and MLOAD lock using ERROR HANDLER in Teradata Procedure . If yes , please let me know the steps / sample . If not , please suggest a better way to capture FLOAD lock and MLOAD lock .
My requirement :-
We have list of 600 tables . I need to find list of tables which are locked before starting my workflow . Please suggest a betterway .
For fastload you can query sysadmin.fastlog . it will show so the pending operation table due to fastload. or you can ask you DBA to run checktable with pendingop mode to find the lock table due to fastload/mload
Thanks a lot Sandeep .
But , I will not have access to sysadmin.fastlog and its not feasible to contact my DBA all the time . PLease suggest me with someother workaround .