Interested to Buy Any Domain ? << Click Here >> for more details...
How to relege locks in fastload and multiload? example?
- 4 Answers
- 22756 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siva
In mload lock
in accquisition phase Release mload databasename.tablename
in application phase Release mload tablename .in apply
In fload between begin loading and end loading there not
write any code and run the script.locks will be relesed
| Is This Answer Correct ? | 19 Yes | 0 No |
Answer / vinay sir(datawarehousing tech
Little more clear description for the above two answers.
RELEASING LOCKS IN MLOAD:
We need to use the below RELEASE MLOAD command in BTEQ.
Acquisition Phase: RELEASE MLOAD TABLE1....TABLE5
Application Phase: RELEASE MLOAD TABLE1....TABLE5 in Apply
RELEASING LOCKS IN FASTLOAD:
Assue the table is Party and it is using ERparty and UVparty
tables as its error tables.Then use the below script(Called
Empty Script) for allowing operatins on the Party table.
.logon <>
database VINAY;
BEGIN LOADING Party
ERRORFILES ERparty,UVParty
CHECKPOINT 10;
END LOADING;
.logoff
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / 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 |
Answer / tdguy
mload: release mload dbname.tablename or release mload
dbname.tablename in apply.
fload: script with only begin loading and end loading
commands will release the locks.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is a node in teradata?
Explain the term 'foreign key' related to relational database management system?
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
Explain vproc in teradata?
in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?
Where we use PPI in real time??? What is the disadvantages of PPI?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
What is a node in teradata? Explain
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is dimensional modeling?
Teradata 
