Page 1 of 1
job still in running
Posted: Wed Nov 30, 2005 8:35 am
by 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?
Posted: Wed Nov 30, 2005 9:52 am
by 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.
Posted: Wed Nov 30, 2005 12:22 pm
by 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
Posted: Fri Dec 02, 2005 2:46 am
by 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
Posted: Sat Dec 03, 2005 6:14 am
by 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