What is job commit in Datastage?

What is job commit in Datastage?
If I am working on parallel jobs, how can I give this option(in each odbc satge) that commit should perform after specific number of records transaction.
Please help
  • Interview Candidate
  • 4
  • 16003

Showing Answers 1 - 4 of 4 Answers

SinhaS

  • Aug 4th, 2011
 

Its a property of DB2/UDB Enterprise Stage. You should normally use the input property Row Commit Interval to
specify the number of records to insert into a table between commits. Previously the environment variable
APT_RDBMS_COMMIT_ROWS was used for this, and this is still available for backwards compatibility.

  Was this answer useful?  Yes

Santhu7

  • Aug 16th, 2011
 

In DRS stage you have Transaction Isolation ,Set to "read committed".And set Array Size and Transaction Size to 10 ,1000.So that it will commit for every 1000 records.
Please let me know,If I am wrong
Cheers
Santhu

Venkat Duvvuri

  • Sep 9th, 2011
 

Hi Im not sure which version of datastage you r using..this is pretty much simple in Datastage8.5 by using DTS

Thanks n Regards
Venkat Duvvuri

  Was this answer useful?  Yes

RAJESH

  • Sep 11th, 2011
 

Read Committed and arraysize u option in target ODBC stage.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions