friends ,
when i start one of my jobs it's showing 600rows/sec and dropping that number rapidly to somewhere around 20rows/sec.
when i check with my DBA there are 16 locks on that perticular table from uvsh@dsservermechine .if we release those locks and restarts the job the same is happening.
this abnormal behavior is showing from last weekend(both of our database server and datastage servers are crashed during that weekend)
couple of other jobs(with different table) won't run at all(0 rows/sec) and once after releasing those locks they runs fine.
pl advise me how to resolve this problem
thanks
database locks
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
What Sainath was saying is that your job might be doing alot of look ups and trying to write or update to the same database table.scottr wrote:the job is able to write the data into seq file...
Instead of doing the insert and updates into the database in the same job, put the records that you want to insert or update into a seq file. Then create a second job to insert/update the records from the seq file into the database.