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
How do you determine the number of sessions?
How do you set the session mode parameters in bteq?
If RDBMS is halted what will you do ?
Is multi insert ansi standard?
Explain the advantages of partitioned primary index in a query?
What are the newly developed features of Teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What are the multiload utility limitations?
What is the command in bteq to check for session settings ?
What are the joins in teradata?
What is the difference between teradata and basic rdbms?
Why managing the data is important?
What exactly do you know about catching in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Explain the new features of teradata?