Loading same table in db by 2 different parallel jobs

[Suruchi]

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.

[SURA]

loading the same table simultaneoulsy.

Two jobs are running / loading? There is a difference between the statements

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?

[Suruchi]

Load method is append in both the jobs.

[eph]

Hi,

You have in the bulk load options a "Allow concurrent load sessions" that allow you to run the stage in parallel. I suppose it also allows the behavior that you describe (no locks?)?

Eric

[srinivas.nettalam]

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.

[prasson_ibm]

What load tecnique you are using in connector stage...bulk load or normal load?