database locks
Posted: Thu Mar 17, 2005 1:14 pm
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
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