Job still running

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rafidwh
Participant
Posts: 179
Joined: Mon Oct 10, 2005 11:30 pm

Job still running

Post by rafidwh »

Hi All,

I am loading into oracle table from a Dataset.
But the job never completes and in the director it doesn't show up any wanings or any status message ,it shows in the running stage.

Please share your knowledge on this...

Regards,
Rafidwh
Top
g_rkrish
Participant
Posts: 264
Joined: Wed Feb 08, 2006 12:06 am

Re: Job still running

Post by g_rkrish »

rafidwh wrote:Hi All,

I am loading into oracle table from a Dataset.
But the job never completes and in the director it doesn't show up any wanings or any status message ,it shows in the running stage.

Please share your knowledge on this...

Regards,
Rafidwh
Did you check with your Database to check any deadlocks....
RK
Top
kausikMitra
Participant
Posts: 5
Joined: Fri Feb 24, 2006 1:05 am
Location: Melbourne

Re: Job still running

Post by kausikMitra »

Since you are using Oracle Stage, its doing Bulk load by using SQLLDR internally. You have to set an APT value for SQLLDR this by giving value (DIRECT=FALSE, PARALLEL=TRUE) and make the index option maintenance.

Pls let me know how it goes.
Regrads
Kausik Mitra
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

There is NO WAY this question belongs in the server forum.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”