TPUMP Help

Database
Enthusiast

TPUMP Help

Hi,

 

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?

 

Please help


Accepted Solutions
Teradata Employee

Re: TPUMP Help

TPump does use RowHash locking. Whether that allows two jobs to run at once or not will depend on the Primary Index for the target table.

 

How about a simpler workaround: Use the TABLEWAIT option in the existing MLOAD jobs?

1 ACCEPTED SOLUTION
2 REPLIES
Teradata Employee

Re: TPUMP Help

TPump does use RowHash locking. Whether that allows two jobs to run at once or not will depend on the Primary Index for the target table.

 

How about a simpler workaround: Use the TABLEWAIT option in the existing MLOAD jobs?

Enthusiast

Re: TPUMP Help

Thanks Fred.

 

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