Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to relege locks in fastload and multiload? example?

Answers were Sorted based on User's Feedback



How to relege locks in fastload and multiload? example?..

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

How to relege locks in fastload and multiload? example?..

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

How to relege locks in fastload and multiload? example?..

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

How to relege locks in fastload and multiload? example?..

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

Post New Answer

More Teradata Interview Questions

Different phases of multiload?

0 Answers  


What are the various indexes in teradata?

0 Answers  


Discuss the advantages of using partitioned primary index in a query?

0 Answers  


how to delete duplicate records in multi set table without using any tables

2 Answers   Accenture, Nest, South Nests Software Solution, Spiro Solutions,


What is the diffrence between Multiload & Fastload interms of Performance?

8 Answers   Cap Gemini, Intel,


what is the structure of UV table in MLOAD?

4 Answers   Cap Gemini,


How many types of joins are there in teradata?

0 Answers  


Which is faster fastload or multiload?

0 Answers  


Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?

2 Answers  


Explain vproc in teradata?

0 Answers  


What are aggregate tables? How do you design them using teradata?

0 Answers  


What are the newly developed features of Teradata?

0 Answers  


Categories