Hi,
Till now I was of the opinion that two different parallel jobs loading the same table in database cannot run simultaneoulsy.But today, I saw two parallel jobs(DS v8.5.1) loading the same table simultaneoulsy.The target stage was Oracle connector.Am I missing something? Can anyone explain this better.
Loading same table in db by 2 different parallel jobs
Moderators: chulett, rschirm, roy
Re: Loading same table in db by 2 different parallel jobs
Two jobs are running / loading? There is a difference between the statementsSuruchi wrote:loading the same table simultaneoulsy.
Whatever may be the source, Oracle need to be configured in such a way to handle the situation like locking systems, timeout, in some cases partitions.
Fine, let us know what is the load method in those two Datastage jobs?
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
Parallel inserts are allowed on the tables.Suppose that the table you mentioned is loaded by only one parallel job in your project and the job runs on 8 nodes.It is implicit that it is allowing 8 parallel insert statements.
In your case the table is loaded by two jobs and assuming your job runs in 2 nodes/4 nodes in these cases you will have 4 inserts or 8 inserts respectively which is a normal scenario.
In your case the table is loaded by two jobs and assuming your job runs in 2 nodes/4 nodes in these cases you will have 4 inserts or 8 inserts respectively which is a normal scenario.
N.Srinivas
India.
India.
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
What load tecnique you are using in connector stage...bulk load or normal load?
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/