database locks

scottr · Post by **scottr** » 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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Mar 17, 2005 3:02 pm

Look into your job for actions you are doing against the db tables.

Better write into seq or hash files and use single point of load.

scottr · Post by **scottr** » Thu Mar 17, 2005 3:56 pm

the job is able to write the data into seq file...

tcj · Post by **tcj** » Thu Mar 17, 2005 11:45 pm

scottr wrote:the job is able to write the data into seq file...

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.

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.

scottr · Post by **scottr** » Mon Mar 21, 2005 3:16 pm

this one solved when last weekend both database and datastage servers are downed for maintaince.

thanks for ur suggestions.