My Table Got Locked During Mload Due To A Failed Job. What Do I Do To

1.	My Table Got Locked During Mload Due To A Failed Job. What Do I Do To Perform Other Operations On It?
Answer» Using RELEASE MLOAD. It removes access LOCKS from the target tables in Teradata. It MUST be ENTERED from BTEQ and not from MultiLoad. To proceed, you can do RELEASE MLOAD <table name>. Using RELEASE MLOAD. It removes access locks from the target tables in Teradata. It must be entered from BTEQ and not from MultiLoad. To proceed, you can do RELEASE MLOAD <table name>.

My Table Got Locked During Mload Due To A Failed Job. What Do I Do To Perform Other Operations On It?

Answer»

Using RELEASE MLOAD. It removes access LOCKS from the target tables in Teradata. It MUST be ENTERED from BTEQ and not from MultiLoad. To proceed, you can do RELEASE MLOAD <table name>.

Using RELEASE MLOAD. It removes access locks from the target tables in Teradata. It must be entered from BTEQ and not from MultiLoad. To proceed, you can do RELEASE MLOAD <table name>.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Basic Rules That Define How Pi Is Defined In Teradata?
What Is A Common Data Source For The Central Enterprise Data Warehouse?
What Are The Enhanced Features In Teradata V2r5 And V2r6?
What Is An Optimization And Performance Tuning And How Does It Really Work In Practical Projects?
Teradata Performance Tuning And Optimization?
Can We Load A Multi Set Table Using Mload?
Can I Use "drop" Statement In The Utility "fload"?
In A Table Can We Use Primary Key In One Column And In Another Column Both Unique And Not Null Constrains.if Yes How?
What Are The Types Of Tables In Teradata ?
Can You Recover The Password Of A User In Teradata?

My Table Got Locked During Mload Due To A Failed Job. What Do I Do To Perform Other Operations On It?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment