How to relege locks in fastload and multiload? example?
Answer Posted / yuvaevergreen
For mload,
release mload in apply can be used to forcefully remove the lock from the target table.
For fload,
Locks on target table will not be released until end loading statement completes. I hope fload should be run only with begin and end loading statements. Please add, if you find more....
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How to select first n records in teradata?
Explain the meaning of Amp?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Steps to create a data model?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are the advantages of teradata?
What is the basic syntax for teradata select statement?
Difference between star and snowflake schemas?
What does Amp contain and what are all the operations that it performs?
How many tables can you join in v2r5?
Why managing the data is important?
If RDBMS is halted what will you do ?
What is meant by a Least Cost Plan?
Explain the term 'tables' related to relational database management system?