Interested to Buy Any Domain ? << Click Here >> for more details...
How to relege locks in fastload and multiload? example?
- 4 Answers
- 22795 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 |
Where is teradata rdbms used?
Aborted in Phase 1 data Acquistion Incomplete in fastload?
Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE
How do you load Multiple files to a table by using fastload scripts?
How to view every column and the columns contained in indexes in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
What are the commands to make a new table, change a table and remove a table in teradata?
What is FILLER command in Teradata?
Difference between Qualify and group
Teradata 
