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
My job is running runnig still runnig
Moderators: chulett, rschirm, roy
My job is running runnig still runnig
vijayakumargoud
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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.
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.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
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
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
vijayakumargoud