How to find FLOAD/MLOAD lock on list of tables

Database
SAP
Enthusiast

How to find FLOAD/MLOAD lock on list of tables

Hi All,

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 .

Thanks !!!

2 REPLIES
Teradata Employee

Re: How to find FLOAD/MLOAD lock on list of tables

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

SAP
Enthusiast

Re: How to find FLOAD/MLOAD lock on list of tables

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 .