We need to load the report details into report table on daily basis. We will load the 10 different mainframe report files into teradata report table using 10 Mload job.
But sometimes 2 mload jobs running on same time, results report table being loaded. As a temporary solution, we will restrt the job from sometime and it works ok.
For Permanent solution, we can use TPUMP to load the utility as Tpump uses row hash lock not table lock. is this solution will work?
Solved! Go to Solution.
yes thats better option. We will try that and update you.
Another one clarification - We have one bteq script and one Mload script loading teradata table from external source.
We have usually had table being loaded abend in bteq script, in that case we is there any option to avoide these kind of failures? like adding tablewait in Mload, we can had sleep in bteq?
Your idea please