My job is running runnig still runnig

[vasam]

Hi All,

I have a job like
I am extacting maximum key value from Teradata(source), i am just deleting recording from ORACLE table whcih are having more than maximum key value.

when i ran this job its running, running.....

Here i am using 2node config file.

could please suggest me why my job still running

Thanks in advance
Vijay

[ArndW]

Typically neverending jobs are causing by blocks or locks on the database side. Try your job writing to a peek stage instead of to Oracle. Does it hang?

[chulett]

Or run it on a single node.

[vasam]

Thanks for your Quick Respondings...

I ran the job on Single node also i am facing same problem. job is still running...


Thnaks,
Vijay

[priyadarshikunal]

Is it a big table?
Is the column in constraint indexed?
how many records getting deleted?
are there duplicate keys being passed to delete?

Deletes are expensive and can take a lot of time to delete huge number of records. get your DBA to monitor for any locks being created on database.

Also tell us more about the job design.

[chulett]

A single node should remove any locking issues from the table. As noted, deletes are very expensive - how many does the job need to do? What are you seeing in the Monitor?

[vasam]

My Source table(Teradata) having only 89 records.
Target table(Oracle) having only 29 records which are greater than maximum key value.

As you guys are suggested i have used peek insted of Oracle(Target) that my job ran fine.

my job design
teradata ---> T/R -------> Oracle

Thanks,
Vijay

[chulett]

How many records total in the target table? Is the field you are deleting based on indexed? Wondering about full table scans...