job still in running

[loric]

I have a simple ds job: Dataset - lookup with a table - lookup with an other table - load in table.
The job remain in running ......without a reason!:-(

Could someone help me?

[ArndW]

Loric,

you have just asked the car-equivalent question of "My car always stops running after I start it. Why?". How can we answer you question without knowing more about your problem.

a) there is always a reason.
b) Does it always "hang"
c) Does it process a number of rows or stop at the first row?
d) What stage is causing the problem? (you need to debug this yourself, but commenting out or replacing stages and adding "peek" stages)

There will be more questions depending on the answers, but it will provide a start.

[manteena]

I think Table look up is kiiling your time...
If data sets are small enough handle with hash files...
Then you'll see it stops sometime

[richdhan]

Loric,

Make sure if there any locks on database tables.

If you are on Oracle just check the following with your DBA

Code: Select all

1. select * from v$lock where type = 'TM'

ADDR     KADDR           SID TY        ID1        ID2      LMODE    REQUEST
-------- -------- ---------- -- ---------- ---------- ---------- ----------
     CTIME      BLOCK
---------- ----------
803EECF0 803EED04         53 TM     251183          0          3          0
      2423          0


2. select object_name from dba_objects where object_id = 251183

HTH
--Rich

[kumar_s]

Hi,
What do you find in director
Is it stoped at certain stage??
Is it not starting??
Is it progressing slowly??
The same is experienced for multiple runs??
Answer for each question may give different result.


-Kumar