The job generates a lot of "indoubt transaction" and then locks the application!!!!

M_RAS · #1 (**permalink**) 08-03-06, 13:20

Hi ,
I use db2 v8.2.3 fix pak 10 aix 5.2

recently we upgrade db2 v8 from fix pak 7 to fix pak 10 and then we encountered a lot of problem.

after runing the job we get a lot of "indoubt transaction" and application locks

any idea how can I resolve this problem?

Thank you in advance.

sathyaram_s · #2 (**permalink**) 08-03-06, 14:52

Can you post some snapshots ???

Sathyaram

M_RAS · #3 (**permalink**) 08-03-06, 15:06

Quote:

Originally Posted by sathyaram_s

Can you post some snapshots ???

Sathyaram

Thank you sathyaram for your reply,

I will, but now I am doing reorge, convert to type2 and runstats and it will take long at lease 18 hours (it is 200 gig database) if it did not resolve the problem I will let you know.

in point of db or dbm parameters do you have any recomendation?

Internet Services

Web Development

Digital Marketing

Consumer Tech