DB2 logging and rollback

[Ifisher]

When doing updates within a cobol program, what is db2 logging. Is it logging only info about the rows that were updated or is it also keeping up with the records read?

We had a situation where a cobol program terminated unsuccessfully and db2 went into a rollback mode. There were only 2 updates done but tons of reads. It took several hours to rollback the 2 updates. Why? Also, we tried to cancel the job from the JES active queue but could not. My other question is, how can we cancel/purge jobs while DB2 is rolling back?

Thanks, Irma

 

[cdlvj]

For one thing the app is in transaction mode and locking everything which being read.

And everything is being rolled back. The system does not know if a change took place.

So the app needs to selectively begin trans and commit for the updates.

 

[gregsimpson]

Irma,

maybe examining your Bind parameters as regards Cursor Stability and Isolation etc.

Cheers
Greg